Keeping from declaring a direct path

[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.

 

[Rob van Gelder]

Try using the string returned from

ThisWorkbook.Path

Cheers,
Rob

 

[CellShocked]

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

 

[Rob van Gelder]

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.