Returning a string incorporating date & time in VBA

[jt42cwr]

Hi,

is it possible to return a string incorporating a current (system) date and time in a VBA Macro?

Such as (for the time this message was posted), "20110518-1240" (In UK format).

Thanks,

Damian

 

[pgc01]

Hi Damian

Try:

MsgBox Format(Now, "yyyymmdd-hhmm")

 

[jt42cwr]

How about like this?

Dim dateNow as String

dateNow = ????????????????

 

[pgc01]

???

Does the string I posted not work?

Dim dateNow As String
 
dateNow = Format(Now, "yyyymmdd-hhmm")