| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Converting a Text file to Excel
Without going thru the Wizard, is there any way to covert
a text file into an excel spreadsheet (just executing an .exe or .bat file)? We have a requirement to automate the conversion of text file into excel with some predifined formating. Thanks for help. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Converting a Text file to Excel
in code, you can use the workbooks. Opentext method
for example SET WB = Workbooks.OpenText(sFileName) Patrick Molloy Microsoft Excel MVP -----Original Message----- Without going thru the Wizard, is there any way to covert a text file into an excel spreadsheet (just executing an .exe or .bat file)? We have a requirement to automate the conversion of text file into excel with some predifined formating. Thanks for help. . |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Converting a Text file to Excel
There is a very useful program i have found for this
called Monarch. -----Original Message----- Without going thru the Wizard, is there any way to covert a text file into an excel spreadsheet (just executing an .exe or .bat file)? We have a requirement to automate the conversion of text file into excel with some predifined formating. Thanks for help. . |
| 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) | |||
| macro for converting text file to excel | Excel Programming | |||
| macro for converting text file to excel | Excel Programming | |||
![ExcelUser[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
