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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
application.dialogs(xlDialogSaveAs) AND CHDIR
I can't explain it.
-- Regards, Tom Ogilvy "Jules" wrote in message ... When I put a message box after chdir and receive F:\my documents instead of a directory. ???? The only changes are Office SP3 and Netware cluster.. -----Original Message----- ChDrive "N" ChDir "N:\GROUP\RESID BILLING TEAM\Res Billing Reps\" Application.Dialogs(xlDialogSaveAs).Show ' or fname = Application.GetOpenFileName() works for everyone else. Why do you think it isn't working for you. Is the directory spelled correctly. What do you mean it doesn't work? the saveas dialog opens in the current directory. the commands above should make the the current directory. Before you show the dialog, put up a message box msgbox curdir See where you are. If it doesn't work, then perhaps there is some network permissions problem that prevents it. -- Regards, Tom Ogilvy Jules wrote in message ... 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. . |
Reply |
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 |