Results 1 to 2 of 2
2003-10-01, 13:10 #1
- Join Date
- Mar 2002
- Thanked 30 Times in 30 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 Normal.dot 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
2003-10-01, 18:27 #2
- 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.