none
VBA for Publisher RRS feed

  • Question

  • Hi

    I have some Publisher 2010 dokument with a lot of dates like "2011-10-18" I want to change date format to "18 oct 2011".

    I have no idea how to do!!

    Thanks in advance

    KentÄ

    • Moved by kleinma Tuesday, October 18, 2011 5:25 PM (From:Visual Basic Language)
    Tuesday, October 18, 2011 10:09 AM

All replies

  • Hi,

    Do you want to do the following using VB.net?

    Regards,
    A.Murugan


    If it solved your problem,Please click "Mark As Answer" on that post and "Mark as Helpful". Happy Programming!
    Tuesday, October 18, 2011 10:36 AM
  • Hi

    No, I want to do it in VBA but I coudn't find any site for VBA!! / KentÄ

    Tuesday, October 18, 2011 5:14 PM
  • Hi

    This is VBA for Excel, maybe you can work with that.

    Sub Date_Format()

    Dim ws As Worksheet

    Dim rg As Range

    Application.ScreenUpdating = False

    Set ws = Worksheets("sheet2") 'You need to change it to your name ("Sheet2")

    Set rg = Range("A2:" & Range("A" & Rows.Count).End(xlUp).Address) 'change the column letter,

    'I'm using 'A'

    On Error Resume Next

    For Each Value In rg

           rg.NumberFormat = "dd/mm/yyyy"

      Next

    Application.ScreenUpdating = True

    End Sub

    HTH

    Cimjet


    Cimjet
    Tuesday, October 18, 2011 9:34 PM