I have a workbook which holds approx 5 worksheets, every sheet is a result from a transformations (XSLT).
I've written a vba code that turns this transformations in
html outpurs, now I'm desperally wondering to distribute every
html result in each different sheet.
Maybe I'm probably clutching at straws but, if you don't ask you don't get.
In my VBA this string (sHTML) gets the transformation XSLT in an HTML format
sHTML = xmlDoc.transformNode(xslDoc)
I already tried this
Application.Goto Plan1
ActiveCell.Value = sHTML
...and this
Plan1.Range("A1", "E10") = sHTML
But nothing fills this HTML output in one of my worksheet. Will be this impossible to do
I just has searched in the Web and nothing seems to response this question, any help please.
Marcos Hercules dos Santos
How to fill worksheets with HTML
Luis Miguel Abreu
you need VBS
tj-uk
I'm fine, thanks and I hope you're all O.K
Will be this a hard question I just don't have received any reply about it.
I'll follow your suggests before. But going on I wonder, what do you consider the better way to turn four transformation like this proposed in my code proposed to differents worksheets (Sheet1, sheet2, ...)
Marcos Hercules
msmuser
Hey Marcos, you alright
I'd change your XSLT that converts to HTML to generate plain XML instead. Excel has a lot of new methods for displaying XML. I'm not really familiar with them but I know they are there. Actually if your generating XHTML then you could use Excel's XML methods to display the page.