pathway reference to file givs out of range errormsg (pathway is set as variable)

Hello,

I have a small problem when reffering to excel file in VBA code with its location on the disc. Basically I have a textbox in userform, where I paste path to particular exce file and I need to display the sheets name in ListBox.
This is the beggining o the code...

Please Login or Register  to view this content.

The problems appears to be in third line of this part, sice apparently, when trying to use variable "zosit" it will not locate the file...

Please Login or Register  to view this content.

Thank you for your help...

zosit is declared inside the first procedure so it is out of scope to the second. You'd need:

Please Login or Register  to view this content.