Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
application.dialogs(xlDialogSaveAs) AND CHDIR
I need to create code to bring up a dialog box to SAVE AS
in a specific directory but allow the user to type in their own filename. Here is what I have and it doesn't work. ChDrive "N" ChDir "N:\GROUP\RESID BILLING TEAM\Res Billing Reps\" Application.Dialogs(xlDialogSaveAs).Show I've also tried this and doesn't work. ChDrive "N" Application.Dialogs (xlDialogSaveAs).Show "N:\GROUP\RESID BILLING TEAM\Res Billing Reps\") HELP..Thanks in advance. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Application.Dialogs(xlDialogPrint).Show - prints too soon | Excel Discussion (Misc queries) | |||
Dialogs | Excel Discussion (Misc queries) | |||
compile error in hidden module: Dialogs | Excel Programming | |||
Using Dialogs Save | Excel Programming | |||
Windows Common Dialogs in VBA? | Excel Programming |