Bypass SECURITY WARNING when opening an xlsx wb via VBA.

I am trying to open an xlsx file via VBA in a xlsm wb so that the xlsx sheet contents can be copied into the xlsm wb, but I am having trouble bypassing a "SECURITY WARNING External Data Connections have been disabled" prompt that occurs after issuing the Workbooks.Open command (below).

SECURITYWARNING_Excel.png

Please Login or Register  to view this content.

For the UpdateLinks param I have tried:

• Not using it.
• Setting it = True.
• Setting it = False.
• Using an Enter via Sendkeys.

None get me past the prompt.

Thoughts would be appreciated. Thx!

It opens and displays the xlsx wb without displaying the SECURITY WARNING message- I know it's there because I see it when I open the xlsx wb manually. I have to click in the xlsm wb and invoke the copy function again for it to actually get past the workbooks.open command. Ideally, the xlsm wb should open the xlsx wb, copy the data into itself, and close the xlsx wb without the user even seeing the xlsx wb.

I just discovered a video that shows how to get data from a closed Excel wb, so I'll post the info if it proves successful.