Attachments

Status
Not open for further replies.

chet645

Board Regular
Joined
Nov 10, 2010
Messages
67
Office Version
  1. 365
Platform
  1. Windows
new to the forum. can you add attachements to your posts?
 
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:
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.

Forum statistics

Threads
1,224,813
Messages
6,181,114
Members
453,021
Latest member
Justyna P

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top