Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can you make excell automaticaly save to the current date & time?
I have a excell program that I developed for a sales recept but I need it to
automatically save under an individual number, date & time ect. If anyone knows how to do this in excell 2003 I would gratly appreciate some help. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can you make excell automaticaly save to the current date & time?
This can be done using a VBA Macro, but the macro needs to know where to
obtain the "number" or how to calculate it......and the programmer needs to know how the macro is to be activated. Vaya con Dios, Chuck, CABGx3 "Jim" wrote: I have a excell program that I developed for a sales recept but I need it to automatically save under an individual number, date & time ect. If anyone knows how to do this in excell 2003 I would gratly appreciate some help. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can you make excell automaticaly save to the current date & ti
I have never worked with VBA Macros and I am lost there. I have a date block
and time equation that changes as data is imputed and that is what I want it to save as. I have never done anything in macro, so could you explain more or email me some information at . Thanks Jim "CLR" wrote: This can be done using a VBA Macro, but the macro needs to know where to obtain the "number" or how to calculate it......and the programmer needs to know how the macro is to be activated. Vaya con Dios, Chuck, CABGx3 "Jim" wrote: I have a excell program that I developed for a sales recept but I need it to automatically save under an individual number, date & time ect. If anyone knows how to do this in excell 2003 I would gratly appreciate some help. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can you make excell automaticaly save to the current date & ti
Post back with the other words/numbers and/or Cell Address(s) that contain
the data you wish to be used as the SaveAsFilename......with a sample of those values. Also state how or why you would like the macro to trigger, such as "pushing a button", or anytime the value in one of those cells changes, or anytime the sheet recalculates, or what? Someone will respond with an appropriate macro. In the meantime, here's a place you could check for some VBA tutorials http://www.mcgimpsey.com/excel/index.html#usingvba Vaya con Dios, Chuck, CABGx3 "Jim" wrote: I have never worked with VBA Macros and I am lost there. I have a date block and time equation that changes as data is imputed and that is what I want it to save as. I have never done anything in macro, so could you explain more or email me some information at . Thanks Jim "CLR" wrote: This can be done using a VBA Macro, but the macro needs to know where to obtain the "number" or how to calculate it......and the programmer needs to know how the macro is to be activated. Vaya con Dios, Chuck, CABGx3 "Jim" wrote: I have a excell program that I developed for a sales recept but I need it to automatically save under an individual number, date & time ect. If anyone knows how to do this in excell 2003 I would gratly appreciate some help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to make excel auto fill in date and current time | Excel Discussion (Misc queries) | |||
Make date change in excel to current date when opening daily? | Excel Discussion (Misc queries) | |||
Save as Current Date / Time | Excel Discussion (Misc queries) | |||
Save Workbook as Current Date/Time | Excel Discussion (Misc queries) | |||
Can I automatically enter the current date or current time into a | New Users to Excel |