Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I am using the code below to display a Save as Dialog Box with the preferred
directory location. The dialog box and correct directory location appear however the file does not save to that filename / location once the user presses the Save button. Any suggestions as to my error would be appreciated 'Retrieve file name to use for Save Dim WB As Workbook Dim SH As Worksheet Dim Rng2 As Range Dim Rng3 As Range Dim aStr As String Dim sPath As String Dim FName As String Set WB = ThisWorkbook Set SH = WB.Sheets("Cash Summ") Set Rng2 = SH.Range("A1") Set Rng3 = SH.Range("A2") If Not IsEmpty(Rng2.Value) Then aStr = Rng2.Value aStr2 = Rng3.Value FName = aStr & aStr2 fileSaveName = Application.GetSaveAsFilename(FName) End If End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Macro - save to current location vs excel default location | Excel Discussion (Misc queries) | |||
Save Excel Worksheet As CSV - No Save As Dialog | Excel Programming | |||
how to get disk icon on save button of save as dialog like 2000 | Excel Discussion (Misc queries) | |||
Save File to Another Directory, but not change Users File Save location | Excel Programming | |||
Changing Save As Type in Save as dialog box | Excel Programming |