Strange Module line

[JonWayn]

I have a module with the following snippet of declarations:

Public ObjectAction%, XlHwnd&, LinesSpan&
Public DB As Access.Application, UForm As UpdateDb, mdl As Access.Module
'*****
Public ws As Worksheet
Public DbPath$, CurrentCounty$


The whenever I try to do anything with the line that has the asterisks at
the end, the application locks up. I cannot add a new variable to that line,
delete any existing one, nor rename any existing one. This happens with only
this line. Any ideas?

Thank you

 

[Jon Peltier]

Have you set a reference to Access?

- Jon

 

[Robin Hammond]

In short, nope. Try Rob Bovey's code cleaner. www.appspro.com I think.

Robin Hammond.