Member Avatar for amitash

Hi,
I want to store today value in a string in VBA Word, e.g. today is Oct 04 2012, the string will be = "04102012". Any simple code can achieve that?

Thanks!

  • 2 Contributors
  • 3 Replies
  • 289 Views
  • 3 Hours Discussion Span
  • Latest Post Latest Post by AndreRet
Member Avatar for AndreRet

You would use something like -

Sub FormatNow()
    Dim myWorksheetName As String
    myWorksheetName = Format(Now, "mmmm_yyyy")
    MsgBox myWorksheetName
End Sub
Member Avatar for amitash

Thanks, the code works perfectly well!

    Dim dateStr As String    
    dateStr = Format(Now, "ddmmyyyy")
Member Avatar for AndreRet

Only a pleasure. Please mark as solved thanx.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.