Include week number in filename

[amar05]

Hi everyone,
I need a bit of help with one of my macros. The macro below saves a sheet with a specific file name, but I would also like to add the current week number at he end of the file name. i.e Test-WK36.csv

Please Login or Register  to view this content.

Is there a formula that I could add to the macro so that it would include the week num?

Thanks.

[oeldere]

you can use the formula weeknumber to determine the week.

In the code you can refer to that cell.

[fredlo2010]

Hello,

I found something from this website http://www.cpearson.com/excel/WeekNumbers.aspx and implemented it in your code.

Hope it helps

Please Login or Register  to view this content.

Thanks

[Richard Buttrey]

Hi,

You'll need to tell us how you define week number. e.g.
1. The integer of the days since January 1st divided by 7 plus 1
2. Does the day count start on the 1st Sunday,Monday...etc, of the year?