Adjust a macro to check for content of a cell and then run a macro on target sheet

Hey guys,

I need help with adjusting my macro. Basically it opens a file and then copies content. However before doing the copying, I want it to check if on the file it opened whether the content of G1 is "pass". If it is pass to run the macro "Adjust" on that workbook.

How do I do that? I tried with:
If ActiveWorkbook.Worksheets("Target").Cell("G1") = "pass" Then Application.Run ActiveWorkbook.Name & "!Adjust"
but it gives me an error

Please Login or Register  to view this content.

Thank you in advance!

P.S.:
Okay, found it. It works fine this way:
If ActiveWorkbook.Worksheets("Target").Range("G1").Value = "pass" Then Application.Run ActiveWorkbook.Name & "!Adjust"

Is this solved?

If you solve a problem yourself before anyone else has responded, please take a moment to describe your solution, chances are some other member will benefit.

Thank you Arlu, I updated it. However, it seems I have another issue.

When there is a dash (-) in the name of the secondary file, the macro won't start and gives error 1004. When I remove the dash from the file name, it works fine.

What is the problem with the dash and any ideas how to solve this?

P.S.:
Found it, when you put it like that it works fine
If ActiveWorkbook.Worksheets("Target").Range("G1").Value = "endprint" Then Application.Run "'" & ActiveWorkbook.Name & "'!Adjust"