Calculate function fails after converting to Late Binding [RESOLVED]
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
Re: Calculate function fails after converting to Late Binding
Post the code you are using
(btw: nice to see that someone else spells thier name the CORRECT way ;))
-Geoff
Re: Calculate function fails after converting to Late Binding
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.
Re: Calculate function fails after converting to Late Binding
glad it was an easy fix ;)
-Geoff
