Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Importing text files automaticly.
Hi
I wrote a parser for my company that creates excel friendly text files that saves a lot of time importing them manually. The text file is formatted in such a way excel can read the correct column sizes and all data is imported perfectly. Normally if you open this text file in excel the import text wizard pops up. Now to the problem I wish my parser tool to automatically open the txt file in excel as it does via parameters. However I need to change the column data format (last option in the text wizard). By default excel imports everything as General. The last column needs to be text else the data isnt imported correctly. Is there a parameter that can also specify column formats? I dont mind even if there is a parameter to make the wizard show also. Thanks Kevin |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Importing text-files | Excel Discussion (Misc queries) | |||
importing two text files to same sheet | Excel Discussion (Misc queries) | |||
Importing Text Files | Excel Discussion (Misc queries) | |||
importing multiple text files??? | Excel Discussion (Misc queries) | |||
Importing text files into Excel | Excel Discussion (Misc queries) |