Consulting

Results 1 to 2 of 2

Thread: Solved: Share a workbook without a prompt

  1. #1
    VBAX Contributor
    Joined
    Jun 2008
    Location
    West Midlands
    Posts
    170
    Location

    Solved: Share a workbook without a prompt

    Guys,

    I need your help once again, I have written some code to share a workbook, but my code asks for a prompt each time.
    How can I modify the code so that it will simply overwrite the saved workbook with the shared workbook without prompting the user.

    [VBA]With ActiveWorkbook
    .KeepChangeHistory = True
    .ChangeHistoryDuration = 30
    End With
    ActiveWorkbook.SaveAs Filename:= _
    "I:\H925 Buying\BuyingTeamsALL\New Essentials Availability Report\2008-2009\07) July 2008\Essentials Availability Report 3007.xls" _
    , AccessMode:=xlShared[/VBA]

    Thanks in advance for your swift response.

  2. #2
    Knowledge Base Approver VBAX Master Oorang's Avatar
    Joined
    Jan 2007
    Posts
    1,135
    Location
    [VBA]Application.DisplayAlerts = False
    'Your code here.
    Application.DisplayAlerts = True[/VBA]
    Cordially,
    Aaron



    Keep Our Board Clean!
    • Please Mark your thread "Solved" if you get an acceptable response (under thread tools).
    • Enclose your code in VBA tags then it will be formatted as per the VBIDE to improve readability.

Posting Permissions

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