METHOD Object Failure

.
.
My project is showing an error : "METHOD 'Worksheet of object'_Global Failed". I'm trying to query data in a separate workbook and display
in the Listbox and Textboxes on a Userform.

It utilizes a routine by Chip Pearson - which functions really well if the data is located in the same workbook.

Please advise what error/s are present in the existing project to query another workbook. His code doesn't indicate this but it appears to presume
that if it is to query another workbook, the code only has to indicate the path and not first "open" the other workbook (module code). I've indicated which workbook to query in the Module: InWorkbook = "C:\Program Files\Logit\FCC.xlsm"

Thank you for your assistance.
.
.
Image1.jpg
.
.
Image2.jpg

AlphaFrog

Thank you so much for your assistance. I apologize for the confusion re: the workbook being hidden. This doesn't justify it but I was working on several things this morning and forgot to change the coding so the things would not be hidden.

With your assistance the project does what I need it to, using just a few rows of data. Let's see if it will run with alot more.

Thank you again !