Is this possible?

D

dpotter41

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Is this possible 1
non basic code in call stack 3
linking sheets and workbooks 0
VBA code for pasting links -- modifying RDB code for summary workbook 11
Code execution is correct but generates Error :The file you aretrying to open is in a different form 3
Cell values to an array, then array transpose to another workbook 8
Merging from an Excel file with graphics 1
VBA loop to create named .csv files for all worksheets and workbooks in a folder 11

Top