Launch IE with Table

P

Pradip Jain

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
 
J

Joel

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.
 
T

Tim Williams

What do you know about HTML ?

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

Tim
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

launch internet explorer from excel 3
Launch IE Browser and manage vertical scroll bars 2
In VBA, make IE Browser object always in foreground 5
Launch IE and scrap data from the web site 1
Making an IE Window the focus for Excel VBA 2
Error 0
Interacting with Excel open in IE 0
HTMLElementCollection Dilemna 1

Top