I have a file save as macro that looks at a value in a cell that I create. I want that value to be YEARMONTHDAY MINUTES.
EX: 20051220 719 which means 12/20/2005 11:59AM
the problem in using the now() function is that you can't use "/" or ":" when saving a file. so the cell value has to equal "20051220 719" in order for the macro to save the file.
EX: 20051220 719 which means 12/20/2005 11:59AM
the problem in using the now() function is that you can't use "/" or ":" when saving a file. so the cell value has to equal "20051220 719" in order for the macro to save the file.