Home » Forums » Open Source Learning Center » Question and Answer

Open & Copy Excel file with path and filename in a cell

Submitted by gramercynewyork on 17 July, 2013 - 21:29

Hi Everyone,

I am trying to write a macro to open and import data from another Excel file. The thing is, I already have the path and filename in a cell that I would like to open and import data from. The file the I am importing data from is a daily download file with dates in the title (for example, Report as of 20130716.csv) I don't want to have to open this file everyday and copy and paste it into another file.

Can someone help me?
Thanks

Robert

‹ Why does excel calculate incorrect? Please analyise the given data and provide your insights in how can I use pivot table and functions of excel ›
»
Nick's picture

have a look at

Submitted by Nick on 18 July, 2013 - 08:41.

have a look at this:
http://excelexperts.com/VBA-Tips-Import-A-Text-File
... it works for importing Excel files too, just change the macro to pick up the file location from the cell where the file path is..

»

Thanks!

Submitted by gramercynewyork on 18 July, 2013 - 14:54.

Thanks!

»