Skip to content

Instantly share code, notes, and snippets.

@aadennis

aadennis/Ex02.vba

Created July 2, 2018 20:55
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save aadennis/69d385f0fd048f8282e7038259eacf3c to your computer and use it in GitHub Desktop.
Save aadennis/69d385f0fd048f8282e7038259eacf3c to your computer and use it in GitHub Desktop.
Download ZIP
Raw
Ex02.vba
Option Explicit
Public Function GetNowFormatted()
GetNowFormatted = Format(Now, "yyyymmddhhnnss")
End Function
Public Function BuildReference(id)
BuildReference = "TxnId " + Format(id - 3, "000") & " - " & GetNowFormatted
End Function
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment