Getting Web data 1

[PavelGur]

I'm trying to get some Web data using VB6 program. I navigate to URL I compiled and then before opening the page I'm getting pop-up box asking me whether I want to save or open the spread sheet. What should I do to answer the question in the code?
Thanks, Pavel.

 

[macleod1021]

Is the spreadsheet being opened by your code? If so, pass the Excel SaveDocument method before attempting to close it.

 

[PavelGur]

No, I do not open Excel. I navigate to URL that is an Excel Spread Sheet.
oIE.Navigate sURL1
Do Until oIE.ReadyState = READYSTATE_COMPLETE
DoEvents
Loop
Right after going from Navigate to DoEvent the popup window appears with the questions open, save, or cancel.
I tried oIE.Silent = True but it does not do the job.
Thanks, Pavel.

 

[PavelGur]

I also tried to use left arrow key manually twice and then press enter. It works manually. But when I try to use SendKeys "{LEFT 2}" and "{~}" it does not. It seems to me that SendKeys sends it to the parent window rather than to pop-up. How can I address the pop-up?
Thanks, Pavel.