Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Import VBA Code in Excel-File ? (Export VBA Code to file)
I have a large base of VBA Code. It imports and rewrites some data.
Currently I have the code inside every sheet together with the data. It would be much better if there was only one file for the code, which could be used in all the files where I need them - as a libary. How can I do that ? Matthias -- www.matthiaspospiech.de |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Import VBA Code in Excel-File ? (Export VBA Code to file)
The best way would be to put all the code in a single workbook,
and then save that workbook as an Add In. (Just go to the File menu, choose Save As, and change "Save As Type" to "Excel Add-In", at the bottom of the list). -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Matthias Pospiech" wrote in message ... I have a large base of VBA Code. It imports and rewrites some data. Currently I have the code inside every sheet together with the data. It would be much better if there was only one file for the code, which could be used in all the files where I need them - as a libary. How can I do that ? Matthias -- www.matthiaspospiech.de |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Import VBA Code in Excel-File ? (Export VBA Code to file)
Lookup Creating Add-Ins in Google.
-- HTH RP (remove nothere from the email address if mailing direct) "Matthias Pospiech" wrote in message ... I have a large base of VBA Code. It imports and rewrites some data. Currently I have the code inside every sheet together with the data. It would be much better if there was only one file for the code, which could be used in all the files where I need them - as a libary. How can I do that ? Matthias -- www.matthiaspospiech.de |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
macro to import file (help with a piece of code) | Excel Programming | |||
VB Code or Excel macro to run Query/Import on Access file | Excel Programming | |||
File-Open import code available anywhere? | Excel Programming | |||
Request Vba code Export gif file | Excel Programming | |||
Use VBA code to open a text file with the import wizard | Excel Programming |