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!

 

[bbbuffalo]

When you ask will it support sorting and filtering can I ask what you mean? It will ouput a filtered list and just output the visible cells if that's what you meant.

What I mean is will I be able to sort and filter the HTML on the webpage like I am able to do in Excel?

For instance if I have the following fields

Book Title, Author, Genre, Date

Could I filter to see only the Sci-Fi genre and then sort alphabetically by Title.

 

[Richard Schollar]

No - all the html maker does is output a representation of your visible excel data that you select. All sorting and filtering must be done prior to using it.

 

[spanspace]

How well does this work with Excel 2010? I just emailed myself the last file you sent me last Sept. If there is a newer version let me know.

 

[Richard Schollar]

It works fine with 2010 - although there is a small modification required if using a 64bit version of Windows. There is no newer version of the file.

 

[yytsunamiyy]

Hi Richard,

thank you for sending the file over. For some reason it bombs out with:

Runtime Error '429':
Objectgeneration by ActiveX-Component not possible

(Error translated from German)

Debug shows the error at Line:

Sub Generate_Grid(ByRef vGrid As Variant, ByVal rngWhole As Range)
Dim vColumns As Variant, vRows As Variant
Dim dic As Object
Dim i As Long, j As Long, k As Long
Dim ar As Range
[COLOR=red][B]Set dic = CreateObject("scripting.dictionary")[/B][/COLOR]
'first determine columns:
With dic
    For Each ar In rngWhole.Areas
        For i = 1 To ar.Columns.Count
            If Not .exists(ar.Cells(1, i).Column) Then .Add ar.Cells(1, i).Column, ar.Cells(1, i).Column
        Next i
    Next ar

Running XL 07 on Vista Business SP2 32Bit

 

[Richard Schollar]

If you go Tools>References in the VBE can you see "Microsoft Scripting Runtime" listed there? If not, think you will need to install/register this ActiveX control.

 

[yytsunamiyy]

Installed and registered "Microsoft Scripting Runtime" (Scrrun.dll), Problem persists - Do I need any ActiveX references?

 

[schielrn]

When you have some time can you e-mail me here with the latest version I think the last one I got was late last year or early this year.

Thanks.

 

[Richard Schollar]

It hasn't been changed since then Rob

I can email you the file if you need it again - let me know.

 

[yytsunamiyy]

While you are here Richard - is there anything else/other I should do than setting up the "Microsoft Scripting Runtime"? It still won't play nice and stops at the same old line...