Combine two macros with a delay

[Fred_81]

Hi All!

On the verge of optimize my workflow and save a lot of time

I'm trying to combine two macros and with the second one with some delay.

My skill level is "noob" so I humbly ask for some aid from some with some better expertice

The first code will open up all excelfiles in a specific folder.

The second code will compile all the workbooks in to the same sheet and then close tem.

Now, to open the excelfiles and depending on the amount that can vary, it can take some time
so the second macro should run first after all the excelfiles are opened.

The first code:

Please Login or Register  to view this content.

Second code:

Please Login or Register  to view this content.

Would be very thankful for any input.


BR
Fred

[dangelor]

Could not edit post...

[dangelor]

Ignore the above post... (couldn't edit it correctly)

Possibly...

Please Login or Register  to view this content.

[Fred_81]

Hi Dangelor!

Thank you for the response!
However, there now seems to be something missing, now it will not open any files or save them, it only creates the new sheet (sammanställning)
I can't really see what can be causing this.

Again, thanks for the help.

Best regards from a cold and snowy Sweden

[Greg M]

Hi there,

I haven't tried to test your "CombineMultipleSheetsToExisting" routine, but the following version of your "vba_open_multiple_workbooks_folder" routine will wait until all workbooks are open before attempting to call the "CombineMultipleSheetsToExisting" routine:

Please Login or Register  to view this content.

Hope this helps - please let me know how you get on.

Regards,

Greg M

[dangelor]

Typo error. Change this line

Please Login or Register  to view this content.

to this

Please Login or Register  to view this content.