 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Programming / March 2006Out of Present Range Error using Excel
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 Nicholas, > [quoted text clipped - 18 lines] > NZ > Always learning & the best way to learn is to experience... 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.. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.