Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Extracting date file modified from a text file.
Hi
As part of an error checking control step I would like to add some VBA to a Macro which requires extracting the date of modification of a text file. Specifically I want to read the date modified property of an external .txt file before continuing to import the data from that file into my current workbook. If this date modified property does not equal Todays date (Today()) I want a message box to appear saying the File will not be imported as it was not modified Today. I then want the Macro to be terminated. If it does equal todays date - no message box and continue with the rest of the Macro code. Would anyone be able to help me with the coding of this Thanks Eddie |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Extracting date file modified from a text file.
"webels" je napisao u poruci interesnoj
... Hi As part of an error checking control step I would like to add some VBA to a Macro which requires extracting the date of modification of a text file. there is vba function 'filedatetime(filename)' which returns the date-time of a specified file-name, so you may process it as you want |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Extracting date file modified from a text file.
On Apr 19, 5:02*pm, "sali" wrote:
"webels" je napisao u poruci interesnoj .... Hi As part of an error checking control step I would like to add some VBA to a Macro which requires extracting the date of modification of a text file. there is vba function 'filedatetime(filename)' which returns the date-time of a specified file-name, so you may process it as you want Thanks Sali Will this give me the modified time of the file? Or will it return the created date? Thanks for your help Eddie |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Extracting date file modified from a text file.
The help files says "Returns a Variant (Date) that indicates the date and
time when a file was created or last modified", so if the file were modified, then that is the date that is returned. By the way, it is always a good idea to read the help files about any new command you hear about (while not the case here, there could be optional arguments that would be handy to know about). The easiest way to get to the help file for a particular command is to put the cursor on it (if you do not have it in code yet, just type it into the Immediate Window) and press F1. -- Rick (MVP - Excel) "webels" wrote in message ... On Apr 19, 5:02 pm, "sali" wrote: "webels" je napisao u poruci interesnoj ... Hi As part of an error checking control step I would like to add some VBA to a Macro which requires extracting the date of modification of a text file. there is vba function 'filedatetime(filename)' which returns the date-time of a specified file-name, so you may process it as you want Thanks Sali Will this give me the modified time of the file? Or will it return the created date? Thanks for your help Eddie |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Extracting date file modified from a text file.
On Apr 19, 9:43*pm, "Rick Rothstein"
wrote: The help files says "Returns a Variant (Date) that indicates the date and time when a file was created or last modified", so if the file were modified, then that is the date that is returned. By the way, it is always a good idea to read the help files about any new command you hear about (while not the case here, there could be optional arguments that would be handy to know about). The easiest way to get to the help file for a particular command is to put the cursor on it (if you do not have it in code yet, just type it into the Immediate Window) and press F1. -- Rick (MVP - Excel) "webels" wrote in message ... On Apr 19, 5:02 pm, "sali" wrote: "webels" je napisao u poruci interesnoj ... Hi As part of an error checking control step I would like to add some VBA to a Macro which requires extracting the date of modification of a text file. there is vba function 'filedatetime(filename)' which returns the date-time of a specified file-name, so you may process it as you want Thanks Sali Will this give me the modified time of the file? Or will it return the created date? Thanks for your help Eddie Thanks Rick looks good and thanks for the advice and again thanks sali for the pointer |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Getting file name and Modified date | Excel Programming | |||
insert the date the file was last modified | Excel Discussion (Misc queries) | |||
Last modified date of a linked file | Excel Discussion (Misc queries) | |||
date file modified | Excel Discussion (Misc queries) | |||
Get the date a file was modified | Excel Programming |