Hi guys
I was hoping you guys could help me out. I'm pretty new to macro and VBA but I'm trying to get a macro which can save an open spreadsheet in a specific location under a specific name.
I saved the macro in the personal folder as I would like to have it available when I open documents which don’t have this macro.
It all seems to work very well except excel now crashes randomly when opening either a new file or an existing one
I can't figure out why
After the crash I get the message that there is something wrong with my personal.xlsb!
The documents I'll be opening will be both 2003 and 2007 both with and without existing macros
Sub Linkki()
Application.DisplayAlerts = False
ChDir "H:\nrsmakro"
ActiveWorkbook.SaveAs Filename:="H:\nrsmakro\Linkki.xlsm", FileFormat:= _
xlOpenXMLWorkbookMacroEnabled, CreateBackup:=False
Application.DisplayAlerts = True
Application.Quit
End Sub
Thanks
Bookmarks