View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
CellShocked CellShocked is offline
external usenet poster
 
Posts: 277
Default Keeping from declaring a direct path

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.