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!

 

[Jon von der Heyden]

That would suggest that you are missing Microsoft Forms 2.0 Library... Although I'm not sure why?

 

[TheNoocH]

this is what Richard sent to me in an email when I had the same problem

You need a reference to the Microsoft Forms 2.0 Object Library - the easiest way to get this is to insert a userform in the add-in (via the VBE just go Alt+I+U). This will create the reference and you can then simply delete the userform (as it isn’t required, just the reference). I suspect that the add-in referenced an earlier version of the library file than you had and so the reference was lost (it may be marked as MISSING when you go Tools>References in the VBE, in which case please uncheck it from the list before you insert the userform)

 

[Jon von der Heyden]

I suspect that the add-in referenced an earlier version of the library file than you had and so the reference was lost.

That explains it...

 

[sanrv1f]

That would suggest that you are missing Microsoft Forms 2.0 Library... Although I'm not sure why?

this is what Richard sent to me in an email when I had the same problem

You need a reference to the Microsoft Forms 2.0 Object Library - the easiest way to get this is to insert a userform in the add-in (via the VBE just go Alt+I+U). This will create the reference and you can then simply delete the userform (as it isn’t required, just the reference). I suspect that the add-in referenced an earlier version of the library file than you had and so the reference was lost (it may be marked as MISSING when you go Tools>References in the VBE, in which case please uncheck it from the list before you insert the userform)

for some odd reason the add-in removes the reference to Microsoft Forms 2.0 Object Library, and I need to refer it again, manually, to resolve the problem

 

[Jon von der Heyden]

I haven't encountered that (yet)...

But perhaps, does adding and keeping a userform in the addin make any difference?

 

[sanrv1f]

Richard,

There could be some problem with providing spaces in the formula

see this

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

when the someone copy the formula to their sheet, that might not work

 

[TheNoocH]

Richard,
would it be possible to determine the cell alignment of the cell and output the html in the same format?

 

[Richard Schollar]

Richard,

There could be some problem with providing spaces in the formula

see this

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

when the someone copy the formula to their sheet, that might not work

Aahhh. ****. Yes that's a problem. I can always remove the addition of spaces in the formula string which then has the possible problem of the formulas not wrapping. So, I could check the position of the quotes in the string and not insert any spaces if the characters I currently search on are within quotes (I already do this for brackets so it may not be that difficult). Everytime I change the functionality there is an unforeseen consequence!

 

[Richard Schollar]

Richard,
would it be possible to determine the cell alignment of the cell and output the html in the same format?

SOunds reasonable - I'll look into it

 

[sanrv1f]

few more,

1. could you make the tool to convert date content to a standard format such as "dd-mmm-yy", I think this could be done in the cell content analysis part (ie) if a cell's format is date then convert the format to standard (http://www.mrexcel.com/forum/showpost.php?p=1987473&postcount=290)
2. the tool seperates any merged cell and shows the content in the first cell only (http://www.mrexcel.com/forum/showpost.php?p=1987474&postcount=291)
3. can you include the version of Excel and the OS, as a tag line in the output
4. just to suggest, can you convert a formulae to standard version (ie) replacing the ";" (used in some non-english verisons) with ","