View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
BZeyger BZeyger is offline
external usenet poster
 
Posts: 31
Default 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?