On 26/05/2009 21:22, Don Daugherty wrote: > (Chen Hao) wrote: > >> When I use the MS-Excel , I offen use "Ctrl+;" to insert the current date to >> a cell or after some strings in a cell. >> But i find OOo-Calc did not supply this function or I haven't found it. >> Please read carefully the e-mail conversation (thread) we just (18-21 May) had in this list on the subject of inserting a date/time stamp into a Calc cell. You can find the thread at http://www.openoffice.org/servlets/BrowseList?list=users&by=thread&from=2231825
If you examine the source code of the macro referred to you will see how to gain access to the current cell. >> So i want to write a Macro to do this , but there are two problems , and i >> think maybe someone could give me a hand. >> >> 1. how to get the current selected cell with basic ? So that i could modify >> it . >> 2. how to change the path that saving the user-defined macros? I offen >> forgot to backup those things in C-disk when i reinstall my Windows OS >_< >> >> Thanks very much! >> >> Chen Hao >> > Andrew Pitonyak has several publications that I've found useful for > problems like this. One is available via > http://www.pitonyak.org/AndrewMacro.odt > Section 6.5.2 gives a sample macro that gets the current cell. > -- Harold Fuchs London, England Please reply *only* to [email protected]
