Forms with Embedded WebBrowser

[MikeC14081972]

Hi,

I'm Hoping someone can help. I'm using Access 2000 and have a form with a embedded web browser that will be used to download a file.

The code used to navigate to the webpage and enter the required details is as follows

Private Sub Form_Load()
Dim IE As Object
Dim URL As String

Set IE = Me.ADPBrowser.Object

URL = "Required Page"

With IE
    IE.NAVIGATE URL
End With

While IE.BUSY
    DoEvents
Wend

With IE
    .Document.all("list").Select
    .Document.all("list").Value = "Required value" 
    .Document.all("submit").Select
    .Document.all("submit").Click
End With

While IE.BUSY
    DoEvents
Wend

End Sub

i can get access to pass in the cusip and simulate a user clicking the submit button but this is where my problems start.

I'm then faced with a Windows Message Box asking if I want to 'Open' 'Save' or 'Cancel'.

Does anyone know how to control this message box as it's outside of access. I need to select 'Save' and then pass in the filename and select save again.

many Thanks

If you make something idiot proof - They'll Only make a better idiot!!!