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]

Hi Richard,

No critique, just a question:

Would it be possible to include an option to return the selected Range as text only?
Some boards, XING in particular, only allow text-entries. If you want to show a table it has to have the format

...A.....B....C
1.C.....1.....x
2.B.....3.....y

and so on. XING and other pure text-boards tend to dump tabs and spaces.

Bonus question: Can you include an option to output formulas in the native-language of the system via Range.FormulaLocal rather than Range.Formula?

Edit: COOOOOOOL - this is post 666 - PURE EVIL! HA HA HA HAHAAAAAAAA!

 

[Richard Schollar]

The formulalocal wouldn't be difficult but I don't follow on the first question - the add-in is only meant for use on MrExcel.com (it references css styles contained in the forum code so it will never be fully portable (with all formatting) to other forums that do not have these codes embedded in their css. I don't really understand what you mean when you say to return as text only as being html it is only being returned as text?

 

[yytsunamiyy]

but I don't follow on the first question - the add-in is only meant for use on MrExcel.com (it references css styles contained in the forum code so it will never be fully portable (with all formatting) to other forums that do not have these codes embedded in their css.

Sorry, I didn't realise that. In that case there is no point in trying to make it portable. I actually didn't want to preserve formatting - that's a can't do anyway in ASCII-only forums.

I don't really understand what you mean when you say to return as text only as being html it is only being returned as text?

I meant to get the result as if you copy a range from XL to the Windows-Editor, manually replace the tabs with "." to preserve spacing and copy the resulting text to the board in question, so instead of

(imagine the actual table rather than html showing here )

Excel Workbook
	A	B	C
1	c	1	x
2	b	3	y
Tabelle1

you get

...A.....B....C
1.C.....1.....x
2.B.....3.....y

The formulalocal wouldn't be difficult

If the html maker is only for Mr. Excel there isn't much point in implementing - after all, there isn't that much traffic in "Questions in other Languages" where it might come in handy.

 

[sanrv1f]

del

 

[sanrv1f]

deleted

 

[yytsunamiyy]

Hi Richard, even with build 20090730a the problem with "< " seems to persist. See here: http://www.mrexcel.com/forum/showpost.php?p=2043069&postcount=17

 

[snowblizz]

When I close Excel I get the following "crash". Runtime error "5" here (last line):

Sub CleanUp()
    Dim cbc As CommandBarControl
    On Error Resume Next
    Set cbc = Application.CommandBars("Worksheet Menu Bar").Controls("MrExcelHtml")
    If Not cbc Is Nothing Then
        Do
            cbc.Delete
            Set cbc = Nothing
            Set cbc = Application.CommandBars("Worksheet Menu Bar").Controls("MrExcelHtml")     <--- here

Furthermore, it leaves the menuoptions intact, I now have 6 copies of the menu when I right click! As it creates a new one each time Excel starts.
EDIT:
It also crashes whenever part of the selection has text in the formula.
Or if I select empty formulas, it crashes, and when stopping the debugging it pops a Msgbox saying "nothing found".

 

[Richard Schollar]

yytsunamiyy I will check out the code - that looked like an array formula and it may be the case that these aren't handled correctly.

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".

 

[yytsunamiyy]

actually, the problem didn't occur in the array-formula, but in the normal


=IF(MATCH($B$1,'List of Values'!$A$1:$A$4,0) < MATCH($D$1,'List of Values'!$A$1:$A$4,0),$D$1,$B$1)

with " < MATCH(" missing.

 

[Richard Schollar]

Hmm, I'll have a look at the code but that shouldn't be happening - can you send me the worksheet that holds the formula where this problem occurs (remove any other sensitive info, just make sure the problem exists when you generate the html) - thanks!