Keeping from declaring a direct path

  • Thread starter Thread starter CellShocked
  • Start date Start date
C

CellShocked

Hello.

I would like to know how I make a call to a file in a macro for opening
it without using explicit path calls.

In other words, I want to copy the entire directory to a USB drive and
use the workbook, and its macros from there.

My macros current make explicit call to paths that would not be present
for the USB drive version of my database.

What do I do to properly call a file? The old DOS method of
"./pathname/filename.xlsm"?

I already learned the other day that recording a macro doesn't always
work later if everything is not in the exact same state. I overwrote my
entire "main view sheet" because I left out workbook and sheet switching
and opening and selecting events.

I am learning,though.
 
So I grab that value and pass it to my code segments whenever I need
to call a file not already open? Thanks, btw.
 
Yes, passing it that way would work.


So I grab that value and pass it to my code segments whenever I need
to call a file not already open? Thanks, btw.
Click to expand...
 
Back
Top