Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
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.
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Importing data from Excel worksheet into Excel template Mas[_3_] Excel Discussion (Misc queries) 2 August 14th 11 11:15 AM
Importing Data into an Excel sheet-template spacemancw Excel Programming 5 June 26th 08 01:58 PM
Importing data into specific template cells Ron Excel Discussion (Misc queries) 0 July 11th 06 07:24 PM
Problem with macro for importing data to template Jay_B Excel Programming 3 June 13th 06 08:54 AM
Importing CSV data into a template or? Alberto Excel Worksheet Functions 3 October 28th 05 07:41 PM


All times are GMT +1. The time now is 12:17 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"