Results 1 to 2 of 2
  1. #1
    Plutonium Lounger
    Join Date
    Mar 2002
    Thanked 31 Times in 31 Posts

    Copying a Word or Excel table to a post

    In August, 2002 I posted macros to copy tables from a Word document or Excel spreadsheet to the clipboard, ready to be pasted into a post in the Lounge. My post was lost when Claude had to delete a large number of posts earlier this year.

    Here is a reconstruction of the original post, with the attachment.

    <img src=/w3timages/blueline.gif width=33% height=2>

    I thought it might come in handy to be able to create a simple table in Word or Excel and copy it to a post. I wrote a couple macros to achieve this. You will find them in the attached text file.


    <UL><LI>To make the macro available in all Word documents, you must put in into a module in or in a global template.
    <LI>You can copy the text of the Word macro from the attached text file and paste it into a module.
    <LI>You must have a reference to the Microsoft Forms 2.0 Object Library. To check this, in any module select Tools/References
    Attached Files Attached Files

  2. #2
    Gold Lounger
    Join Date
    Feb 2003
    Wardrobe Malfunction Junction, Derry
    Thanked 0 Times in 0 Posts

    Re: Copying a Word or Excel table to a post

    Thanks much for this.


Posting Permissions

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