VBA - Is there way to select particular tabs and saving data in asp website ?

[Ken]

Hi All,
Using VBA code, trying to open website in Internet Explorer browser, fill data form from excel to web and then save it.

Most of the task is done like opening asp website.

Trouble is selecting particular tabs on asp website and saving data after updates.

Below is the code for IE

Sub Open_InternetExplorer
    dim oIE as object
    set oIE = createobject("InternetExplorer.Application")
    
    oIE.Navigate("[URL unfurl="true"]http://www.msn.com/......asp?....");[/URL]
    oIE.Visible = true;

    [b][COLOR=#EF2929]????? How do we select a particular tab[/color][/b]
    ......
    [b][COLOR=#EF2929]????? after entering the value, how to save it[/color][/b] 

end sub

Any suggestion/tips/solution will appreciate it.

Thanks,

TechIT

 

[SkipVought]

Hi,

Use the Watch Window to DISCOVER what objects are within the IE Object.

How to use the Watch Window as a Power Programming Tool faq707-4594


Skip,

_{Just traded in my OLD subtlety...
for a NUance!}

 

[Ken]

Hi SkipVought,

Thanks for suggestion. Tried it doesn't help.

The asp web page already has links and opens all the tabs.
Able to open the website, trying to go on the specific tab. Currently doing manual click for selecting the tab. Checked the code, isn't helping either.

TechIt