View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Frank Kabel Frank Kabel is offline
external usenet poster
 
Posts: 3,885
Default Dialog For Choosing A File as a string

Hi
have a look at the
GetSaveAsFile
method

--
Regards
Frank Kabel
Frankfurt, Germany


Gjones wrote:
Hi;

I am automating information from Excel to PowerPoint. I
did my development work in XP and used the
msoFileDialogFilePicker method only to find that the call
does not work with Office 2000 or 97.

I need a snippet to use a dialog box in Excel to get the
string path for the file, then pass it to the PowerPoint
automation object as a string to open the presenttion of
the users choice.

Thanks,

Greg