Opening and retrieving information from numerous excel sheets
 

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?

Opening and retrieving information from numerous excel sheets
 

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


"BZeyger" wrote:

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?