Results 1 to 4 of 4

Thread: How do I export an Excel worksheet to Word with some specific formatting?

  1. #1

    How do I export an Excel worksheet to Word with some specific formatting?



    Register for a FREE account, and/
    or Log in to avoid these ads!

    I need a macro that will export my Excel worksheet to Word. I would like to use a form control button to do this. I found some help so far, but the export includes the form control button. I need the button to be invisible in the export, just like it would be if I printed the worksheet from Excel.


    Also, I need the macro to rotate the landscape worksheet to portrait when it exports. The worksheet fits within the confines of 1 page in landscape when printed, but I need it rotated in the word document because the word document will include a cover sheet in portrait format.


    If anyone has some code advice for this, I would appreciate it. Thank you.

  2. #2
    Super Moderator p45cal's Avatar
    Join Date
    Dec 2012
    Posts
    1,512
    Articles
    0
    Excel Version
    365
    cross posted:
    http://www.mrexcel.com/forum/excel-q...ormatting.html
    http://www.excelforum.com/excel-prog...ormatting.html


    jasonfromchico, for your information, you should always provide links to your cross posts.
    If you have cross posted at other places, please add links to them too.
    Why? Have a read of http://www.excelguru.ca/content.php?184

  3. #3
    Thank you for that info. Will do next time.

  4. #4
    Super Moderator p45cal's Avatar
    Join Date
    Dec 2012
    Posts
    1,512
    Articles
    0
    Excel Version
    365
    Quote Originally Posted by jasonfromchico View Post
    I I found some help so far, but the export includes the form control button. I need the button to be invisible in the export, just like it would be if I printed the worksheet from Excel.
    If you supply the code that you've already got we can probably tweak it to remove the button from the copy..

Posting Permissions

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