preserving formatting in Excel?

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

codejockey

Thread Starter
Joined
Feb 11, 2002
Messages
1,405
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.
 

Anne Troy

Anne
Joined
Feb 14, 1999
Messages
11,746
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.
 

codejockey

Thread Starter
Joined
Feb 11, 2002
Messages
1,405
Thanks for your response, Dreamboat!

Not sure yet whether this will solve my problem, but very much appreciate your effort.
 
Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 807,865 other people just like you!

Latest posts

Top