I'm trying to write a powershell script that controls IE to connect to a secure web interface for OPSware that let's me export all the data to a CSV file. I can't seem to create correct cookies and headers to use [System.Net.WebClient ] so that's why I've switched to controlling IE. I've figured out how to navigate and "click" thru what I need but for the last step to submit the export, all I get is a popup from IE 9 at the bottom to open or save the csv file. I can't figure out how to control that portion. Here's a sample of my script

$username = $env:username
# Change this to a location of your choosing
$passwordfile = "C:\OpswareAuth_$($env:username).txt"
# Function to return a password from an encrypted file
Function get-password([string]$credentialsfile) { 
   if (-not (Test-Path $credentialsfile)){ 
      $creds = Get-Credential $env:username 
      $encpassword = $creds.password 
      $encpassword |ConvertFrom-SecureString |Set-Content $credentialsfile
   } else { 
      $encpassword = get-content $credentialsfile | convertto-securestring 
   }
   $ptr = [System.Runtime.InteropServices.Marshal]::SecureStringToCoTaskMemUnicode($encpassword) 
   $pass = [System.Runtime.InteropServices.Marshal]::PtrToStringUni($ptr)
   remove-variable encpassword,ptr
   return $pass
}
 # Create the IE com object
$ie = new-object -com InternetExplorer.Application
$ie.visible = $true
# Navigate to the login page
$ie.navigate(https://gisops02)
do {sleep 1} until (-not ($ie.Busy))
$doc variable $doc = $ie.document
if($ie.Document.title -match "Certificate Error") { 
   #Deal with bad certs 
   $OverRide = $doc.getelementbyid("overridelink") 
   $OverRide.click() 
}
do {sleep 1} until (-not ($ie.Busy))
$doc = $ie.document
# Our login page remembers credentials for an hour even after
# closing a browser, so we're going to enclose the login part
# in a try-catch block, as these fields may not exist if we've already run this.
try { 
   $usernameField = $doc.getElementById('j_username') 
   $usernameField.value = $username 
   $passwordField = $doc.getElementById('j_password') 
   $passwordField.value = get-password $passwordfile 
   $doc.getElementById('bLogin') $submitButton.click() 
   # Wait until login is complete 
   do {sleep 1} until (-not ($ie.Busy))
} catch {$null}
# return servers under Managed Servers
$ie.navigate("https://gisops02/com.opsware.occ.servers/index.jsp")
do {sleep 1} until (-not ($ie.Busy))
$ie.navigate("https://gisops02/com.opsware.occ.servers/menu/process?cmd=export&viewPref=s&i=0&sz=-1&groups=0&items=0&exportChoice=All")
do {sleep 1} until (-not ($ie.Busy))
$csvBody = $ie.document
# here is where I get the popup that I can't control. I played around with ExecWB but it didn't seem to what I needed