VFP Excel probelm

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Hi, Thanks for the help.

I have some data that I'm importing from an excel file using office
automation. I am having the following problem and I wonder if anyone has any
ideas about what to do instead of coding for this exception.

I'm reading a file that contains store names and addresses among other
things

The name of one store is TRUE

When the following line of code

lcHShipToName = loExcel.Cells(lnCurrentRow, 3).Value && Ship to name
from Header Line

encounters the store whose name is TRUE,

the variable read in is a boolean instead of a string.

I've tried going into the spread*** and formatting the column as TEXT but
it didn't help.

Changing the name to TRUE STORE worked but I want to be able to process
these without intervention.

Does anyone have any ideas?

Thanks again,
Jeff


.

Quantcast