SaveAs dialog & VBA

[Elias Hämäläinen]

Hi,

Is there a way how to call SaveAs dialog via VBA?

 

[John]

Hi,

Is there a way how to call SaveAs dialog via VBA?

Elias,
I thought there was but I guess not. However, unless you want the user
to specifically have to deal with a "save" window why not use the
FileSaveAs or SaveAs Methods? If necessary you can use an InputBox
function to solicit the file name from the user before calling either
SaveAs method.

Hope this helps.
John
Project MVP

 

[Elias Hämäläinen]

I managed to get it done using directly windows API. I used instructions/code
from the following link:

http://vbnet.mvps.org/index.html?code/comdlg/fileopendlg.htm