I need helping saving a web page. I have researched this topic and just don't understand what I'm doing wrong. I cannot use URLdownloadtofile because the page I am trying to download has to be accessed by logging in and going to the page (I have automated IE to get to the page and URLdownloadtofile can't pull the data even after I'm logged in and the page is pulled up). I have also tried the ExecWB function. ExecWB pulls up the dialog box great, but won't actually save the file for me (even if I use OLECMDEXECOPT_DONTPROMPTUSER).

[VBA]oBrowser.ExecWB OLECMDID_SAVEAS, OLECMDEXECOPT_DODEFAULT, "C:\myfile.xlm", Null[/VBA]

URLdownloadtofile or ExecWB may work, but I am having trouble getting ExecWB to do anything more that pull up the "Save As" dialog box and URLdownloadtofile is not working at all. Thank you in advance for the help!