>Currently I'm filling an Excel sheet with data from VFP. I'm using the VLOOKUP function. Here's a problem I encounter.
>
>

>poExcel.Selection.Formula = "=VLOOKUP(A4,'January 2010'!$A$3:$J$9,10,FALSE)"
>

>
>This gives good results in my Excel, but it screws up on another PC. The crux is the comma. The other machine expects the semicolon as separator. However, if I change the commas to semicolons, it screws up on MY machine.
>
>It is controlled by a machine's Regional setting (Regional and Language Options > Regional Options > Customize > Numbers > List Separator).
>
>Isn't there any PC-independent character to use? Is there any workaround?

Peter,

If you know that there are only two options, then, probably, the below will be enough:

lconerror=onerror(...)
ll=.f.
ON ERROR ll=.t.
poExcel.Selection.Formula = "=VLOOKUP(A4,'January 2010'!$A$3:$J$9,10,FALSE)"
on error &lconerror
if ll
           poExcel.Selection.Formula = "=VLOOKUP(A4;'January 2010'!$A$3:$J$9;10;FALSE)"
endif