Author Topic: can anyone help me with this?  (Read 1754 times)

0 Members and 1 Guest are viewing this topic.

andrew_nao

  • Swamp Rat
  • Posts: 566
can anyone help me with this?
« 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


Keith™

  • Villiage Idiot
  • Seagull
  • Posts: 16750
  • Superior Stupidity at its best
Re: can anyone help me with this?
« Reply #1 on: February 19, 2013, 03:26:20 PM »
It opens fine in Excel 2010

What kind of error are you receiving?
Proud provider of opinion and arrogance since November 22, 2003 at 09:35:31 am
CadJockey Militia Field Marshal

andrew_nao

  • Swamp Rat
  • Posts: 566
Re: can anyone help me with this?
« Reply #2 on: February 19, 2013, 03:49:41 PM »
i get this and if i click ok, i get vba debugger popping up

n.yuan

  • Bull Frog
  • Posts: 285
Re: can anyone help me with this?
« Reply #3 on: February 19, 2013, 04:18:13 PM »
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.

Matt__W

  • Seagull
  • Posts: 12955
  • I like my water diluted.
Re: can anyone help me with this?
« Reply #4 on: February 20, 2013, 02:58:19 PM »
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??
Autodesk Expert Elite
Revit Subject Matter Expert (SME)
Owner/FAA sUAS Pilot @ http://skyviz.io