Results 1 to 2 of 2

Thread: How to Code an Excel Autosave

  1. #1
    Join Date
    Login to Give a bone

    Default How to Code an Excel Autosave

    Every time I open my Excel spreadsheet via VBA-AutoCAD, my linked Excel file stops to ask if it should "Update all linked data"...

    My question...what must be added to tell Excel to do the "Update" automatically?

    Here is my code...

    xlfilename = path & "\" & dwgname & "-" & "KeyNotes Data Main.xls"

    I'm wondering if it isn't some additional arguement that just needs to be added to the above line of code, like... ,save ...or something!!

    Any help, clues or suggestions greatly appreciated!


  2. #2
    Administrator Opie's Avatar
    Join Date
    jUSt Here (a lot)
    Login to Give a bone

    Default Re: How to Code an Excel Autosave

    I find that Excel will prompt when it contains linked data. Are your spreadsheets linked with other spreadsheets?

    Have you looked at the Calculation tab in the Options box within Excel? I'm not sure if the "Update remote references" box needs to be unchecked to remove this prompt. This may be what you are looking for.
    If you have a technical question, please find the appropriate forum and ask it there.
    You will get a quicker response from your fellow AUGI members than if you sent it to me via a PM or email.

Similar Threads

  1. .Net code to import polylines from excel
    By gisvision in forum Dot Net API
    Replies: 14
    Last Post: 2021-12-10, 05:17 PM
  2. Replies: 12
    Last Post: 2014-03-04, 02:21 PM
  3. Replies: 5
    Last Post: 2013-10-16, 05:39 PM
  4. AU 2005 VBA with Excel Sample Code
    By wpeacock in forum VBA/COM Interop
    Replies: 2
    Last Post: 2007-03-12, 10:34 AM

Posting Permissions

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