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!

 

[Richard Schollar]

Oh i see

That is a product of me seeting the width property of the table that holds the formulas. I could remove this setting and then it would work effectively as you stated. The reason why I didn't originally do this is if you have both worksheet formulas and array formulas (and maybe defined names too) all the tables that contain them would potentially be different widths (which I didn't think looked very good) so I decided to standardise the lot.

I am open to differing viewpoints on this though and there are many fewer occasions when there will need to be worksheet and array formula boxes rather than just one or the other so if people feel strongly I can change this.

 

[Sandeep Warrier]

Ohh OK! Cool

I'm not sure how feasible this is, but how about having the table width correspond to the width required for the longest formula being used?

 

[Richard Schollar]

Yeah I think I might be able to do that if I nest all the formula tables within an overall containing table - I'll give that a try and report back. Good feedback - thanks

 

[Sandeep Warrier]

Hi Richard,

There seems to be a problem if someone uses the option "First cell in each column" and if the number of rows containing data is not equal in all columns containing formulae. (Not sure if this makes sense )

See http://www.mrexcel.com/forum/showthread.php?t=539231

 

[Richard Schollar]

****! That shouldn't happen - thanks Sandeep, will have to review the code and replicate to discover why it's doing that.

 

[virtech2k3]

Testing

 

[skyking]

Hi Richard,

While I install "HtmlMaker20090730a.xla" I got "Compile error in hidden module: mCreateHTML". I am running Windows 7 and office 2010.

 

[Peter_SSs]

Hi Richard,

While I install "HtmlMaker20090730a.xla" I got "Compile error in hidden module: mCreateHTML". I am running Windows 7 and office 2010.

Follow the link in my signature block and I think you will find the latest version.

 

[skyking]

Thank you Peter,

HtmlMaker20101230 works for me. However, VBHTMLMaker doesn't. It give me "Compile error in hidden module :modMain". Any other solution?

 

[Peter_SSs]

However, VBHTMLMaker doesn't. It give me "Compile error in hidden module :modMain". Any other solution?

At what point do you get that message? I am using VBHTML maker sucessfully with Windows 7 and Office 2010.