+ Reply to Thread
Results 1 to 3 of 3

Adding dates & who added the macro in VBA code

  1. #1
    Registered User
    Join Date
    01-20-2013
    Location
    South Africa
    MS-Off Ver
    Excel 2010
    Posts
    3

    Adding dates & who added the macro in VBA code

    Hi

    I am pretty new to macros and vba, (just to warn my teachers)
    I have come across a customer who using macros to add info details for DR's and clients,
    there are 2 peopel using the macros, they are wanting a date and who created the macro when they go into the vba code
    is this possble?
    any help would be appreciated

    James

  2. #2
    Registered User
    Join Date
    01-20-2013
    Location
    South Africa
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: Adding dates & who added the macro in VBA code

    if you can help me with this code


    Sub BRUCE_JD_JHB()
    '
    ' BRUCE_JD_JHB Macro
    ' Macro recorded 2/12/2008 by Donnette

    '
    Selection.TypeText Text:="Dr JD Bruce"
    Selection.TypeParagraph
    Selection.TypeText Text:="PO Box 11"
    Selection.TypeParagraph
    Selection.TypeText Text:="MONDEOR"
    Selection.TypeParagraph
    Selection.TypeText Text:="2110"
    Selection.TypeParagraph
    Selection.TypeParagraph
    Selection.TypeText Text:="Tel: 011 3805684"
    Selection.TypeParagraph
    Selection.TypeText Text:="Fax: 011 4334201"
    Selection.TypeParagraph
    Selection.TypeParagraph
    Selection.TypeText Text:="Dear Jaclyn"
    Selection.TypeParagraph
    End Sub

  3. #3
    Registered User
    Join Date
    01-20-2013
    Location
    South Africa
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: Adding dates & who added the macro in VBA code

    how do I add the Macro Recorded automatically in the code

+ Reply to 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1