SaveAs with WeekNum to update the file name everyweek

**iwilli** · 05-29-2012, 03:57 PM

I download data from home office every week. I make a few edits and then need to save it a few times with different names for different uses later. My question this go around: Is it possible to have it save with the week number automatically updating each week? I thought this would work but I get an error as Excel cannot find the file. What am I doing wrong this time?

Please Login or Register  to view this content.

**jeffreybrown** · 05-29-2012, 04:16 PM

8. Don't cross-post without a link. Cross-posting is when you post the same question in other forums on the web. You'll find people are disinclined to respond to cross-posts because they may be wasting their time solving a problem that has been solved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser) to the cross-post. Expect cross-posts without a link to be closed.

X-Post Again