Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-24-2009, 11:08 AM
pankajkankaria pankajkankaria is offline
Novice
Macro library
 
Join Date: Mar 2009
Posts: 2
pankajkankaria is on a distinguished road
Smile Macro library

Hi,



I have over a period of time developed a many macros each of which I use accross multiple excel spreadsheets. It is very painful to keep a track of each macro and reuse them.

Is there a way I can centralise mu macros and import all of them together? in other words, can I centralise the macros?

Regards
Pankaj
Reply With Quote
  #2  
Old 04-12-2009, 09:06 AM
Bird_FAT's Avatar
Bird_FAT Bird_FAT is offline Macro library Macro library Office 2007
Expert
 
Join Date: Apr 2009
Location: South East
Posts: 271
Bird_FAT is on a distinguished road
Default

Quote:
Originally Posted by pankajkankaria View Post
Hi,

I have over a period of time developed a many macros each of which I use accross multiple excel spreadsheets. It is very painful to keep a track of each macro and reuse them.

Is there a way I can centralise mu macros and import all of them together? in other words, can I centralise the macros?

Regards
Pankaj

Easy - create a template spreadsheet and add modules to it in your VBA window (you could do it all in one, but then sifting through it to find the ONE you need, could be a real pain - So, I suggest you catagorise the macros and name the modules after your catagories!).
Then you can use this as your default template, or save it to a different area and only use it when you need to access the macros.

Also - you can export and import modules, so once made, you could export to a file, then import to a spreadsheet as and when required.


Bird

Last edited by Bird_FAT; 04-29-2009 at 11:41 AM.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
macro on checkbox macrohelp Word VBA 0 03-06-2009 03:33 PM
Unable to run the specified macro jtrirogoff Word 0 02-05-2009 04:38 PM
Macro Issue Basanth Excel 1 12-05-2008 08:07 PM
Access Object library 10 Gyto Office 0 10-09-2008 09:04 AM
Macro Writing cweachter Excel 0 08-09-2008 08:30 PM

Other Forums: Access Forums - Senior Forums

All times are GMT -7. The time now is 02:10 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2020, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2020 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft