Printable View
I have this coding:
strSaveToPath = Application.GetSaveAsFilename("C:\A.txt", fileFilter:="Text Files (*.txt), *.txt")
This brings up a dialog box with C:\A.txt as default file in the File Name box.
Later I use this code to run a slideshow:
Shell "D:/Program Files\Irfanview\i_view32.exe /slideshow=C:\a.txt", vbNormalFocus
All is well if user accepted C:\a.txt default. But how can i tell what file user selected if other than default so I can change it in the shell code?
what is application.GetSaveAsFilename??
i can't use that on my comp
Application.GetSaveAsFileName is a method of the Excel automation server.
The method returns the file name the user has chosen, which you are storing in your strSaveToPath variable. Would you not use that variable in your call to the shell method
Shell "D:/Program Files\Irfanview\i_view32.exe /slideshow=" & strSaveToPath, vbNormalFocus
It brings up a dialog box from which you can chose (browse) a file name to "Save As".
brucevde
Yes, your suggestion worked like a charm. I have been on this project since June. This was the final piece of the puzzle. Thanks to all who responded,