Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Page 5 of 5 FirstFirst ... 345
Results 41 to 43 of 43

Thread: excel to excel, excel to word

  1. #41
    MrExcel MVP Anne Troy's Avatar
    Join Date
    Feb 2002
    Location
    Westwood NJ
    Posts
    2,582
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default



    At this point, you can record a macro in Word to format it. When recording the macro, store it in your normal.dot so it's available all the time (you can't really store it in a file that's being newly created from Excel). Here's how to record a macro:

    http://www.thewordexpert.com/wordvba.htm

    (You probably know that already...) Anyway, if you have problems with formatting it, email the doc and I'll see what I can do. I'm very good with tables, which I suspect is the new format. I've also got a tables document for download at:

    http://www.thewordexpert.com/word.htm#AllAboutTables
    ~Anne Troy

  2. #42
    Board Regular
    Join Date
    Mar 2002
    Location
    Massachusetts, USA
    Posts
    255
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Dreamboat: Thanks for the info. I printed out the "How to record a macro..." and will play around with it today. I will reply with questions ASAP. Thanks again.

    NateO - Have a great weekend. You saved my life this week!!!!

  3. #43
    Legend NateO's Avatar
    Join Date
    Feb 2002
    Location
    Minneapolis, Mn, USA
    Posts
    9,700
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Nancy, TGIF!! Have a great weekend! Happy to be of help. Try and see if you can bury your Word Vba in the macro, in an attempt to avoid running macros in two applications.

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •