Hi All,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
<o></o>
I am new to this message board and somewhat new to VBA (a few months of experience). Maybe it is my inexperience but I ran into a problem that I was not able to solve by searching google. I am trying to streamline a process for my company that usually takes forever. I need to export website reports in excel format. First I have to select Excel (65) from a drop down menu on the page, which I am able to do. Then I have to click on the Save As (btnExport) button on the webpage, however when I do this with VBA a new window appears and then goes away without anything else happening. If I click with my mouse a save as box appears like normal. What am I doing wrong? Here is my code.<o></o>
<o></o>
<o></o>
‘select Excel from the dropdown list<o></o>
ieApp.document.getElementById("ddExportList").Value = "65"<o></o>
<o></o>
Do While ieApp.Busy: DoEvents: Loop
Do Until ieApp.ReadyState = READYSTATE_COMPLETE: DoEvents: Loop<o></o>
<o></o>
‘click the Save As button<o></o>
ieApp.document.getElementById("btnExport").Click<o></o>
<o></o>
I am new to this message board and somewhat new to VBA (a few months of experience). Maybe it is my inexperience but I ran into a problem that I was not able to solve by searching google. I am trying to streamline a process for my company that usually takes forever. I need to export website reports in excel format. First I have to select Excel (65) from a drop down menu on the page, which I am able to do. Then I have to click on the Save As (btnExport) button on the webpage, however when I do this with VBA a new window appears and then goes away without anything else happening. If I click with my mouse a save as box appears like normal. What am I doing wrong? Here is my code.<o></o>
<o></o>
<o></o>
‘select Excel from the dropdown list<o></o>
ieApp.document.getElementById("ddExportList").Value = "65"<o></o>
<o></o>
Do While ieApp.Busy: DoEvents: Loop
Do Until ieApp.ReadyState = READYSTATE_COMPLETE: DoEvents: Loop<o></o>
<o></o>
‘click the Save As button<o></o>
ieApp.document.getElementById("btnExport").Click<o></o>