Results 1 to 5 of 5

Personal.xlsb crashes excel

Threaded View

  1. #1
    Registered User
    Join Date
    03-23-2010
    Location
    Denmark
    MS-Off Ver
    Excel 2007
    Posts
    2

    Personal.xlsb crashes excel

    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
    Last edited by Lippert; 03-23-2010 at 10:16 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1