My Excel application does a web query on a html file containing security cusip numbers having an "E" in the 8th position of the data. Excel formats the data as scientific; I need to have a text format. I have tried using a .txt extention on the file and preformatting the cell as text (prior to performing the web query), but nothing has
worked so far. I am able to address this problem on a text import by using .TextFileColumnDataTypes = Array(2). Is there something similar for a Web Query?
worked so far. I am able to address this problem on a text import by using .TextFileColumnDataTypes = Array(2). Is there something similar for a Web Query?