+ Reply to Thread
Results 1 to 5 of 5

Save file with ISO correct Workweek

Hybrid View

matt4003 Save file with ISO correct... 01-12-2010, 03:49 PM
Leith Ross Re: Save file with ISO... 01-12-2010, 04:17 PM
matt4003 Re: Save file with ISO... 01-12-2010, 04:29 PM
Leith Ross Re: Save file with ISO... 01-12-2010, 04:35 PM
matt4003 Re: Save file with ISO... 01-12-2010, 04:38 PM
  1. 01-12-2010, 04:35 PM #1
    Leith Ross is offline
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,259

    Re: Save file with ISO correct Workweek

    Hello Matt,

    Copy Chip's code in a standard VBA Module. Add this line where you need it...
    ActiveWorkbook.SaveAs Application.UserName & "_" & "FCST" & "_" & Format(Date, "MMDDYYYY") & "_" & "CW" & IsoWeekNumber(Date)
    Sincerely,
    Leith Ross

    Remember To Do the Following....

    1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.
    2. Thank those who have helped you by clicking the Star below the post.
    3. Please mark your post [SOLVED] if it has been answered satisfactorily.


    Old Scottish Proverb...
    Luathaid gu deanamh maille! (Rushing causes delays!)
    Reply With QuoteRegister To Reply
  2. 01-12-2010, 04:38 PM #2
    matt4003 is offline
    Forum Contributor
    Join Date
    05-18-2004
    Location
    Portland, Oregon
    MS-Off Ver
    2016
    Posts
    182

    Re: Save file with ISO correct Workweek

    Thanks Leith! I was so close, just missed the last part of "(Date)".

    Works great!

    I will close the thread as Solved.

    Cheers,
    Matt
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1