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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Issue is facing on Word 2016 -{EMBEDED Excel.Sheet.12} 0
Command Line to Open/Close an Excel Files , macro print it in a designated Folder 1
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Macro works but also runs original spreadsheet 5
Open an excel spreadsheet and run a macro from Access VB 2
Copying data from several spreadsheets into a new spreadsheet 2
I am trying to use the IF and SUMIF function on Excel 8
How to Create a Macro to Import External Data 0

Back
Top