Hello all
I have had so much help from this wonderful community so I had to bring my latest problem here.
I have a spreadsheet that imports backup files from an intranet 'tool' and uses the data for MI reporting.
The tool is new and has had days when it was out of action and so has left gaps in the back up files.
Because my spreadsheet opens the files in via a macro and follows a logic path to determin the names (date) of the files it needs to open and then copies the worksheet into my workbook, where the file does not exist i get an error.
without using an error handler is there any kind of 'if' statement that can refrence the fact that the file is not found - or is there code to search for the file before opening it so i can use an if statement before trying to open it?
I have had so much help from this wonderful community so I had to bring my latest problem here.
I have a spreadsheet that imports backup files from an intranet 'tool' and uses the data for MI reporting.
The tool is new and has had days when it was out of action and so has left gaps in the back up files.
Because my spreadsheet opens the files in via a macro and follows a logic path to determin the names (date) of the files it needs to open and then copies the worksheet into my workbook, where the file does not exist i get an error.
without using an error handler is there any kind of 'if' statement that can refrence the fact that the file is not found - or is there code to search for the file before opening it so i can use an if statement before trying to open it?