Hi all,
I am trying to open a workbbok and select the tab with today's date (12 Apr).
Thanks
Hi all,
I am trying to open a workbbok and select the tab with today's date (12 Apr).
Thanks
Code on ThisWorkbook module :
Please Login or Register to view this content.
1. I care dog
2. I am a loop maniac
3. Forum rules link : Click here
3.33. Don't forget to mark the thread as solved, this is important
Hi can you post an example of you spreadsheet
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"
same as Karedog but different
Please Login or Register to view this content.
Click *Add Reputation to thank those who helped you. Ask if anything is not clear
Thank you all for your help.
I have tested the formaula and it does exactly what I need except on the workbook I am trying to do it on.
I think the way the worksheets are named are a little wierd so I have attached the 2 documents.
wb1 = "Servicing Daily Planner1 - test" is where the VBA will be stored.
wb2 ="11 Servicing Daily Planner May 17 - test" is the document that is to be opened & the worksheet with todays date selected.
wb2 - Worksheet (todays date) F4 = wb1 - Worksheet "Daily Planner" F4
Thank you all in advance.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks