Consulting

Results 1 to 4 of 4

Thread: Solved: Saving as xls

  1. #1
    VBAX Mentor
    Joined
    Aug 2011
    Posts
    353
    Location

    Solved: Saving as xls

    When I save my documents as .xls, a compatibility checker window pops up and I have to click continue in order for the document to save. In the below code, can I automatically have it continue so I do not have to click it manually each time?

    [VBA]ChDir "G:\Katherine Lartigue\Allocations\"
    ActiveWorkbook.Saveas Filename:= _
    "G:\Katherine Lartigue\Allocations\JPM Private Trades.xls", FileFormat:=xlExcel8, _
    Password:="", WriteResPassword:="", ReadOnlyRecommended:=False, _
    CreateBackup:=False


    ActiveWindow.Close
    [/VBA]

  2. #2
    VBAX Expert CatDaddy's Avatar
    Joined
    Jun 2011
    Posts
    581
    Location
    [VBA]
    application.displayalerts = false
    'code
    application.displayalerts = true
    [/VBA]
    ------------------------------------------------
    Happy Coding my friends

  3. #3
    VBAX Mentor
    Joined
    Aug 2011
    Posts
    353
    Location
    Works great, thank you!

  4. #4
    VBAX Expert CatDaddy's Avatar
    Joined
    Jun 2011
    Posts
    581
    Location
    no problem! mark it as solved
    ------------------------------------------------
    Happy Coding my friends

Posting Permissions

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