Originally Posted by
rpeare
I don't understand. If you are getting your excel file from an external source why do you need to open the file, then close and save it?
I don't really do things with macros, I do it with code but if you're trying to open an excel file with the same file name all the time it would be in it's most basic form:
application.followhyperlink <path and file name here>
you would just have to supply the correct path and file name as a string
i.e. application.followhyperlink "c:\test\testexcel.xlsx"