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!
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!