Results 1 to 7 of 7
  1. #1
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    Alzano Lombardo, Italy
    Posts
    1,483
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Copying a Word or Excel table to a post

    How did you manage to insert a shining star in the Subject of your message?
    <font color=ff69b4>Ciao</font color=ff69b4>

  2. #2
    Platinum Lounger
    Join Date
    Dec 2000
    Location
    Queanbeyan, New South Wales, Australia
    Posts
    3,730
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Copying a Word or Excel table to a post

    The star is put in by a Mod. It signifies a post which has something especially worh while.

    You can do a search on star posts, and you will see what sort of things get the star.

    Though it is discretionary. I'm sure there's many posts out there deserving a star which haven't got one.
    Subway Belconnen- home of the Signboard to make you smile. Get (almost) daily updates- follow SubwayBelconnen on Twitter.

  3. #3
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Copying a Word or Excel table to a post

    The Excel macro as attached to my original post, tries to preserve vertical alignment in cells. In many cases, this is not needed. Omitting vertical alignment can result in significantly smaller posts.

    I have attached a modified version that doesn't set vertical alignment. Also, it copies cells more or less as displayed on screen.

    Note: the next post in thread contains an improved version
    Attached Files Attached Files

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    New, improved version for Excel

    Suggestions by <!profile=Leif>Leif<!/profile> and <!profile=JohnBF>JohnBF<!/profile> (thanks to both!) have led to a new, improved version of the macro for Excel. The Word macro has not changed; it can still be found in the attachment to the <!post=first post,164109>first post<!/post> in this thread.

    The attached macro is intended to be copied into a module in Personal.xls.
    The code needs a reference to the Microsoft Forms 2.0 Object Library (set it in Tools/References... in the Visual Basic Editor)
    You can make it easily available by assigning a toolbar button or keyboard shortcut.

    New compared to the original version:
    <UL><LI>Better handling of number and date formats.
    <LI>Better handling of empty cells.
    <LI>Corrected display of column headings for columns past Z (columns AA ... IV).
    <LI>Macro asks whether you want to preserve vertical alignment. For simple tables, the default No is OK.[/list]Enjoy!
    Attached Files Attached Files

  5. #5
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Copying a Word or Excel table to a post

    Steve (<!profile=sdckapr>sdckapr<!/profile>) suggested adding the option to hide the cell contents, for example for use in the Puzzles forum. I have attached a new version of the Table2Lounge macros for Word and Excel. The instructions for use are the same as in <post#=164109>post 164109</post#> at the top of this thread.
    Attached Files Attached Files

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Copying a Word, Excel or Access table to a post

    Access reference added November 3, 2004 - see <post#=422949>post 422949</post#> below.

    Attachment updated August 5, 2002. See notes below.

    Jefferson Scher's excellent tutorial on Making Tables in the Lounge explains how to create a table in a post, using the new layout options such as horizontal and vertical alignment of text within a cell.

    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.

    Notes:

    Word
    • To make the macro available in all Word documents, you must put in into a module in Normal.dot or in a global template.
    • You can copy the text of the Word macro from the attached text file and paste it into a module.
    • You must have a reference to the Microsoft Forms x.x Object Library (x.x is the version number; this may vary). To check this, in any module select Tools/References
    Attached Files Attached Files

  7. #7
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Copying an Access table to a post

    WMVP <!profile=Francois>Francois<!/profile> has written a VBA procedure to create the Lounge "code" for an Access table or select query. I have attached the procedure as a text file to this post. You can copy it into a standard module in an Access database, then use it as follows:
    <UL><LI>Activate the Immediate window (Ctrl+G)
    <LI>Type

    Table2Lounge "NameOfTableOrQuery"

    (substituting the correct name) and press Enter.
    <LI>You will be prompted whether you want to include field names.
    <LI>The Lounge "code" will be stored in a text file named Table2Lounge.txt in the root of the C: drive. You can open this text file and copy the code to the clipboard, then paste it into a post.[/list]Note: the argument to Table2Lounge can be the name of a table or of a select query; the query should not be a parameter query, neither should it use user-defined functions.

    Thanks to Francois for sharing the procedure.
    Attached Files Attached Files

Posting Permissions

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