Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Export/Inport Macros
Hi,
I have two workbooks. One contains nearly all the macros being used by both workbooks. I need to share these workbooks with other users and wish to make each workbook's macros work whether or not the other workbook is open or not. Do I need to export the macros from one workbook to the other? Assuming the answer is YES, can I right click on the origin workbook "Modules" heading and "Export" to the default filenames, then in the destination workbook in Modules, right click and use "Inport"? Is there a trap I need to know about? Still learning as I go! Many thanks in advance, Brian |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Export/Inport Macros
1. Set up a separate folder in Windows explorer to keep your modules.
Right-click on a module and select Export File. To import a module, right-click the project name and select Import File. -or- 2. The quickest way to copy a module is to simply click and drag it to the other project. A copy is automatically created. -or- 3. You can also Insert a new module in your project and then copy the code from another module and paste it in the new module. -- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware (Excel Add-ins / Excel Programming) "Tail Wind" wrote in message Hi, I have two workbooks. One contains nearly all the macros being used by both workbooks. I need to share these workbooks with other users and wish to make each workbook's macros work whether or not the other workbook is open or not. Do I need to export the macros from one workbook to the other? Assuming the answer is YES, can I right click on the origin workbook "Modules" heading and "Export" to the default filenames, then in the destination workbook in Modules, right click and use "Inport"? Is there a trap I need to know about? Still learning as I go! Many thanks in advance, Brian |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Export/Inport Macros
hi
yes. a workbook has to be open to run it's macro. that is why some people put macros in their personal workbook in the xl start folder so that the macros will be available for all files. so in your case, i think you would have to export. and you're on the right track about import and export. in the vb editor, expand the project and right click the macro, click export. it will export as a bas file. I use to have a special folder for all of the macros i had exported. to import, in the vb editor, right click the project you want the macro in. click import. you may need to decide if it's a sheet macro, workbook macro or just in a standard module. good luck Regards FSt1 "Tail Wind" wrote: Hi, I have two workbooks. One contains nearly all the macros being used by both workbooks. I need to share these workbooks with other users and wish to make each workbook's macros work whether or not the other workbook is open or not. Do I need to export the macros from one workbook to the other? Assuming the answer is YES, can I right click on the origin workbook "Modules" heading and "Export" to the default filenames, then in the destination workbook in Modules, right click and use "Inport"? Is there a trap I need to know about? Still learning as I go! Many thanks in advance, Brian |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Inport External Data - new queries | Excel Worksheet Functions | |||
Inport Outlook emails into Excel | Excel Discussion (Misc queries) | |||
How to inport works spreadsheet into excel 2007 | Excel Worksheet Functions | |||
Inport from a variable file name | Excel Discussion (Misc queries) | |||
Inport of Microsoft Works Spreadsheets | Excel Discussion (Misc queries) |