OK,
if this ...
ActiveWorkbook.SaveAs Filename:="X:\Privat\Scani\Inventory 2012-03-07.xlsm", FileFormat:=52
... is working than a problem is in ...
'C2 is a cell with folder path (X:\Privat\Scani)
Folder = Range("C2")
'C3 is a cell with date (2012-03-07)
TodaysDate = Range("C3")
So if you'll have "fix" folder path, than you can write direct in the code. And date? Is this "today" or depends on some other variables. Could be problem that TodaysDate = Range("C3") or Folder = Range("C2") is not reading properly the value from cell.
It is hard to give you 99,9%
solution if we don't know how does look your file, sheets, ...
Play with "get data from a specific cell" ... cheers, Marko
Bookmarks