Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
more data on that...
turns out it's actually more of a "Text to Columns" that is wanted. The data, in a file called *.xls, is in an unformatted structure, with a tilde ~ delimiter. What is wanted is a template oriented method of getting the ~ delimited data into it's true column structure, with all fields in text format. I wrote a simple program to accept the file name, open the file, and use TextToColumns to format it, but the user would prefer a true template approach, if possible. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Importing data from Excel worksheet into Excel template | Excel Discussion (Misc queries) | |||
Importing Data into an Excel sheet-template | Excel Programming | |||
Importing data into specific template cells | Excel Discussion (Misc queries) | |||
Problem with macro for importing data to template | Excel Programming | |||
Importing CSV data into a template or? | Excel Worksheet Functions |