Dialog For Choosing A File as a string
 

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

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

Dialog For Choosing A File as a string
 

THANK YOU!
-----Original Message-----
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
.