Automating a lLink to an Esxcel spreadsheet

[GeorgeDurkee]

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

 

[huzza]

Have you tried using the VB active X control in access as most of them will work in VBA as well as VB
Richard