a VBA module for multi application

[Souris]

I have some VBA code for Access and Excel multi applications.

Can I have a module that to accessed by all my applications that I do not
rewrite and copy and paste to every single application

your information is great appreciated,

 

[Marshall Barton]

I have some VBA code for Access and Excel multi applications.

Can I have a module that to accessed by all my applications that I do not
rewrite and copy and paste to every single application

You can put that code in standard modules in a separate VBA
project (in an Access or(?) Excel file).

Then your other projects can use that file as a library by
selecting it in the VBA - Tools - References.

 

[Tony Toews [MVP]]

I have some VBA code for Access and Excel multi applications.

Can I have a module that to accessed by all my applications that I do not
rewrite and copy and paste to every single application

Hmm, not sure how Excel works on such although I'm sure it's got to be
possible.

See my Add-in Tips, Hints and Gotchas page at
http://www.granite.ab.ca/access/addins.htm

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/