unique filenames in macros
 

Hi, I'm trying to set up a macro that will record my screen everyday
at a specific time. I want the recorded file saved but I can't figure
out how to get a macro to give each file a unique filename. Is there a
way to make a macro save files with unique names (perhaps using some
wildcard in the filename that could specify date or something)?
Thanks.

unique filenames in macros
 

ActiveWorkbook.SaveAs "C:\MyFiles\StatusOn" & Format(Date,"yyyymmdd") &
".xls"

--
Regards,
Tom Ogilvy

wrote in message
oups.com...
Hi, I'm trying to set up a macro that will record my screen everyday
at a specific time. I want the recorded file saved but I can't figure
out how to get a macro to give each file a unique filename. Is there a
way to make a macro save files with unique names (perhaps using some
wildcard in the filename that could specify date or something)?
Thanks.