Excel 2010 VBA XP SP1 438 Error - object dosen't support this property or method

[knifey]

Hi,
I have a problem that I can't seem to trace and would really appreciate some advice.
I have been given an Excel 2010 VBA add-in style workbook to 'finish off' that has been fully tested and is working on everything from Windows XP service pack 3 to Windows 7. Unfortunately this needs to also work on Windows XP service pack 1.
The workbook loads ok in XP SP1, but throws an object dosen't support this property or method' error when the main code section is run.

Can anyone offer any guidance as to what maybe causing this (e.g. an incompatible VBA library reference, a VBA 2010 method that did not exist in XP SP1, etc., etc.) and what is the accepted workaround. I don't really know where to start looking for a solution?

Thanks,
Roy

 

[PHV]

Which line of code is highlited when clicking the debug button at the time the error is raised ?
Anyway, you really should to update the XP b oxes to SP3, really.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[knifey]

Hi PHV,
The debug button is not available (shaded) when the error appears. Also, there is no chance for this client to upgrade to SP3.
Any ideas?
Thanks,
Roy