Results 1 to 2 of 2

Thread: Copying worksheets with macros inlcuded

  1. #1
    Acolyte Beddy Boy's Avatar
    Join Date
    Feb 2017
    Posts
    34
    Articles
    0
    Excel Version
    Excel 365

    Copying worksheets with macros inlcuded



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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!

  2. #2
    Conjurer Logit's Avatar
    Join Date
    Nov 2016
    Posts
    245
    Articles
    0
    Excel Version
    2007
    Perhaps post your workbooks so they can be examined.

    Do not include any private information.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •