Macro/VBA to generate and save filenames

[Trouvera52]

I would like to generate and save filenames in a unique way something like:
Prefix_datetimestamp. Can I do this be recording a macro or would VBA be
necessary? Would really appreciate a pointer in the right direction.

Thanks,
Trouvera

P.S. I will be doing this in Word and Excel.

 

[Jezebel]

All macros are VBA, whether you write them or record them. But you can't do
what you describe using the macro recorder.

Dim pFileName as string

pFileName = "Prefix_" & format$(Now, "yyyymmdd")
ActiveDocument.SaveAs FileName:=pFileName

 

[Trouvera52]

Thank you Jezebel.

All macros are VBA, whether you write them or record them. But you can't do
what you describe using the macro recorder.

Dim pFileName as string

pFileName = "Prefix_" & format$(Now, "yyyymmdd")
ActiveDocument.SaveAs FileName:=pFileName