Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
find current data with macro
Hi,
i'm looking for the macro code to find out the current date and have it in this format 20080905 (yyyymmdd) it's should be easy but i don't find anything about it please can anyone help me thanks francesco |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
find current data with macro
Try
Range("A1").Value = Format(Date, "yyyymmdd") Mike "Francesco Magagnino" wrote: Hi, i'm looking for the macro code to find out the current date and have it in this format 20080905 (yyyymmdd) it's should be easy but i don't find anything about it please can anyone help me thanks francesco |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
find current data with macro
Tnhanks!
i had tried this and it didn't work... now i have understand! i used: Dim y As Date y = Format(Date, "yyyymmdd") but the right one was Dim y As String y = Format(Date, "yyyymmdd") Bye bye Franz Range("A1").Value = Format(Date, "yyyymmdd") |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to find where is the current file saved | Excel Discussion (Misc queries) | |||
How can I Run a query from VB macro with out affect current data in the same sheet? | Excel Discussion (Misc queries) | |||
Macro to find the first cell in a column with different data | Excel Discussion (Misc queries) | |||
Function to find row with most current date | Excel Worksheet Functions | |||
I need a macro to find cut and paste data to new cell | Excel Discussion (Misc queries) |