VBA Algorithm Assistance.

[jmcall10]

Hi,

Ok I am completely and utterly stumped and require some assistance of a VBA guru (hence why I am here obviously).

I have an excel table structure as attached and I am trying to write it to an html file (I can write and create a file from excel fine).

The problem I am having is the Algorithm to export my data to HTML.

If you look at the attached file (dummy data for simplicity) you will notice that the first row of the table will have to "rowspan". Which I can get by using (MergeArea.Rows.Count). I know merged rows are not good but I dont control the source of the data unfortunetly.

Attachment 216721

I cannot for the life of me work out the correct algorithm to correctly loop the data and create a string that I can then use to create the HTML.

If this needs further clarification please dont hesitate to ask.

I guess the basic question is, how do I succefully export my excel table to HTML using VBA and so that it keeps the row and column integrity.

Hope this makes sense.

Regards,

jmcall10

[Norie]

jmcall10

Is the only attachment the picture?