Results 1 to 2 of 2

Thread: How to Code an Excel Autosave

  1. #1
    Member
    Join Date
    2001-10
    Posts
    34
    Login to Give a bone
    0

    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!

    Pete

  2. #2
    Administrator Opie's Avatar
    Join Date
    2002-01
    Location
    jUSt Here (a lot)
    Posts
    8,907
    Login to Give a bone
    0

    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.
    jUSt

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
  •