Hi all,
Basically I want to automate the importation of a Text/CSV file into my Excel. The problem that I am having is that the pathway and file name of my source changes on monthly basis.
For example:
For the month of January, a January folder is created where all the data in dumped in. So the source file name would be something like "Data_Jan_2019". Next month, another folder is created (February) and all the data relating to that month.
Seeing as my pathway and source file name is not constant, how can I automate this? Is there a way to program excel to say: If the month and year in the sheet is Jan 2019, go get the file from the folder January 2019
***Note: I have recently started playing around with VBA. I'm a complete rookie. For the time-being, I am "manually" recording my Macros and later going to observe the VBA code to learn.***
Thank you for your patience!
Basically I want to automate the importation of a Text/CSV file into my Excel. The problem that I am having is that the pathway and file name of my source changes on monthly basis.
For example:
For the month of January, a January folder is created where all the data in dumped in. So the source file name would be something like "Data_Jan_2019". Next month, another folder is created (February) and all the data relating to that month.
Seeing as my pathway and source file name is not constant, how can I automate this? Is there a way to program excel to say: If the month and year in the sheet is Jan 2019, go get the file from the folder January 2019
***Note: I have recently started playing around with VBA. I'm a complete rookie. For the time-being, I am "manually" recording my Macros and later going to observe the VBA code to learn.***
Thank you for your patience!
