rossmiddleto
12-14-2010, 09:45 AM
Hi Everyone,
I just need a quick bit of code that opens a workbook takes the current date and works out what the coressponding week number would be. If someone could help me out it will be more than appreciated.
Lookup table looks like the following
Week - Friday - Max - Min
WK49_10 - 10Nov10 - 16NOV10 - 10NOV10
So if the current date is the 14th december the VBA would use this table to return a string variable that equals Wk49_10
Thank you in advance
Ross
I just need a quick bit of code that opens a workbook takes the current date and works out what the coressponding week number would be. If someone could help me out it will be more than appreciated.
Lookup table looks like the following
Week - Friday - Max - Min
WK49_10 - 10Nov10 - 16NOV10 - 10NOV10
So if the current date is the 14th december the VBA would use this table to return a string variable that equals Wk49_10
Thank you in advance
Ross