[ukemigrant]

Originally posted by kevina
The problem you are encountering is that the DATETIME macro contains a space, and you aren't quoting the macro value in the assignment.

Something like this will work better:
Application.Macros(vbldMacroTemporary).Add "TEST_DATETIME", "%DATETIME%"

Note: using .Add will ensure the macro exists with the value specified, creating if necessary

Kevin

Thanks Kevin but for some reason that did not work either - I tried something like that.

This works though:

Application.Macros(vbldProject).Add strMacroName, Application.Macros(vbldSystem).Item("DATETIME").Va lue

Cheers, Sam.