Import VBA Code in Excel-File ? (Export VBA Code to file)

[Matthias Pospiech]

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

 

[Chip Pearson]

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

 

[Bob Phillips]

Lookup Creating Add-Ins in Google.

--

HTH

RP
(remove nothere from the email address if mailing direct)