XLGetCell issue

mastag · Post by **mastag** » Mon Sep 05, 2011 2:11 pm

Hi there,

I'm working on a business application that collects data from Excel documents.
I'm currently using 12.1.10e trial version.

But I'm having a hard time getting the demo ready.

Code: Select all

XLOpen>C:\Users\Gino\Documents\demo\xsportal.xlsx,0,xlBook
XLGetCell>xlBook,Blad1,2,C,strCell
mdl>%strCell%

The message dialog seems to return:

Code: Select all

ERR: OLE error 800A03EC

What's wrong with these lines?
I've double checked the Excel document and I'd like to get Sheet: Blad1 C2 which contains a phonenumber.

Any thoughts on this?

Post by **Marcus Tettmar** » Mon Sep 05, 2011 2:18 pm

The code for your XLGetCell line should be:

XLGetCell>xlBook,Blad1,2,3,strCell

(it wants cell,row coordinates, not grid reference).