Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I am trying to modify a macro to enable my user to save a file locally on
their hard drive with a name and location that they specify. I keep getting an "End if without Block If" compile error. Being very new to VBA code, I can't seem to get the macro to work. It is as follows: Private Sub SaveMe_Click() If NewName < False Then If Dir(NewName) < "" Then Select Case MsgBox("File Exists. Overwrite ?", vbYesNoCancel + vbQuestion) Case vbYes Application.DisplayAlerts = False ActiveWorkbook.SaveAs Filename:=NewName, FileFormat:=xlWorkbookNormal Application.DisplayAlerts = True Case vbNo Do NewName = Application.GetSaveAsFilename( _ InitialFileName:=ActiveWorkbook.Path & "\" & NameAk, FileFilter:="Excel Workbooks (*.xls), *.xls") If NewName = False Then Exit Sub Loop Until Dir(NewName) = "" ActiveWorkbook.SaveAs Filename:=NewName, FileFormat:=xlWorkbookNormal Case Else Exit Sub End Select Else ActiveWorkbook.SaveAs Filename:=NewName, FileFormat:=xlWorkbookNormal End If End If End Sub I know it is probably very simple, but I just can't seem to find the problem .. . . WillRn |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Selecting "Save As" adds "Copy of" to file name- MS Excel 2007 | Excel Discussion (Misc queries) | |||
"Save" and "Save As" options greyed out - "Save as Webpage" option | Excel Discussion (Misc queries) | |||
"Save as" macro problems | Excel Discussion (Misc queries) | |||
Problem- Recording macros for "file save" and "File open" | Excel Programming | |||
how to change default file name in "save as" or "save" | Excel Programming |