Close Current IE Browser Window after Dowload and Save

A kind of quick and dirty way should be

Dim oServ As Object
Dim cProc As Variant
Dim oProc As Object

Set oServ = GetObject("winmgmts:")
Set cProc = oServ.ExecQuery("Select * from Win32_Process")
For Each oProc In cProc
    If oProc.Name = TheNameOfTheProcessYouAreInterested Then 'iexplore.exe
     
      oProc.Terminate  ' With this command you can kill it
    End If

Select allOpen in new window

Maybe ...i don't have time to test it...it would be a good idea to search if you can handle the downloading without IE ..i have found this post that downloads files without the need of a browser

Automation error : Set oServ = GetObject("winmgmts:")

Dim oServ As Object
Dim cProc As Variant
Dim oProc As Object



Set oServ = GetObject("winmgmts:")
Set cProc = oServ.ExecQuery("Select * from Win32_Process")
For Each oProc In cProc
    If oProc.Name = TheNameOfTheProcessYouAreInterested Then 'iexplore.exe
     
      oProc.Terminate  ' With this command you can kill it
    End If

  Next

Select allOpen in new window

Capture.JPG

Use the DownloadFile function found in my article:

Show pictures directly from URLs in Access forms and reports

Fast and clean.

Runs fine on me...probably you have some kind of issue Which Access ,what OS ?

Access 2016 Windows 10

So the Same here...except if you are using Office 64bit.

32 bit

If you are on 32bit then probably is a permissions issue....or even a problematic update (i have seen something about KB4011051 causing this kind of issues)

Why all this trouble to download a file ...

Gustav - error on line :

   Url = "https://portal.cms.cmsnet/ibmcognos/bi/?pathRef=.public_folders%2FMAS%2FALJ+HQ+Ad+Hoc+Reports%2FPerformance+Goals%2FFY19+Aged+Case+Goal+List&format=spreadsheetML&Download=true&prompt=true"

Select allOpen in new window

Invalid Outside Procedure

That's because the URL seems to be invalid. It hos no domain:

https://portal.cms.cmsnet

Select allOpen in new window

I get the same error when I run your example

Which error and which example, please?

But as long the URL isn't valid, it is not possible the check this further.

To check, type your URL into a normal browser. If it doesn't open a site or download a file, it cannot be used.

Thanks