Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
xlDialogSaveAs
My clients want to be able to use the Excel Popup Dialog
box from my code, that way, if they want to change the location and document name, they can. However, I've tried every example I've seen, the below one comes right from Microsoft but when I run it, the Dialog box is sitting on my Desktop, and the File Type is a CSV. ??? 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 Help??!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Problem setting directory in xlDialogSaveAs | Excel Programming | |||
application.dialogs(xlDialogSaveAs) AND CHDIR | Excel Programming |