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!!
Bookmarks