I have a "library" XLS file containing a number of macros which are
used in other XLS files, for example
Private Sub CommandButton1_Click()
Application.Run "'LibFile.xls'!Enter_Journal"
End Sub
This file needs to be open when the macro is invoked. Is there any
way in which the macros can be run without having that file open?
If so, how do I specify the path relative to the current directory -
i.e. up one level in the directory tree / down one level in the
directory tree?
--~--~---------~--~----~------------~-------~--~----~
-------------------------------------------------------------------------------------
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
-------------------------------------------------------------------------------------
-~----------~----~----~----~------~----~------~--~---
