Attachments

Status
Not open for further replies.

Peter_SSs

MrExcel MVP, Moderator
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.


N.B.
- With any of the Add-Ins with recent versions of Windows, you may need to "unblock" the file. In Windows Explorer, find the file, right-click, Properties, General tab, tick the 'Unblock' box down near the bottom.
- If you end up with two small squares in your Reply window with any of the HTML makers, close any open Windows Explorer windows and try again.
 
Last edited:

Jon von der Heyden

MrExcel MVP, ModeratorTracy's new best bud
Notes on installing and using the MrExcel HTML Maker

This HTML Maker was custom built for these forums by forum member Richard Schollar and updated by another member MrKowz.

Download the file from the link in the previous post.


Installation Instructions:

  • Extract the MrExcel HTML Maker addin (.xlam) 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 a moderator:
Status
Not open for further replies.

Some videos you may like

This Week's Hot Topics

  • Get External Data (long shot question!)
    This is likely a long shot but I am wondering if it is at all possible for Excel to somehow 'change' the contents of a URL that is being linked to...
  • Importing multiple excel files into one spreadsheet
    Hi, I'm trying to import multiple excel files (with the same format into a single spreadsheet) so that each day's file is listed underneath the...
  • Cell Formatting
    Good Morning, I need to format a few different cells in the following manners: A1 has to always add a colon (:) after whatever is typed in by a...
  • How to copy multiple rows using If
    Hi all, I'm very new to VBA and have written this simple code to copy certain cells if a certain cell within that row contains any data. I need...
  • Workbook_Change stopped working !
    I am working on an app to speed up & automate processing of Credit Cards statements. After data is input from a CSV file, it is presented to the...
  • VBA If statement
    Dear All, I have two dates, where I'd like a message box to pop, if the dates are between this criteria. [CODE] sDate1 = #10/1/2019#...
Top