Can anyone help with this please?
I’m trying to set up an auto execute macro in a number of spreadsheets
that will automatically record the ID of any user who opens and saves
the file. I have set this up Ok but can only it it to work for files
where I name the file name in the code ie
Application.Run _
"'File name 1.xls'!User_Logger"
As I’m using it in several differently named files and emailing it to
users, I like to use the same piece of code in each file without
reference to another file that may not be available but I’m not sure
how to do this ie if I change the code to
Application.Run _
"!User_Logger"
It won’t run.
Any ideas?
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
