ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Importing Data to a Template (https://www.excelbanter.com/excel-programming/423566-re-importing-data-template.html)

Mark

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.


All times are GMT +1. The time now is 04:24 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com