Hi,
I would like to know if I can run the same code which is in 31 workbooks which are in the same folder at once?
Thanks in advance
Run same code at once
-
HansV
- Administrator
- Posts: 78391
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Run same code at once
You'd have to start 31 instances of Excel, and that is not a good idea. It\s better to loop through the workbooks and process them one by one.
Best wishes,
Hans
Hans
-
Bomba
- 3StarLounger
- Posts: 281
- Joined: 20 Jan 2019, 19:43
Re: Run same code at once
Its a little pain but I will do as you said.
Thanks a lot Master
Thanks a lot Master