PJF Posted February 12, 2009 Share Posted February 12, 2009 I'll spare the long story behind my reasons for wanting to do this without dialogue boxes. Q: Is it possible edit a tables Data Link value (to an external XLS file) via VBA? If so, how..? If not, is it possible with LISP or a sequence of command line entries? I've tried searching the VBA Reference, trial and error, the autodesk discussion forum, ACAD help file and googling with no luck. Quote Link to comment Share on other sites More sharing options...
JohnM Posted February 12, 2009 Share Posted February 12, 2009 what version of autocad are you using? Quote Link to comment Share on other sites More sharing options...
PJF Posted February 12, 2009 Author Share Posted February 12, 2009 what version of autocad are you using? I use 2008 Electrical to do all of my VBA programming but I have 2009 installed as well. Quote Link to comment Share on other sites More sharing options...
JohnM Posted February 12, 2009 Share Posted February 12, 2009 please explain in more detail or word diffrently. what is ment by "edit a tables Data Link value (to an external XLS file)" edit? Quote Link to comment Share on other sites More sharing options...
PJF Posted February 12, 2009 Author Share Posted February 12, 2009 please explain in more detail or word diffrently.what is ment by "edit a tables Data Link value (to an external XLS file)" edit? See attached screen shot. The excelfile.xls is linked to a table that I made in ACAD. You can update the contents of the ACAD table via command prompt no problem but I can't seem to figure out how to edit the "c:\excelfile.xls" (string) link without using a GUI. Quote Link to comment Share on other sites More sharing options...
PJF Posted February 17, 2009 Author Share Posted February 17, 2009 Can anyone describe how I can dig through the table entity to find what I'm looking for? Thanks. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.