I'm making a form that extracts values from cells in other workbooks. Using
the form, the user will select the workbook, the worksheet, and then the
cells. My question is how can I obtain the worksheet names in an unopened
workbook so I can list them in a combobox on the form?
I know how to do this in an opened workbook, but I don't want to open the
workbook just to get to the worksheet names. I'm anticipating a user that
selects a workbook, but then decides it doesn't contain the worksheet he
wants, so he goes on to select another workbook. If I open the workbooks
just to access the worksheet names I might end up with a lot of workbook
cluter....
Thank you for looking at my posting.

The short answer is you can't. There are a number of different techniques for
reading data from a closed workbook but they all rely on knowing the struture
of the workbook ahead of time.
--
HTH...

Jim Thomlinson


"GoldenWrench" wrote:

I'm making a form that extracts values from cells in other workbooks. Using
the form, the user will select the workbook, the worksheet, and then the
cells. My question is how can I obtain the worksheet names in an unopened
workbook so I can list them in a combobox on the form?
I know how to do this in an opened workbook, but I don't want to open the
workbook just to get to the worksheet names. I'm anticipating a user that
selects a workbook, but then decides it doesn't contain the worksheet he
wants, so he goes on to select another workbook. If I open the workbooks
just to access the worksheet names I might end up with a lot of workbook
cluter....
Thank you for looking at my posting.