firefytr vbmenu_register("postmenu_38365", true); , the code is the code i just wrote above, but here it again:
Sub SaveToFolder()
Fpath = ("D:\2005\temp\tax.xls")
Excel.Application.Dialogs(xlDialogSaveAs).Show (Fpath)
end sub
i debuged it and there is no problem apear to be and i get no error also.
TheAntiGates, the line you wrote:
foo = Application.GetSaveAsFilename(, , , Title:="Set destination dir")
and after that: saveas....
it's seems ok, but if i type name of existin file i get a "run time" error.
i just trying to understand why the command i used won't work, it only write the file name (tax.xls) but not the path (D:\2005\temp), the path is the path that i opend the file from.
also the link to microsoft says:
To create a macro (SaveDialogFile) that will start the Save As dialog box and select a specific file name and path, use the following Visual Basic sample code:
Sub SaveDialogFile()
Application.Dialogs(xlDialogSaveAs).Show ("<drive>:\<path>\<filename>")
End Sub