VBA Code to retrieve data, from a Filepath

[ajay_gajree]

VBA Code to retrieve data, from a Filepath, copy it to a specific raw data sheet in a different Workbook.

Hi,

I have a spreadsheet with historic data with Charts etc. The daily data for it is dumped in a specific folder each day.

At the moment I open up the raw data, copy it and then paste it into a Raw Data Tab in my workbook which is elsewhere. I then click my macro button to format the data as required.

Is it easy to retrieve the data automatically by some sort of pop up box to specify the path of the next days data? The only thing that changes for the raw data file name is the date.

Some hints would be good!

Best regards