Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro with Drive-change?
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro with Drive-change?
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro with Drive-change?
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro with Drive-change?
It does exactly what Excel's File, Open dialog does - it gives the user an
opportunity to select the file through a convenient dialog. Play with this to see if it helps. Check it out in VB Help, there are examples there you can run. -- Jim "Daniel R. Young" wrote in message ... | 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 | | | |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Links to mapped drive change to refer to local hard drive | Links and Linking in Excel | |||
Reference drive letter that can change | Excel Programming | |||
Macro won't run from d: drive, but works on c: drive | Excel Programming | |||
how can i change the Drive | Excel Programming | |||
Find links with code; change from G drive to C drive | Excel Programming |