Tech Support Guy banner
Status
Not open for further replies.
1 - 3 of 3 Posts

·
Registered
Joined
·
1,405 Posts
Discussion Starter · #1 ·
Apologies if this has been asked and answered previously (although I searched the archives, I couldn't find the info I needed). I want to do one of two things:

(1) include formatting information in a CSV or tab-delimited file and have Excel automatically apply this formatting when the data are imported;

(2) create a template that contains the formatting information and have the formatting automatically applied when the data are imported.

Note that the data may be produced anywhere, not necessarily from an Excel spreadsheet export.

Any help appreciated.
 

·
Registered
Joined
·
11,755 Posts
Create the code you need to format the doc the way you want it.

(See how to record a macro in Excel at http://www.theofficeexperts.com/officevba.htm#ExcelVBA)

Then, make sure you store that code in your personal.xls file.

(See personal.xls in the help file)

You'll want to put a special button on the toolbars from which to run your code. Open the TXT or CSV or whatever, and hit the macro button.
 

·
Registered
Joined
·
1,405 Posts
Discussion Starter · #3 ·
Thanks for your response, Dreamboat!

Not sure yet whether this will solve my problem, but very much appreciate your effort.
 
1 - 3 of 3 Posts
Status
Not open for further replies.
Top