How to create a macro that open multiple Excel files. . ..

[James989]

Hi,

.....and automatically run the macro in each file ?

I have five different excel files and stored in :-

c:\temp\file1.xls
.
.
.
c:\temp\file5.xls



Regards


James

 

[Debraj]

For a single time..
Open all the file.. in same excel instance..
Arrange the file's position if required..
In View menu.. Save Workspace.. and give it a desired name..

Next time.. just simply opne the Workspace.. it will open all the file with same setted position..

PS: Is really VBA required.. !!

 

[James989]

For a single time..
Open all the file.. in same excel instance..
Arrange the file's position if required..
In View menu.. Save Workspace.. and give it a desired name..

Next time.. just simply opne the Workspace.. it will open all the file with same setted position..

PS: Is really VBA required.. !!

how to make sure macros in each file will run automatically once open the workspace ?

 

[Debraj]

how to make sure macros in each file will run automatically once open the workspace ?

Simple.. by testing..

 

[James989]

Simple.. by testing..

All 5 files are with " Autpen" macros, once I open the workspace, only 1 file run automatically, all other 4 files just open but the macro not running ! How to solve ?

 

[Debraj]

No.. its not a problem with Workspace.. its problem with your setting..
All files need to "Enable content" upon open. So you have to click each "Enable Option" option..
or
Go to excel Option > Trust Center > Trusted Location > Set the desired folder (in your case c:\temp\) as a trusted location it will not ask to "enable macro" for those files..

 

[James989]

No.. its not a problem with Workspace.. its problem with your setting..
All files need to "Enable content" upon open. So you have to click each "Enable Option" option..
or
Go to excel Option > Trust Center > Trusted Location > Set the desired folder (in your case c:\temp\) as a trusted location it will not ask to "enable macro" for those files..

I have added the trusted location(c:\temp\) but once open workspace, still only 1 file running. Please help !

Attached herewith 2 files for your testing.

 

[Debraj]

Hi James..

Few point..
* Auto_Open is old method.. try to convert it to Workbook_open method.
http://www.ozgrid.com/VBA/auto-run-macros.htm

* Your code conatin code from some external Add-Ins (EasyFitXL) .. sorry.. but this feature is not available in my system

 

[James989]

sorry, attached herewith the new files and please help me to test it. I have changed it to Rnd.

 

[SirJB7]

Hi, James989!
Give a look at the uploaded file. You'll find there the 2 fixed files (Workbook_Open), the used workspace (workspaceando.xlw) and a printscreen of the immediate window pane. The only issue is that the workbook 1 always runs twice.
Regards!

@Debraj(ex-Roy)
Hi!
Got work...
Regards!

@r1c1
Hi!
Would you please enable .rar files as uploadable file types too? The upload dialog only has .zip ones. Thanks.
Regards!

 

[James989]

1) Both wookbooks run simulteneously OR wookbook1 first and then follow by wookbook2 ?

2) why wookbook1 always runs twice ?