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