say i have the followng lines in a text file
xlNormal=Microsoft Excel Workbook (*.xls)
xlCSV=CSV Comma Delimited (*.csv)
xlText=Text Tab Delmited (*.txt)
if I want to use "xlCSV" as a variable for an excel object, is there a way to do it?
ie. once i read in the data, xlCSV is assigned to a variable theFormat
then run :
Excel.ActiveWorkbook.SaveAs csvFile, FileFormat:=theFormat
so : theFormat->xlCSV->6
can this be done or do i have to actually enter the integer value. xlCSV is a component of the excel object libary.
I would rather use the excel libary components that hard code the ints. ie.
6=CSV Comma Delimited (*.csv) - (bad)
xlCSV=CSV Comma Delimited (*.csv) - (good)