What would be the vba for a button to open a file in the same folder? I can't use a complete file path because its on a portable drive that is E:\ at work and G? at home.
The file name is UpdatedList.xlsm
What would be the vba for a button to open a file in the same folder? I can't use a complete file path because its on a portable drive that is E:\ at work and G? at home.
The file name is UpdatedList.xlsm
Last edited by scantron; 02-22-2012 at 04:06 PM.
Something like this should work:
![]()
Please Login or Register to view this content.
Hope that helps,
~tigeravatar
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
.....my mistake!
Last edited by john55; 02-22-2012 at 04:04 PM. Reason: did not refresh the page!
Regards, John55
If you have issues with Code I've provided, I appreciate your feedback.
In the event Code provided resolves your issue, please mark your Thread as SOLVED.
If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.
...enjoy -funny parrots-
Thanks tiger, I've given you a star vote.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks