Opening and retrieving information from numerous excel sheets

[Guest]

I am currently trying to do work with numerous different excel sheets. I am
looking for the user to open a blank Excel worksheet and click a button. This
button will make a dialogue box appear and ask which worksheets the user
would like to open. After this task is done, I would like to select a cell
from each sheet opened (for example cell A1). How would I do this?

 

[Guest]

Here's something to get you started.

This is one way to open an Excel file. You can put it in the click event of
a button in any office program.

'Open Excel
Shell """C:\Program Files\Microsoft Office\OFFICE11\EXCEL.EXE"" " & _
"""N:\MyPath\MySpreadsheet.xls""", vbMaximizedFocus
--
Billy Rogers

Dallas,TX

Currently Using SQL Server 2000, Office 2000 and Office 2003