Out of Present Range Error using Excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm using VFP (Foxpro) to call Excel
Everything works on my own laptop, but when I transfer to clients PC I get a
problem

When my code tries to call a specific Macro in Excel I get back
OLE Error Code 0x8002000a Out of present Range

Cannot find any reference to "Out of present range" in help files or
knowledge base

Any idea's ??
 
Hi Nicholas,

These questions are purely guesswork, as I know nothing at all abou
VFP (Foxpro), but you never know...
(I was waiting for someone else to respond so I could find out abou
your problem but no-else has responded - so here goes.)

* Does the macro in Excel actually exist on your client's PC & is th
path correct?
* Are all the correct librariaries referenced in Excel (& for tha
matter, in VFP)?
To check this in Excel, [alt + F11] to access the VB Editor, Tools
References, & check that all the same references have been ticked o
your client's PC & your laptop.
* Are both computer's using the same versions of the app's?
If not, some code that works on one computer may not be valid syntax o
the other.

hth
Rob Brockett
NZ
Always learning & the best way to learn is to experience..
 
Hi Rob

Thanks for your input
I had to get onto Microsoft directly in the end and it turned out to be
something simple. I was using an integer parameter and the value I was
handing in (from a database table) was too large.

On my machine I had lower values in the database table ... simple as that

Thanks again though

Nick
 
Hi Nick,
Thanks for the feedback.

It's great when it is simple - at least now it is problem solved :-)

Rob Brockett
NZ
Always learning & the best way to learn is to experience..
 
Back
Top