1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

preserving formatting in Excel?

Discussion in 'Business Applications' started by codejockey, Jan 13, 2003.

Thread Status:
Not open for further replies.
  1. codejockey

    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.
     
  2. Anne Troy

    Anne Troy

    Joined:
    Feb 14, 1999
    Messages:
    11,746
    First Name:
    Anne
    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.
     
  3. codejockey

    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.
     
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 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/113116

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice