It seems that an empty cell in an Excel spreadsheet returns different values, depending on whether it's being read from VFP7 or VFP6.

STEPS TO REPRODUCE:
I created a c:\test.xls with nothing in cell A1.

Then, I ran the following program:

LOCAL XLApp, x, lcFileName

lcfilename = 'c:\test.xls'     && Your filename here.

XLApp = CreateObject('Excel.application')
XLApp.WorkBooks.Open(lcFileName)

x = xlapp.workbooks(1).sheets(1).cells(1, 1).value
=messagebox(vartype(x))

XLApp.quit()

RESULTS:
I get "C" in VFP6, and "X" (.NULL.) in VFP7.

EXPECTED RESULTS:
Same in both VFP6 and VFP7 [Should remain C(0), not be changed to .NULL.]

- George