Results 1 to 5 of 5

Save file with ISO correct Workweek

Threaded View

  1. #1
    Forum Contributor
    Join Date
    05-18-2004
    Location
    Portland, Oregon
    MS-Off Ver
    2016
    Posts
    182

    Save file with ISO correct Workweek

    Hello Everyone,

    Last year this portion of my macro worked great assigning the current work week according to ISO standards.

    ActiveWorkbook.SaveAs Application.UserName & "_" & "FCST" & "_" & Format(Date, "MMDDYYYY") & "_" & "CW" & Format(Date, "WW", vbUseSystemDayOfWeek, vbUseSystem)
    Since the change of the year it does not work. For instance, today I ran it and it says we are in work week 3, but ISO says we are in work week 2. I don't know how to fix and I can't seem to find the answer.

    Thoughts?

    Thanks,
    Matt
    Last edited by matt4003; 01-12-2010 at 04:38 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1