macro needs to access a file which currently does not exist .
Posted by Tonyg on August 30, 2001 2:59 AM
I need my macro to pause and get a file reference before it continues to create a pivot table from the file. The file will be created at the end of each Quarter year and hopefully the macro will transfer some of the data to a more comprehensive Spreadsheet.Has anyone come across this problem? If so how is it overcome?
Posted by Dax on August 30, 2001 4:30 AM
Hello,
Have a look at Application.GetOpenfilename method. It brings up the standard open dialog box and allows the user to select a file. It returns the full path of the file selected which you can then use in your macro.
HTH,
Dax.
