MS Office Warning (Some files can contain viruses)

[QasimMGM]

Hi,
This is my second question in this great group,
every time I use VBA codes to open files in my laptop; I got a warning (attached).
is there any way to stop this warning?

 

[EXCEL MAX]

Investigate a little bit security.

I have been simulating your code and find that you need to add location to the trusted location.

1. Go to the Trust Center, press button Trust Center Location then select Trusted Location from left menu.
2. Press button Add new location. Specify full path location from your code. Then OK, OK, OK.
3. Save workbook. Close workbook. Open Workbook again and try code from first post again.

If this not help I don't what may be.

 

[QasimMGM]

Investigate a little bit security.

I have been simulating your code and find that you need to add location to the trusted location.

1. Go to the Trust Center, press button Trust Center Location then select Trusted Location from left menu.
2. Press button Add new location. Specify full path location from your code. Then OK, OK, OK.
3. Save workbook. Close workbook. Open Workbook again and try code from first post again.

If this not help I don't what may be.

Thank you very much for your response,
I already tried this and didn't work ?

 

[EXCEL MAX]

What is content of the cell?

i = Cells(ActiveCell.Row, 1).Text

 

[QasimMGM]

Since you have 64bit Office, you'll need:

Private Declare PtrSafe Function ShellExecute Lib "shell32.dll" Alias "ShellExecuteA" _
                                      (ByVal hwnd As LongPtr, ByVal lpOperation As String, ByVal lpFile As String, _
                                       ByVal lpParameters As String, ByVal lpDirectory As String, ByVal nShowCmd As Long) As LongPtr

This works perfectly
thank you very much ❤

 

[EXCEL MAX]

Now I see one error. Replace sign "+" with sign "&" in the path name.

 

[QasimMGM]

Now I see one error. Replace sign "+" with sign "&" in the path name.

I tried this before but didn't work, but the solution of @RoryA works for me perfectly