Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Saving a File
I'm trying to set the folder where I want the user to be in before invoking
the open/save dialog. The "ChDir" command isn't changing the current folder. Can someone tell me the right code to change the current folder? ChDir "S:\Spreadsheets" Application.Dialogs(xlDialogSaveAs).Show |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Saving a File
Dim startingname As String
startingname ="FILE NAME" Dim myFileName As Variant myFileName = Application.GetSaveAsFilename _ (InitialFileName:="c:\" & startingname) If myFileName = False Then 'user hit cancel Else ActiveWorkbook.SaveAs Filename:=myFileName, FileFormat:=xlNormal End If |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Saving Excel 2007 file in 2003 creates very large file | Excel Discussion (Misc queries) | |||
Text file saving, setting file origin | Excel Discussion (Misc queries) | |||
Excel should let me sort the file directory when saving a file | Excel Discussion (Misc queries) | |||
How do I stop Excel 2000 from saving file history from file that . | Excel Discussion (Misc queries) | |||
saving an excel file as an ASCII text file without delimiters | Excel Programming |