Factor3
02-26-2007, 03:20 PM
I've put together a Macro that does some reformatting of downloaded Stock prices, and I would like the end of the Macro to Rename the downloaded worksheet (Sheet1) Today's date in the format "dd.mm.yy"
I've tried:
Sheet1.Name = "Today()"
as well as
Sheet1.FormulaR1C1 = "=Today()"
But, I'm not having much luck.
Any ideas?
I've tried:
Sheet1.Name = "Today()"
as well as
Sheet1.FormulaR1C1 = "=Today()"
But, I'm not having much luck.
Any ideas?