Excel file referencing a large central macro file?

**alanzero** · 01-25-2011, 02:24 PM

Hi there,

I am working on 2 major excel dashboards that has many macros. I am thinking of consolidating all of the tools and macros into one VBA file, so that there will be one file of "common macros" which I can place onto sharepoint and have all of the spreadsheets I develop in the future point to that one file and use its functions.

Are there any solutions that can solve it directly, or get close to it?

Thanks!
Alan

**MarvinP** · 01-25-2011, 03:00 PM

Hi alanzero and welcome to the forum.

Searching the net gave me http://www.vbaexpress.com/kb/getarticle.php?kb_id=279

I think the starts addressing your question.

The search was "excel vba run macro from another workbook"

**alanzero** · 01-25-2011, 03:23 PM

Thanks for the prompt reply!

I am trying to avoid referencing from another workbook. I prefer referencing actually from another module.

**MarvinP** · 01-25-2011, 05:10 PM

Ok,

This is normal Macro Sub. See http://www.anthony-vba.kefra.com/vba/vbabasic1.htm

**alanzero** · 01-25-2011, 07:09 PM

I want to put the macro on a html page online, and then simliar to java where in the beginning you can "import xxx.file"

In a blank excel workbook, in the macro, I can just type something like "import xxx.macro" and the workbook would have all the functions in the html page.

is that possible?

Thanks

**MarvinP** · 01-25-2011, 08:29 PM

Hi,

I think you need a .BAS file to import. See http://www.pcreview.co.uk/forums/inc...a-t994210.html and a code snippet on it.
Or better is your question on MSDN at http://support.microsoft.com/kb/219905

hope this helps