Calculate function fails after converting to Late Binding [RESOLVED]

[Spinaker]

I have written a program that does an extensive amount of Excel manipulation. To enable it to run on a range of target PCs I have converted to late binding (following Si_the_Geek's excellent tutorial on how to do this). This includes adding the XL97 constants module.
However the program now fails when it reaches the Calculate function - Compile Error, Sub or Function not defined.
Any ideas please.
Geoff

[Static]

Post the code you are using

(btw: nice to see that someone else spells thier name the CORRECT way ;))


-Geoff

[Spinaker]

Many thanks for your offer of help.
I have just twigged what I have done wrong.
Having converted to Late Binding I failed to identify the Excel object (in my case xlApp) for the Calculate function.
So the cure is - xlApp.Calculate
My silly mistake but shows one has to be careful.

[Static]

glad it was an easy fix ;)

-Geoff