Wait for Workbook to be created from outside program and then continue once created

This particular bit of script is giving me trouble. I am trying to figure out how to make the VBA program wait until a particular file is generated. Here is the could that is being used.

EDITED : REMOVED CODE

An Run-time error '91 is occurring at : FileToLookFor = Workbooks("Worksheet in RIAUFK20 (1)")

What needs to be changed for the VBA script to recognize that Worksheet in RIAUFK20 (1) is created and ready to be used, and continue further into the program?

Please help!!


Figured it out myself!!

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.