Attachments
Upcoming Power Excel Seminars
Likes Likes:  0
Results 1 to 3 of 3

Thread: Attachments

  1. #1
    New Member
    Join Date
    Nov 2010
    Posts
    42
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Attachments

     
    new to the forum. can you add attachements to your posts?
    0 0
     

  2. #2
    MrExcel MVP
    Moderator
    Peter_SSs's Avatar
    Join Date
    May 2005
    Location
    Macksville, Australia
    Posts
    36,421
    Post Thanks / Like
    Mentioned
    30 Post(s)
    Tagged
    6 Thread(s)

    Default Re: Attachements

    The answer is 'No', but you can post small screen shots of your sheet(s). There are several methods. Here are 4 for you to investigate.

    MrExcel HTML Maker (HtmlMakeryyyymmdd) by Richard Schollar (Win)
    Note: An updated version (20170807) has been provided by MrKowz in 2017. If you are using an older version, it would be best to update to provide tidier screen shots.

    Forum Tools Add-In by RoryA (Win & Mac)
    Note: An updated version has been provided in 2017. If you are using an older version, it would be best to update to provide tidier screen shots.

    Excel jeanie by Peter Haserodt (Win)

    Borders-Copy-Paste (Either)


    Test them in the Test Here forum before use in a main forum for the first time.
    Last edited by Peter_SSs; Oct 18th, 2017 at 09:05 PM.
    Hope this helps, good luck.
    Peter
    Excel 365 + Excel 2010, 2007 - Windows 10, 7
    - Want to help your helpers by posting a small, copyable, screen shot directly in your post? Look here
    - If posting vba code, please use Code Tags - like this [code]Paste code here[/code] - or use the VBHTML Maker
    - Read: Forum Rules, Forum Use Guidelines, & FAQ
    1 0
     

  3. #3
    MrExcel MVP
    Moderator

    Tracy's new best bud
    Jon von der Heyden's Avatar
    Join Date
    Apr 2004
    Location
    Blackboys, East Sussex, UK
    Posts
    10,597
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    1 Thread(s)

    Default Notes on installing and using the MrExcel HTML Maker

      
    This HTML Maker was custom built for these forums by forum member Richard Schollar.

    Download the file from the link in the previous post.


    Installation Instructions:

    • Extract the MrExcel HTML Maker addin (.xla) from the compressed folder. You may need to download an extraction program such as WinZip.


    • Locate the Addin’s folder on your computer. If you are uncertain where it is, in Excel invoke the Addin’s dialog in Excel and click ‘Browse’. Note the default folder path.


    • Save the addin to the Addin’s folder.


    • In Windows Explorer, track to the file you have just saved to the Addin's folder, right click & choose Properties. On the 'General' tab look down the bottom to see if you need to 'Unblock' the file and do so if that option is available.


    • Go to excel, invoke the Addin's dialog and locate the addin in the list. If it is not there then click browse and locate the addin. Place a check-mark beside the addin, if not already checked.


    • Once installed you will notice a new menu called ‘MrExcelHTML’. This appears in the worksheet menu bar for Excel versions 2003 and earlier, or within the ‘Add-Ins’ tab in Excel 2007 and more recent versions.

    Before you copy any table to a forum post, consider which of the default options you want to apply. On the MrExcelHtml menu, expand ‘Set Default Options’.

    • All Formulas – this option will generate a separate table showing every formula within each formula cell within the selected table.


    • First Cell Only – this option will generate a separate table showing the formula in the first cell that has a formula within the selected table.


    • First Cell In Each Column – this option will generate a separate table showing the formula in the first cell in each column that has formula within the selected table.


    • No Formulas – no formula table is generated.


    • User Defined Selection – this option will generate a table based on the pre-selected range, but allows you to choose which formula cells to display in the formula table.

    Using the MrExcel HTML Maker:

    1. Highlight the table range in your excel worksheet that you want to display.

    2. Go to the MrExcelHtml menu.

    3. If you are happy to proceed with your default option, click ‘Generate Html (use Default)’. If you want to use a different option then expand ‘Generate Html (specify option)’ and choose from one of the options listed above.

    4. The HTML Maker will generate the HTML and place it in your clipboard. Return to your forum post and paste it into the editor.

    5. Finish typing your question and hit ‘Submit’.
    Last edited by Peter_SSs; Apr 1st, 2018 at 06:35 AM. Reason: Video no longer available, Need to unblock in recent Windows versions
    1 0
     

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
  •  

 

 
DMCA.com