So I have some VBA code that saves to network drive Excel files based on their store number, after it
all finishes to process using the VBA script, it creates a log sheet which shows me all the Excel files that were saved and
processed. The log file is just a plain sheet that records the locations of the save in the network drive and the excel
I send a notification to employees, they use those files and fill in some data into the sheets and then
at the end of the month, we need to grab those files back from the network drive for analysis. The files are in the same
exact network path and the file names will not change, what would be the best way to grab those files back from the network
drive and import them into a workbook using VBA ?
I was thinking of using something that would be able to work by
selection, or I select the rows and then have Excel import the selected files into a single workbook, to give an example:
Let say that I have 5 rows in the Log sheet in column A and each row represents a successful save:
I would like to be able to play a VBA script, it would allow me
to highlight by selection the range that I want to process, so in this example I would highlight A1:A5 and then I would
continue the VBA procedure and Excel would import those 5 Excel files into a single workbook, so 5 sheets in this case, each
representing the document imported ?
I was looking into Application.GetOpenFilename, but I am not sure what the
best way is yet, I figured I would start here and get every ones opinion.
Thanks a lot in advance for your help