Bypass "File has Macros" warning when opening a series of excel files to extract data?

I have a working Excel macro that combines data from several other files that all have the same layout. My annoyance is that it prompts me for each file being opened saying that it contains macros, etc and do I want to continue.

Is there a way to bypass this so the entire process is more streamlined?

Additional info: The OPEN file statements are shown below in bold. Is there an option to ignore the 'File Contains Macros' message?

Here is the macro code to open the files….

 Sub Process_one_File(folderPathname As String, registrationFileName As String)

  Dim sheetName As String
  Dim ok As Integer
  Dim lastRow1 As Long
  Dim lastRow2 As Long
  Dim sourceDataRange As Range
  Dim MasterDataRange As Range
  Dim itemRange As Range
  Dim itemCell As Range
  Dim clubAbbrev As String
  Dim r As Long
  
 
  ok = 1
  If registrationFileName = ThisWorkbook.Name Then ok = 0   ' skip this file
  If Left$(registrationFileName, 11) = "GSL-Entries" Then ok = 0   'skip backup copies of this file
  If ok = 0 Then Exit Sub

  'MsgBox registrationFileName
  
  ' ...  Begin by opeing the selected file, etc   (MAC version)
  If Application.OperatingSystem Like "*Mac*" Then
    Workbooks.Open filename:=folderPathname & ":" & registrationFileName, ReadOnly:=True
  Else
    Workbooks.Open filename:=folderPathname & "\" & registrationFileName, ReadOnly:=True
  End If

  '  ……  process the file…

Try putting

Application.DisplayAlerts = False

before opening the file.

Don't forget to switch it back to True after processing the file.

Thanks bakerman2 for the tip. I had forgotten about that.

Unfortunately, it did not do the trick when I grid it. :-(

I had my doubts it would work since this is a Security feature against malicious software.

One other option is to add the location of the files to the Trusted Locations in Excel Options.

as bakerman pointed out
its a security feature which you need to bypass

some step by step
http://blog.contextures.com/archives...urity-warning/

comments at end gives other suggests other things you may want to try

Hi

I suggest

application.automationsecurity = msoautomationsecuritylow