Forum Home
Press F1
 
Thread ID: 14959 2002-01-24 07:59:00 excel saving autodate Guest (0) Press F1
Post ID Timestamp Content User
32613 2002-01-24 07:59:00 i have made a logbook with excel and made it so that each day i enter logbook the correct date will show. this is perfect but I need to save each day as a different file in order to keep records the problem being if today was monday 21st and i want to read or print log of saturday 19th which I had saved I get the current date showing when it should be showing the 19th
can anyone help me please?
Guest (0)
32614 2002-01-24 08:39:00 So, you want a macro to change the name of the file? I have done something similar in an old excel 4 macro that you could adapt, if I have got you right on the question.

Email me at f1@email.co.nz

robo.
Guest (0)
1