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


    • 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


    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"


    Application.ScreenUpdating = True

    End Sub



    Tuesday, October 18, 2011 9:34 PM