I have a data file that I need to download and convert from text to xls to then do further manipulation. When I manually fire up excel, open the text file and leave all the text import wizard defaults I can then work with the resulting xls file programmatically. When I use the following code I get errors when I try to open the resulting xls file. I haven't been able to find much about the different options in the OpenText file command so I'm not sure what properties I'm setting incorrectly that the wizard automatically sets correctly. It's a tab delimited file. Can anyone tell me what options I need to set to get it converted correctly? Thanks.
Please Login or Register to view this content.
Bookmarks