View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Daniel R. Young Daniel R. Young is offline
external usenet poster
 
Posts: 38
Default 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