Closing Excel Path Popup

Hi there.

I'm trying to get a vba macro in which i'd get values from various closed workbooks in a folder. Since this folder is will be sent to many users, and Indirect doesn't work and i don't want to use Pull formula, i came up with the code above. I'm using the function Cell(FIlename) and a list of workbooks to get the current path.

"Sub Test()

Dim Path As String
Dim Cell As Variant
Dim Rng As Range

Set Rng = Selection
For Each Cell In Rng

Path = Cell.Offset(0, 13)
Cell.Value = "=Iferror(Sumproduct(" & Path & ")/2,0)"

On Error Resume Next
Next

End Sub"

The problem is that everytime a workbook doesn't exist, Excel pop up a windows to input the path. Is there anyway to avoid this action?

Thank you for your time,

Fjcosta

Thanks for the help, TMS.

Managed to do it with application.displayAlerts.