Automate button pop pap save web page in Internet explorer

[LuisOrtin]

I have a macro that has the following code:

Set objPic = ActiveSheet.Pictures.Insert ("C: \ Temp \ INPI_files \ LogoMarcasServletController")

Every time he runs I have to confirm manually by clicking the save button and then confirm save as by clicking the yes button.

Is it possible to altomatize this?

 

[LuisOrtin]

 

[LuisOrtin]

I'm sorry I was tired yesterday, the code that triggers is:

IE.ExecWB 4, 1, "C:\Temp\inpi.html", ""

The problem is that the confirmations appear to overwrite the file.

 

[LuisOrtin]

With solution I created a script that is very simple to do. Just paste the code below into a Notepad and save it with nomequanquer.vbs. When you click on it, it searches the dialog box every 20 seconds and clicks the save button. Note: It is running straight, do not forget to close it when you are not using it. Again it is not ideal but at least it saves the fingers rs. (I'm a layman, I close it through the task manager).

Set ClickSalvar = createobject("wscript.shell")

Do
   ClickSalvar.AppActivate "Salvar"
   wscript.sleep 500
   ClickSalvar.sendkeys ("%(l)")
   wscript.sleep 20000
loop