Creating macro for to open different excel files 
Author Message
 Creating macro for to open different excel files

Save your macro into your personal workbook personal.xls.
You can do this in the VB editor, or when creating the
next one, select where you want to store it.

The personal workbook is available every time you start
Excel.

Steve

Quote:
>-----Original Message-----
>Hi There,

>I wonder if somebody can help me on how to create a macro
>that can be used to open a different excel file.  

>here's the scenario:

>I recieved an excel file twice a month with a slightly
>different format (more rows but constant column)through
>email and I just double click them to open it. How do I
>open it together with my existing macro so that I don't
>spend much time create another macro?

>I would appreciate very much anybody's help.

>Regards
>Freddie

>.



Sat, 04 Jun 2005 10:35:23 GMT  
 
 [ 1 post ] 

 Relevant Pages 

1. Need excel macro to backup open file but with a different name each day

2. when opening an excel file programatically, the newly opened file's Auto_Open macro runs

3. Creating a tab delimted file from 3 different tables(macro preferred)

4. Using an auto open macro to create a replacement auto open macro

5. Creating macro on how to save file within Excel file

6. Cannot open Excel file even though it was created and saved in Excel

7. Excel 2000 can't open file created in Excel 97

8. Printing in Excel 97 creates different results from different computers

9. Excel crashes when opening an excel file created on a Mac

10. Opening Macro on opening excel file?


 
Powered by phpBB® Forum Software © phpBB Group