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