PDA

View Full Version : [SOLVED:] Windows activate + Todays date



ChrisAch
07-12-2016, 05:01 AM
Hi

Trying to activate a commonly named file, with date format added to each day

I am unable to activate the below code, am sure its something simple :banghead:


Windows("Errors" & Format(Date, "ddmmyy") & ".xlsx").Activate

Thanks

mdmackillop
07-12-2016, 05:23 AM
I don't see an error in your code. What is your code to create the workbook name?

ChrisAch
07-12-2016, 05:40 AM
You're spot on, I had a '' '' in the name I had not accounted for.

Thank you