Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Is this possible
Is it possible to in VBA to look through a number of Workbooks and
open a workbook to the sheet containing todays date in a particular cell? (e.g., Workbook names: DTS-351-Jan, DTS-351-Feb, etc... Each workbook contains Worksheets named 1,2,3,4,etc... Where Worksheet names represent the DAY of the month (based on a 5-4-4 Weeks model) and where the DATE is in the same cell on each sheet. ) Can VBA find Todays date in those workbooks and open the workbook and worksheet with Todays date in that cell? Sorry this is not asked very well. Hopefully you can understand what I'm asking. Dave p.s. I am reposting this as my first post didn't appear to go through |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Is this possible
It went through
If your books are set up for a specific month and the sheets represent days in that Month, why do you need to search. It seems like you could construct the correct book and sheet just from the date. -- Regards, Tom Ogilvy "Dave Potter" wrote in message ... Is it possible to in VBA to look through a number of Workbooks and open a workbook to the sheet containing todays date in a particular cell? (e.g., Workbook names: DTS-351-Jan, DTS-351-Feb, etc... Each workbook contains Worksheets named 1,2,3,4,etc... Where Worksheet names represent the DAY of the month (based on a 5-4-4 Weeks model) and where the DATE is in the same cell on each sheet. ) Can VBA find Todays date in those workbooks and open the workbook and worksheet with Todays date in that cell? Sorry this is not asked very well. Hopefully you can understand what I'm asking. Dave p.s. I am reposting this as my first post didn't appear to go through |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|