a VBA module for multi application

  • Thread starter Thread starter Souris
  • Start date Start date
S

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,
 
Souris said:
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
Click to expand...


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.
 
Souris said:
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
Click to expand...

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/
 
Back
Top