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!

 

[yytsunamiyy]

Hm, it was a wb in XL07 made up on the spot that just served to help the OP, so I never saved it. I'll try to replicate the problem on Monday when I'm back at work and at the same computer and will send you the wb if sucessful.

 

[snowblizz]

Snowblizz - if you open up the VBE and go Tools>Options>General tab under Error Trapping what option do you have selected? You should have "Break on Unhandled Errors" and definitely not "Break on All Errors".

That did indeed "fix" that problem.

 

[yytsunamiyy]

Strange - I can't replicate the error - at least not in the test-forum. If it occurs again I'll save the file.

 

[sanrv1f]

another one,

I have both XL 03 & 07 open (with HTML maker Add-in included), If I close the 2007 first (not just file, the instance), then it saves a copy of "HTML Maker.xls" in the folder where the file opened in 2007 located,

If I have 2 instances of XL 03, and I close one, it saves "HTML Maker.xla" in the folder

 

[sanrv1f]

The tool generates the list of all names defined in the workbook, even when, they are not referred in the formula

 

[Richard Schollar]

Sankar

That should happen only in certain circumstances eg if the following names exist in the workbook:

Name1
Name12
Name123
Name1234
Name12345
Name123456
Name1234567

Then, if Name1234567 is in a formula being output by the html maker, all the others will be included as well in the html output. However, if only Name1 is in a formula being output by the html maker, then none of Name12, Name123 etc should be output.

Entirely different names not referenced at all in any formulas being output by the html maker shouldn't be output in the html.

Please confirm that this is what you are seeing.

 

[Sandeep Warrier]

Richard,

I tried using the option Generate HTML -> 1st cell only.

I had formulae in cells C3:D6, however the HTML displayed only the formula in C3.

Is it possible to modify the code to display formulae from 1st cell of each selected column?

(I edited the HTML and used the default setting)
http://www.mrexcel.com/forum/showthread.php?p=2055935#post2055935

 

[Richard Schollar]

Hi Sandeep

Did you try using the "First cell in each column" option?

 

[Sandeep Warrier]

LOL.....

real embarrassing... dunno how I missed it

Effects of handling 4 projects at the same time I think...

 

[xenou]

I've been finding this adding very useful ... is it nearing "version 1.0" release for others? Seems great to me - whether or not some bugs remain.