Hi guys,
I have a workbook which holds approx 5 spreadsheets, every sheet is a
result from a transformation (XSLT).
I've written a vba code that turns this transformation in an html
format, What I was wondering is to distribute every html result to your
differents sheets.
I know i'm probably clutching at straws but hey if you don't ask you
don't get.
In my VBA this string gets the transformation XSLT in an HTML format
Dim sHTML As String
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 Excel sheets
Thanx
Marcos Hercules Santos
Bookmarks