Problems automating inVBA

[Cliff]

I'm attempting to automate input to an ASP/AJAX web-page using VBA, however,
I've encountered a couple of problems:

1) when selecting from dropdown A manuallly, dropdown B is populated with a
series of options depending on the option selected in drropdown A. While I
can select from dropdown A in VBA, dropdown B never gets updated. Prsumably
I need to trigger some event on the page, but how do I accomplish this in
VBA?

2) clicking a button creates an "on the fly" dropdown depending on the
contents of a textbox. How do I access this dropdown and select an option?

Apologies if these questions seem naive and beginnerish, but I'm working
well outside my comfort zone.


Cliff.

[Mark Rae [MVP]]

Re: Problems automating in VBA

"Cliff" <cliff.havard@v irgin.netwrote in message
news:u_qCj.3033 $Ff4.2420@newsf e5-win.ntli.net...

I'm attempting to automate input to an ASP/AJAX web-page using VBA

Please clarify which software you are using:

ASP or ASP.NET (AJAX works only in ASP.NET, not ASP)
VBA is Visual Basic for Applications, the programming language which comes
with Microsoft Office, not ASP or ASP.NET


--
Mark Rae
ASP.NET MVP

http://www.markrae.net

[Cliff]

Re: Problems automating in VBA

Apologies for the lack of clarity, as I said, while I've got a fair bit of
experience using VBA to automate Excel, this project is at the limits of my
knowledge and experience.

I'm using VBA to populate the fields on a web-page from data held in Excel
using the Internet Explorer object via GetElementById. I think frm the
research I've been able to make, the page itself was developed iusing
ASP.NET. I hope this helps.

Thank you for taking the time and trouble to reply.


Cliff.

[Mark Rae [MVP]]

Re: Problems automating in VBA

"Cliff" <cliff.havard@v irgin.netwrote in message
news:u_sCj.8358 $jH5.5137@newsf e3-win.ntli.net...

Apologies for the lack of clarity, as I said, while I've got a fair bit of
experience using VBA to automate Excel, this project is at the limits of
my knowledge and experience.

Hmm - OK...

I'm using VBA to populate the fields on a web-page from data held in Excel
using the Internet Explorer object via GetElementById. I think frm the
research I've been able to make, the page itself was developed iusing
ASP.NET. I hope this helps.

Please post your code...


--
Mark Rae
ASP.NET MVP

http://www.markrae.net