Opening spreadsheets with a macro.

M

Mike Swearingen

Joined
Feb 27, 2009
Messages
1
Reaction score
0
I have a question about Excel 97 and macro's. I'm trying to set up a macro to open another Excel spreadsheet, the problem is that spreadsheet is created by a different program and it changes the save name every time it creates a new spreadsheet. The name is always the same format though, it starts with the same 3 letters and then adds the current date, i.e. "OAV022709". The "OAV" part is always the same and the date, "022709" is for February 27, 2009. Any body have any ideas as to how to do this with a macro?
 
Back
Top