Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to lookup in numerous different sheets | Excel Discussion (Misc queries) | |||
Comparing numerous sheets | Excel Discussion (Misc queries) | |||
VLOOKUP not retrieving all information | Excel Discussion (Misc queries) | |||
retrieving information | Excel Discussion (Misc queries) | |||
Retrieving information for a day of the week... | Excel Worksheet Functions |