TheSwamp
Code Red => VB(A) => Topic started by: andrew_nao on February 19, 2013, 03:11:36 PM
-
im trying to use this file but i get errors when opening it up
and i dont know a thing about coding VB
this used to work when i had excel 2003 now im using 2007
if anyone can take a look and fix my problem i would greatly appreciate it
-
It opens fine in Excel 2010
What kind of error are you receiving?
-
i get this and if i click ok, i get vba debugger popping up
-
Since you post here, I assume your AutoCAD runs some VBA code that automates Excel to read some data from the sheet, or write some data to the sheet.
So, it is very likely that the error you showed is due to the VBA code in AutoCAD, not something wrong with the *.xls file.
Therefore, you need to examine the AutoCAD VBA project (*.dvb, which is loaded into AutoCAD at some point when AutoCAD runs), if you know a bit AutoCAD VB, or you have to send the *.dvb file for some to look into, should the VBA code is not password-protected.
-
It seems the only thing it does is search the document and puts the results into a dialog box. Essentially what the FIND ALL function in Excel does. Sooooo.... why not just use that??