Html maker - testers required!

[Richard Schollar]

As some of you may be aware, I have been making an add-in to produce html output of selected data in Excel. The output is fairly consistent with that produced by Excel Jeanie as can be seen here:

http://www.mrexcel.com/forum/showpos...&postcount=241

the differences being:

1. the interface is a whole lot simpler
2. you can choose if you want to output all the formulas in selection or only some of them
3. the ouput colour-codes nesting levels in the formulas
4. it only does formulas and data (it doesn't report conditional formatting or data validation applied)
5. it comes as an .xla file rather than an .exe (so doesn't require Admin rights to install!)
6. the code is visible for anyone that wants to laugh (or cry) at it


The generated html should also be considerably simpler as much of the formatting and style elements are now held in a css file applied to the whole Board (Suat Ozgur has created a css class which I link to in the generated html).

It has been tested by me and Jon von der Heyden and feedback from Suat incorporated. What I need now is for some others to test and come back with any comments.

If you would like to see the file and perhaps test it, please Private Message me with your email address and I'll send you the .xla file and a .doc file with guidance notes:

The .xla file is approx 100Kb in size, so it isn't very big. It will work in all versions of Excel since xl2000, although I will be developing a specific xl2007 ribbon interface next.

Thanks!

 

[skyking]

After adding HtmlMaker20101230, I using same procedure to install VBHTMLMaker and that error message pops up. It just like when I install HtmlMaker20090730 unseccussfully.

 

[Peter_SSs]

I using same procedure to install VBHTMLMaker

Is it this procedure you are referring to? If not, please detail the steps you are taking and identify the point at which you are getting the message.

Installation

1. Download the file (a standard .xla add-in file) and place it in your add-ins folder or a directory location of your choice (add-ins folder on my PC is located at:

C:\Documents and Settings\Richard\Application Data\Microsoft\AddIns

2. Open Excel and go to Tools>Add-Ins and place a check next to the MrExcelHtml file (if you don’t see it in the list you will need to click on Browse and locate the file manually).
3. That’s it! It should be ready to be used now, and should be available every time you re-open Excel until you uncheck it from the Add-Ins list.

Since the installation, have you exited right out of Excel and re-started it?

 

[skyking]

Peter,

Thanks for your patient. I have did it the same way as you said. I put the file in
C:\Program Files\Microsoft Office\Office14\Library

Open Excel and go to Tools>Add-Ins, Browse and locate the file manually. After that, the error message pops up with "Compile error in hidden module: modMain". I think when it place a check next to VBE HTML Maker then the error message pops up.

When I un-check it, the error message pops up three time.

That is all I can tell.

 

[Peter_SSs]

Peter,

Thanks for your patient. I have did it the same way as you said. I put the file in
C:\Program Files\Microsoft Office\Office14\Library

Open Excel and go to Tools>Add-Ins, Browse and locate the file manually. After that, the error message pops up with "Compile error in hidden module: modMain". I think when it place a check next to VBE HTML Maker then the error message pops up.

When I un-check it, the error message pops up three time.

That is all I can tell.

I'm not sure what is causing that. If you'd like to PM me with your email address I could send you the file I have been using just in case the one you have is corrupted. Otherwise, I'll have to ask around to see if anybody else has any clues about that issue.

 

[AHALEY]

Are there any solutions for Mac Computers? I'm running Office 2011.

Thanks

 

[Smitty]

Welcome to the Board!

I'm not sure if it's ever been tested on Mac. I might have one at my disposal in a few weeks, so I'll make sure to check then. Until then maybe one of the Mac users can pipe in.

 

[Peter_SSs]

Are there any solutions for Mac Computers? I'm running Office 2011.

Thanks

I don't use a Mac but I did ask among the MrExcel MVPs a few months back about this and got no response. Since I know a few of the MVPs use Macs, I'm assuming the lack of response means that they haven't found (or perhaps haven't looked for) a suitable method of posting screen shots.

 

[sugrue]

I am running Excel 2010 and have installed VBE HTML Maker as an Add-in (I just downloaded it from the SkyDrive site it shows last updated Mar 7, 2011 by Chris Smith).

It shows as an Active Application Add-in in Excel Options. However, it did not add anything to the ribbon and I do not see any new options when I right-click. I have restarted Excel and no differences.

Any suggestions?

Jack

 

[Smitty]

The VBHTML Maker is for copying VBA code. If you open the VBE you'll see it under Tools, but it won't appear on the Ribbon.
HTH,

 

[sugrue]

Thanks Smitty. I see now that I had the 2 add-ins confused. They are both working now.