Dec 31, 2003 #1 D Devin Usenet Archive Joined Sep 27, 2001 Messages 342 Reaction score 0 Is there a way to open an excel doc from inside autocad using programming code? TIA, Devin
Dec 31, 2003 #2 J Jeff Mishler Usenet Archive Joined Jul 3, 2003 Messages 987 Reaction score 0 Yes. And read from it. And write to it. And create a new worksheet. And save it. And close it. There, that about cover it? ;-) Happy New Year, Jeff
Yes. And read from it. And write to it. And create a new worksheet. And save it. And close it. There, that about cover it? ;-) Happy New Year, Jeff
Dec 31, 2003 #3 B BillZ Usenet Archive Joined Jul 9, 2003 Messages 1,001 Reaction score 0 (startapp "C:/Program Files/Microsoft Office/Office10/excel.exe" "g:/2002/lists/obcolcod.xls")
Dec 31, 2003 #4 D Dave Usenet Archive Joined Jan 24, 2000 Messages 187 Reaction score 0 Right on on Bill! Dave
Dec 31, 2003 #5 J Jeff Mishler Usenet Archive Joined Jul 3, 2003 Messages 987 Reaction score 0 And more specifically, if you want to do more than ust open it, see the post made on 4/29/03 by Marc'Antonio Alessi. He posted some excellent Excel linking routines for use in vlisp. HTH, Jeff
And more specifically, if you want to do more than ust open it, see the post made on 4/29/03 by Marc'Antonio Alessi. He posted some excellent Excel linking routines for use in vlisp. HTH, Jeff
Dec 31, 2003 #6 D Dave Usenet Archive Joined Jan 24, 2000 Messages 187 Reaction score 0 Here is the file Jeff mentions: http://SmartLister.com/Files/MsxUtl01.zip There is more information on the threads down there on 4/29 and others Dave
Here is the file Jeff mentions: http://SmartLister.com/Files/MsxUtl01.zip There is more information on the threads down there on 4/29 and others Dave
Dec 31, 2003 #7 M Mark (archive) Usenet Archive Joined Feb 2, 2001 Messages 234 Reaction score 0 you might have to check to see where excel.exe is, using something like ... (if (member "EXCEL.EXE" (mapcar 'strcase (vl-registry-descendents "HKEY_CLASSES_ROOT\\Applications\\"))) and then ... (setq apl "HKEY_CLASSES_ROOT\\Applications\\Excel.exe\\Shell\\" exe (vl-registry-read (strcat apl "Edit\\Command\\" ""))) or ... exe (vl-registry-read (strcat apl "Open\\Command\\" "")))
you might have to check to see where excel.exe is, using something like ... (if (member "EXCEL.EXE" (mapcar 'strcase (vl-registry-descendents "HKEY_CLASSES_ROOT\\Applications\\"))) and then ... (setq apl "HKEY_CLASSES_ROOT\\Applications\\Excel.exe\\Shell\\" exe (vl-registry-read (strcat apl "Edit\\Command\\" ""))) or ... exe (vl-registry-read (strcat apl "Open\\Command\\" "")))
Dec 31, 2003 #8 D Devin Usenet Archive Joined Sep 27, 2001 Messages 342 Reaction score 0 That's it, thanks you guys!
