LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default Copying macros to another workbook

I have a monster file with a bunch of macros that I want to move to another
workbook so that the original file won't take so long to save. The workbook I
am moving the macros to will always be open in order to access the macros. My
question is what is the best way to do this?

Here's what I'm wondering...
- Should I manually copy all the code for each macro and paste it over?
- Is there an easy way in Visual Basic to drag and drop from one workbook to
another?
- Does the amount of modules effect how quickly a file saves?
- As there any limit to the amount of macros that can be put in one module
and is there any benefit to doing that in terms of speed of execution and how
long it takes for the workbook to save?

Many many thanks!

David
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Macros & Copying to another sheet [email protected] Excel Discussion (Misc queries) 2 February 26th 08 02:56 PM
Macros - copying macros from one computer to another TT Excel Discussion (Misc queries) 18 December 14th 06 03:24 AM
copying macros Louise Excel Worksheet Functions 4 May 26th 06 04:26 PM
copying macros Louise Excel Worksheet Functions 2 May 18th 06 04:51 PM
Copying macros & tool bar Dewayne Excel Discussion (Misc queries) 2 August 17th 05 07:11 PM


All times are GMT +1. The time now is 04:40 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"