Using OWC11
We are trying to download a table from a Web site (ASP) to Excel. One of the fields contains phone numbers with ziro ("0") as the first character. While downloading the table to Excel, the program disregard the ziro, and format the number as "Number" without the first ziro. We tryed to use:
spredsheet.Cells(iRow,iColumn).NumberFormat="@"
like in VBA, but it didn't work. How to define this column as text?