Using VBA to locate a directory
Using VBA to locate a directory
(OP)
I need to be LINK to a given worksheet in a given workbook of an Excel spreadsheet.
I can do this in VBA if I know the name of the worksheet and the name of the spreadsheet and the directory it is contained in. However, I don't know any of these things or it may change every time I want to use the data.
How can I use a directory tree structure to find the .XLS file, open it, list all of the worksheets in the workbook, have the user select the one they want, then attach to the selected worksheet?
VB has some ActiveX controls that allow this very easiy. I can't seem to find a corresponding control for Access 97 or VBA.
Thanks
George

I can do this in VBA if I know the name of the worksheet and the name of the spreadsheet and the directory it is contained in. However, I don't know any of these things or it may change every time I want to use the data.

How can I use a directory tree structure to find the .XLS file, open it, list all of the worksheets in the workbook, have the user select the one they want, then attach to the selected worksheet?

VB has some ActiveX controls that allow this very easiy. I can't seem to find a corresponding control for Access 97 or VBA.

Thanks
George
RE: Using VBA to locate a directory
Ruairi
ruairi@logsoftware.com
Experienced with:
VB6, SQL Server, QBASIC, C(unix), MS Office VBA solutions
ALSO: Machine Control/Automation using GE and Omron PLC's and HMI(human machine interface) for industrial applications