Paul_Hossler:

A couple of issues.

When the filename that you're calling from another workbook contains spaces, you come up with these issues if you're trying to use/call that workbook by referencing its Variable name from another Workbook.
Excel VBA APPARENTLY does NOT allow you to just do what you were suggesting.

That being said, I would like to see how others have gotten around this in addition to what jindon provided, which turned out to be a workable solution.

Thanks for your input.