Hi Need a bit help,
I have seen several entries here how to pick the sheet new from the table where I actually am or the other sheets in the excelfile.
But I need a macro to show me the sheetnames from another file.
so bascally I need to enter the path (A1), and file name in B1
and in e.g. "C5" and down the sheetnames will then appear.
Have any of got an Idea how to do that ?
Thanks a lot in advance
Uli
I have seen several entries here how to pick the sheet new from the table where I actually am or the other sheets in the excelfile.
But I need a macro to show me the sheetnames from another file.
so bascally I need to enter the path (A1), and file name in B1
and in e.g. "C5" and down the sheetnames will then appear.
Have any of got an Idea how to do that ?
Thanks a lot in advance
Uli