D
Durand
Hi,
I'm trying to write a macro to get onto a bank website and download
client reports into Excel.
Thanks to Jimmy Pena's excellent site*, I've been able to get past the
username and password. But now that I'm past the firewall, and am
ready to select which client I want the report for, I'm confronted
with... a combo box (aurgh!). How do you select a client from a combo
box?
If it helps, here's the HTML source code that appears to be around it.
(I have changed client names and account numbers to protect the
innocent):
</TABLE>
<TABLE border=0 width=640 cellpadding=5 cellspacing=1><TR><TD
WIDTH="35%" class="TableSubHeadLeft">account</TD><TD WIDTH="65%"
class="TableCopyLeft"><SELECT size=1 onchange="changeAccountList()"
name="accountddfld"><OPTION VALUE="BLOGGS FRED - 123454321">BLOGGS
FRED - 123454321
<OPTION VALUE="SMITH JOHN - 123454322">SMITH JOHN - 123454322
</SELECT>
</TD></TR>
<TR><TD WIDTH="35%" class="TableSubHeadLeft">account type</TD><TD
WIDTH="65%" class="TableCopyLeft">Macquarie Super Manager</TD></TR>
</TABLE>
Regards,
Durand
*Jimmy Pena's site is http://www.codeforexcelandoutlook.com/AutomateInetExplorer.html
I'm trying to write a macro to get onto a bank website and download
client reports into Excel.
Thanks to Jimmy Pena's excellent site*, I've been able to get past the
username and password. But now that I'm past the firewall, and am
ready to select which client I want the report for, I'm confronted
with... a combo box (aurgh!). How do you select a client from a combo
box?
If it helps, here's the HTML source code that appears to be around it.
(I have changed client names and account numbers to protect the
innocent):
</TABLE>
<TABLE border=0 width=640 cellpadding=5 cellspacing=1><TR><TD
WIDTH="35%" class="TableSubHeadLeft">account</TD><TD WIDTH="65%"
class="TableCopyLeft"><SELECT size=1 onchange="changeAccountList()"
name="accountddfld"><OPTION VALUE="BLOGGS FRED - 123454321">BLOGGS
FRED - 123454321
<OPTION VALUE="SMITH JOHN - 123454322">SMITH JOHN - 123454322
</SELECT>
</TD></TR>
<TR><TD WIDTH="35%" class="TableSubHeadLeft">account type</TD><TD
WIDTH="65%" class="TableCopyLeft">Macquarie Super Manager</TD></TR>
</TABLE>
Regards,
Durand
*Jimmy Pena's site is http://www.codeforexcelandoutlook.com/AutomateInetExplorer.html