I’m trying to use the Internet Explorer object in VB. When I navigate this site using this command

oIE.Navigate “https://dss.nyiso.com/dss/docViewAGN...DocType=csv”

I get a box that asked me to click Open, Save, or Cancel.
How do I click the Save button in VB Code?

What are you trying to do with this code? Do you want to open IE? Do you want to save the page? If so, to where? etc.

mmcdonal

I have IE open successfully. The URL is to a site to download csv files. I want to save the csv file locally.

I am not sure about that. I don't know if you can download and save files without some interaction. I would suggest a trip to the Windows Scripting Center: http://msdn.microsoft.com/library/de...scriptinga.asp

mmcdonal

Thanks mmcdonal. I've been doing alot of internet searching for how to do this and haven't found anything yet. I'm wondering if there is a way to use Sendkeys to click the button

I've played with this some more and almost have it working. If the dialog box has focus I can use Sendkeys and it works. However, How do I set focus on this dialog box? Once I find this out, I think I have it.

I am not sure how you would give a dialog box focus. Normally you take the button click value and do something with that. Is there a way you can do this without the dialog box?

mmcdonal