I have a workbook which imports date from several csv files in a fixed directory. I've been working with the same files with no problems for a day. After closing the excel workbook down overnight, and re-opening it the next day i suddenly get an error message when i try to import the data.
Run-time error '1004'
Excel cannot find the text file to refresh this external data range.
Check to make sure the text file has not been moved or renamed, then try the refresh again.
I've made no changes to the excel sheet or the data files, they are all in the same directories as yesterday but I cannot get passed this error message.
The data import is performed using a vba macro (which worked perfectly yesterday) now it's Kaput.
Anyone have any ideas?
Run-time error '1004'
Excel cannot find the text file to refresh this external data range.
Check to make sure the text file has not been moved or renamed, then try the refresh again.
I've made no changes to the excel sheet or the data files, they are all in the same directories as yesterday but I cannot get passed this error message.
The data import is performed using a vba macro (which worked perfectly yesterday) now it's Kaput.
Anyone have any ideas?