Hi,
I pieced together the following macro to save documents I am working on to one folder and just use the company name listed in cell A4. Every 5th or 6th time I hit the macro the file does not save as an excel file but rather as an unrecognized file type - any idea what I could do to fix this?
Sub MacroSaveAs()
'
' MacroSaveAs Macro
'
' Keyboard Shortcut: Ctrl+Shift+Q
'
Application.CutCopyMode = False
ActiveWorkbook.SaveAs Filename:= _
"G:\CLASH\Data\2015 Portfolio Aggs\" & Range("A4").Text _
, FileFormat:=xlOpenXMLWorkbookMacroEnabled, CreateBackup:=False
Thanks!
Daniel
I pieced together the following macro to save documents I am working on to one folder and just use the company name listed in cell A4. Every 5th or 6th time I hit the macro the file does not save as an excel file but rather as an unrecognized file type - any idea what I could do to fix this?
Sub MacroSaveAs()
'
' MacroSaveAs Macro
'
' Keyboard Shortcut: Ctrl+Shift+Q
'
Application.CutCopyMode = False
ActiveWorkbook.SaveAs Filename:= _
"G:\CLASH\Data\2015 Portfolio Aggs\" & Range("A4").Text _
, FileFormat:=xlOpenXMLWorkbookMacroEnabled, CreateBackup:=False
Thanks!
Daniel