Excel vb code stopped working (variable not defined)

Question

(DISCLAIMER: I'm not a programmer, I spend my time on serverfault, I'm just a lowly admin)

We have an excel spreadsheet with vb code in it that was created in Office 2003.

We've recently gone to Office 2007, and the spreadsheet continued to work as normal.

However, after installing service pack 2 for Office 2007 the spreadsheet now fails with an error stating : "variable not defined"

If I comment out the "Option Explicit" statement at the top of the code then the code works fine.

What I don't understand is that when the error occurs it is occurring on something that isn't even a variable (unless I'm wrong?).

Click the below image to see the screenshot:

http://filedb.experts-exchange.com/incoming/2009/06_w23/t144890/snip.JPG

Lance Roberts · Accepted Answer · 2013-07-31 15:18:31Z

4

The reference to the package/addin/whatever that DataGrid exists in probably needs to be re-referenced. Check Tools -> References in the Menu.

EDIT: OK, here's what I found, it appears that if you install Microsoft Security Advisory 960715, that that control is killed. There are fixes which may or may not work for you. A good article is on this blog:

VSOD Blog

edited Jul 31, 2013 at 15:18

answered Jul 8, 2009 at 15:38

Lance Roberts

22.9k32 gold badges115 silver badges132 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

TheCleaner Over a year ago

I attempted this by unchecking the "Microsoft DataGrid Control 6.0" (MSDATGRD.OCX file) in the References. Saving the .xlsm, Then adding it back in. Still get the same error.

Kieran Senior · Accepted Answer · 2009-07-08 15:38:12Z

0

The variable is an object that exists in the excel spreadsheet itself, hence the events you see above state DataGrid1_Click which is an event handler. This is why you can't see the variable definition. Perhaps DataGrids aren't supported in post-SP2 installs?

answered Jul 8, 2009 at 15:38

Kieran Senior

18.3k27 gold badges97 silver badges140 bronze badges

Comments

Oorang · Accepted Answer · 2009-07-09 08:34:34Z

0

Verify that the object is still named "datagrid1".
Try prefixing the object with "Me" (Me.DataGrid1)
Could be an early symptom of corruption. Try cutting (ctrl-x) the entire code. Then from the debug menu click compile. Paste the code back in an compile again. Sometimes this simple measure will fix it. (If not an you still suspect corruption there are more advanced measure to be taken.)

answered Jul 9, 2009 at 8:34

Oorang

6,7901 gold badge38 silver badges54 bronze badges

Collectives™ on Stack Overflow

Excel vb code stopped working (variable not defined)

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related