i want to add a macro to launch IE window from Excel. I want the IE window to
contain a table which is populated from data to be taken from the excel
sheet. Suppose currently the data what i want to populate in the IE window is
contained in an excel array FinalResult (10,5)

i got the code to launch the IE window. code below launches a blank IE
window. how do i populate this IE window with the data contained in array
FinalResult (10, 5). I want the data to appear in a table format with
borders. Please help.

Sub LaunchIE()

Set ie = CreateObject("InternetExplorer.Application")
ie.AddressBar = False
ie.MenuBar = False
ie.Toolbar = False
ie.Width = 610
ie.Height = 700
ie.Left = 0
ie.Top = 0
ie.resizable = True
ie.Visible = True

End Sub

I would recommend opening a word application and design you webpage in word.
Then save the word document as HTML. Next open the html document in a IE
explorer application. The web browser is not intended to as a tool to create
web pages, it is only a viewer.

"Pradip Jain" wrote:

i want to add a macro to launch IE window from Excel. I want the IE window to
contain a table which is populated from data to be taken from the excel
sheet. Suppose currently the data what i want to populate in the IE window is
contained in an excel array FinalResult (10,5)

i got the code to launch the IE window. code below launches a blank IE
window. how do i populate this IE window with the data contained in array
FinalResult (10, 5). I want the data to appear in a table format with
borders. Please help.

Sub LaunchIE()

Set ie = CreateObject("InternetExplorer.Application")
ie.AddressBar = False
ie.MenuBar = False
ie.Toolbar = False
ie.Width = 610
ie.Height = 700
ie.Left = 0
ie.Top = 0
ie.resizable = True
ie.Visible = True

End Sub

What do you know about HTML ?

IE.navigate "about:blank"
Do While IE.busy
Loop
IE.document.Open "text/html"
IE.document.write "<html<bodyYour table goes here</body</html"
IE.document.Close

Tim


"Pradip Jain" wrote in message
...
i want to add a macro to launch IE window from Excel. I want the IE window
to
contain a table which is populated from data to be taken from the excel
sheet. Suppose currently the data what i want to populate in the IE window
is
contained in an excel array FinalResult (10,5)

i got the code to launch the IE window. code below launches a blank IE
window. how do i populate this IE window with the data contained in array
FinalResult (10, 5). I want the data to appear in a table format with
borders. Please help.

Sub LaunchIE()

Set ie = CreateObject("InternetExplorer.Application")
ie.AddressBar = False
ie.MenuBar = False
ie.Toolbar = False
ie.Width = 610
ie.Height = 700
ie.Left = 0
ie.Top = 0
ie.resizable = True
ie.Visible = True

End Sub