I have been trying to automate a manual procedure in VBA to retrieve intranet data into Excel. I need to use IE because there is a security login on the site. The developers are displaying a report selection form in an 'iframe'. I need to set the values of several 'option' controls and to submit the form. Everything I have tried causes an 'access denied' error. The Microsoft documentation seems to indicate that it should work if all the pages are in the same domain.
I was able to make a similar VBA routine work in a test version of the site that did not use frames.
My most recent attempt to do this looked like:
ie.Document.frames("framename").Document.forms("formname").all("controlname").Value = "I"
I really have no idea whether this is possible, or whether my problem is that I don't have the syntax correct.
I would appreciate any advice.
I was able to make a similar VBA routine work in a test version of the site that did not use frames.
My most recent attempt to do this looked like:
ie.Document.frames("framename").Document.forms("formname").all("controlname").Value = "I"
I really have no idea whether this is possible, or whether my problem is that I don't have the syntax correct.
I would appreciate any advice.