Error Checking Option

  • Thread starter Thread starter mangesh_yadav
  • Start date Start date
M

mangesh_yadav

The new versions of Excel support error checking options while the ol
ones do not. Through VBA code I automatically set these options, bu
when I use this file in an older version, I get an error: 438: Objec
doesn't support this property or method. And my code fails at thi
point in the older versions of excel. How do I check whether th
property exists and then only accordingly set it?

Manges
 
The best you could do is check the version and then only branch to access
code compatible with that version. If the difference is specific to VBA5
vice VBA6, you can do conditional compilation, but it doesn't sound like
this is the situation. Another approach is not to use the new arguments at
all. Code for the lowest version where the code must run.
 
Well, this is what I did: I just use Resume Err_Handler so that when a
error comes the entire step is by-passed.

Manges
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA to VB6 6
get Control of a Butoon placed in the Sheet 2
Run time error specifying range for sort code vba excel 2010 1
Excel Macro error 5
Workday Function in VBA 3
Insert Word field code using VBA from Excel 1
Went from Office 2003 to 2007. Error 438 VB v.6.5. 6
Combo box problem 2

Back
Top