Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Code Fails on SAVE
Hello
The following code gives me Incorrect Function on the save line. What does this mean and how do I fix it? Dim strMonth As String Dim strYear As String Range("B36:X36").Select Selection.Copy Range("B3").Select Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _ :=False, Transpose:=False Range("A4:X35").Select Application.CutCopyMode = False Selection.ClearContents strMonth = InputBox("Enter Reporting Month 01-12") strYear = InputBox("Enter Reporting Year") ActiveWorkbook.SaveAs Filename:="G:\" & strYear & "\" & strYear & "-" & strMonth & "\Turbine log " & strYear & "-" & strMonth & ".xlsm", FileFormat:=xlOpenXMLWorkbookMacroEnabled, CreateBackup:=False Thanks! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel fails on Save/Save As | Excel Discussion (Misc queries) | |||
XLBook.Save fails in Excel 2007 | Excel Programming | |||
Excel fails to save | Excel Discussion (Misc queries) | |||
Excel fails to save properly | Excel Discussion (Misc queries) | |||
Save As - Multiple Sheets fails to save as text file | Excel Programming |