Jim,
I am sorry, I am new to this, but what do you mean? If this product is on a
CD and can be used by mulitple computers, the drives may be different. Does
the Application.GetOpenFilename search for the file or something?

Thank you,
Dan

"Jim Rech" wrote:

Typically I ask the user where a file is when its local is not certain. For
example with Application.GetOpenFilename.

--
Jim
"Daniel R. Young" wrote in message
...
|I have a macro where it will open a word document from the F: drive and
paste
| a selection to it.
|
| I was wondering if there is a general way to make a drive (the word doc
| should be on the CD/dvd drive) so it won't error if the drive is named
| differently then my macro code?
|
| Is there a better way I should do this, such as make someone save a folder
| to there desktop or something? Any recommendations?
|
| Thank you,
|
| Daniel Young