Sam Longstaff
Member
Hi,
I have xls file created automatically each week by another program that then saves the file in a known location on my network drives. These files are automatically named as "Work stats" with the date concatenated on the end e.g. work stats 10 07 18.xls
My question is: how do I set up a workbook, where each sheet is one week and each sheet pulls in the data created in the relevant weekly work stats file?
I understand how to get data from an external source but how can it be done where the file path does not exist yet because the source files are created automatically and as such future week's files are not there yet to be mapped to?
Any pointers greatly appreciated.
I have xls file created automatically each week by another program that then saves the file in a known location on my network drives. These files are automatically named as "Work stats" with the date concatenated on the end e.g. work stats 10 07 18.xls
My question is: how do I set up a workbook, where each sheet is one week and each sheet pulls in the data created in the relevant weekly work stats file?
I understand how to get data from an external source but how can it be done where the file path does not exist yet because the source files are created automatically and as such future week's files are not there yet to be mapped to?
Any pointers greatly appreciated.