Copying worksheets with macros inlcuded

Beddy Boy

New member
Joined
Feb 1, 2017
Messages
48
Reaction score
0
Points
0
Excel Version(s)
Excel 365
Hi,

I wonder if anyone can help.

I have 2 separate excel files / that contain multiple worksheets. Within one of these worksheets is a macros that downloads some data from the web. I am trying to merge these 2 workbooks but when I do the macro then takes soooo long to download the data. In the initial sheet it works well and is quick.

Does anyone have any idea why this is and how I can fix it?

I have tried copying the worksheets from one workbook to the other in different ways but the same thing results.

Basically, there's one worksheet to copy across and I can't figure out why it won't work!

Thanks in advance!
 
Perhaps post your workbooks so they can be examined.

Do not include any private information.
 
Back
Top