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.

Keeping from declaring a direct path
 

Try using the string returned from

ThisWorkbook.Path

Cheers,
Rob


CellShocked wrote:
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.

Keeping from declaring a direct path
 

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



On Mon, 07 Dec 2009 19:20:12 +1300, Rob van Gelder
wrote:

Try using the string returned from

ThisWorkbook.Path

Cheers,
Rob


CellShocked wrote:
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.

Keeping from declaring a direct path
 

Yes, passing it that way would work.



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



On Mon, 07 Dec 2009 19:20:12 +1300, Rob van Gelder
wrote:

Try using the string returned from

ThisWorkbook.Path

Cheers,
Rob


CellShocked wrote:
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.