Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
macro for converting text file to excel
Possibly:
Thisworkbook.SaveAs Filename:="filename", FileFormat:=xlCSV set the FileFormat to the appropriate supported type. Help on FileFormat in the VBE has the supported constants. Being successful would depend on how Excel interprets our file when it is opened and how it manages it on saving. If everything is placed in one column on opening, then doing a saveas with a different format probably won't have much of an effect. You might need to record opening the file using the text import wizard. I assume you want to process many files - so this would be effective if they are all in the same current format. -- Regards, Tom Ogilvy "Venod" wrote in message ... Hi, Can I convert my text files to a specific format in excel without adjusting manually ( Using a Macro ) Regards, Venod.R.G |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Converting excel 2007 to tab delimeter text file | Excel Discussion (Misc queries) | |||
Text Import Wizard, Step 3 (converting .tsv file to Excel) | Excel Worksheet Functions | |||
Converting Excel file to text delimited file | Excel Discussion (Misc queries) | |||
Converting Excel data into semicolon delimited text file | Excel Discussion (Misc queries) | |||
macro for converting text file to excel | Excel Programming |