Open URL with VBA without Security Message

[TFCJamieFay]

Hi all,

I've got some code that opens a CSV file via a URL. The problem is that I want to open a large number of these files without a security warning message asking me if I'm really really sure I want to open the CSV file (which I am by the way!). Is there any way to bypass this without altering my registry? I'm using the following code (not all of it is here as there's quite a lot of it):

    'Find the last used row
    intLastrow = Sheets("Daily_Data").Range("A" & Rows.Count).End(xlUp).Row
    dtmMaxDate = Application.Max(Sheets("Daily_Data").Range("A2:A" & intLastrow)) + 1

    intDatesNeeded = (Sheets("Settings").Range("Today").Value - dtmMaxDate)
    Select Case intDatesNeeded
        Case 0
            MsgBox "The Daily_Data sheet is upto date."
            Exit Sub
        Case Else
            ReDim arrDatesNeeded(0 To intDatesNeeded)
            For intCounter = UBound(arrDatesNeeded) To LBound(arrDatesNeeded) Step -1
                arrDatesNeeded(intCounter) = Sheets("Settings").Range("Today").Value - intCounter
                strURLDate = Format(arrDatesNeeded(intCounter), "yyyymmdd")
                strURL = _
                    "https://www.MyURL.com\" & strURLDate
                ActiveWorkbook.FollowHyperlink Address:=strURL

Many thanks,

Jamie

 

[Norie]

Have you tried turning off alerts?

Application.DisplayAlerts = False

 

[TFCJamieFay]

Yes, sorry I missed that off my code. See below:

Sub macUpdateDaily_Data()

On Error GoTo ErrorHandler

    'Turn screen updates and alerts off
    With Application
        .DisplayAlerts = False
        .ScreenUpdating = False
        .DisplayStatusBar = True
        .StatusBar = "Updating Daily_Data Worksheet..."
        .Calculation = xlCalculationManual
    End With

 

[Norie]

Jamie

So even with that you still get the errors?

Have you looked into adding the URL to Trusted Locations?

Not the full URL for a file but the 'base' URL, eg https://www.MyURL.com\.

 

[TFCJamieFay]

Hi Norie,

No, I'm not sure how to do that? I had a quick look at my browser settings, but couldn't see anyway to do that. The file is from a web-based system that I use all day, so I'm not sure if that would help.

I think I'll just have to bite the bullet!

Thanks for all your help,

Jamie

 

[TFCJamieFay]

Hi Norie,

No, I'm not sure how to do that? I had a quick look at my browser settings, but couldn't see anyway to do that. The file is from a web-based system that I use all day, so I'm not sure if that would help.

I think I'll just have to bite the bullet!

Thanks for all your help,

Jamie

 

[Norie]

Jamie

It's not a browser setting, it's an Excel setting which you can find in the Trust Center which you can access via Options.