View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mark Mark is offline
external usenet poster
 
Posts: 989
Default Importing Data to a Template

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.