Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Aug 2002
    Location
    milton keynes, Buckinghamshire
    Posts
    252
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Copying sheets to a new workbook 2007

    We have just upgraded to 2007.

    I use macros to create project files. I have a master projects file in which I hold standard project reporting worksheets. By selecting a project from the available list and running the macro, the project sheets are populated with the relevant data and then exported to a new workbook, and saved under the new project file name.

    Under 2003 the above process ran quite quickly. I have updated the process so that all the files are now of type .xlsm rather than just .xls. However the process of copying the sheets to the new workbook now takes up to 45 seconds per sheet. Given that I have 100 project reports to run each month, each of which has 7 sheets in it, this is now becoming quite time consuming.

    I realise that the problem relates to the fact that links exist between some of the sheets in each project report. However these links did not slow excel 2003 that much.

    Can anybody please advise if there is some way of speeding up the copying sheets process.

    Thanks

    Alex

  2. #2
    3 Star Lounger
    Join Date
    Nov 2002
    Location
    New York, New York, USA
    Posts
    266
    Thanks
    0
    Thanked 19 Times in 19 Posts
    Alex:

    Pehaps there is something in this post Slow
    Hope this helps.

    Tom D

Posting Permissions

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