Hi,
can anybody help me?
I have been trying many times but still unable to add filepath in the trusted location has caused my VBA script unable to open files. The filepath is stored in another desktop mapped to my network drive.
The error messages is as follows: "The Path you have entered cannot be used as a Trusted Location for security reasons"
The original desktop whereby the filepath stored has shared and allow full control & modify to my desktop.
I had also tick the the bottom check box Allow trusted location on my network (not recommended)
Really hope anyone can help me...
I have verified. there is nothing wrong with my VBA code.
Sub Open_files_list()
Dim IName As String
Dim Column As String
Dim r As Integer
Sheets("Filepath").Select
Column = InputBox("Please Select Filepath either Column A or B") ' no number, but a b c
For r = 2 To 26
IName = Cells(r, Column)
Workbooks.Open Filename:=IName
ActiveWindow.WindowState = xlMinimized
Next r
ActiveWindow.WindowState = xlMaximized
End Sub
Regards,
Farid
Bookmarks