last modified date of imported text file with VBA

[Dark0Prince]

I'm not sure how to do this, but I have an imported file from text, and I need to make sure that the last modified date isn't older then 5days and if it is I need some text box that says "file too old" or something like that.

 

[oldbrewer]

is the import residing in an excel sheet when you check the date ?

 

[Dark0Prince]

I'm going to import a text file into in excel file. I'm not sure I fully understand your question.

 

[oldbrewer]

I am trying to establish if the data is on a single excel sheet - if so we check the date and delete ? the sheet if the date is too old.

How many sheets per day are we talking about ?

 

[Dark0Prince]

I'm not referring to importing an excel sheet I'm referring to a .txt file and I don't want to delete anything. I do imports sporadically throughout the month.

 

[oldbrewer]

so import the text file into an excel sheet and if date is too old color whole sheet red with conditional formatting, maybe

what do you do if it is too old ?

 

[Dark0Prince]

If it's too old I want it just to show a msg box that it is too old. I don't want the import to complete if possible.

 

[oldbrewer]

beyond my skills then as I do not know how to analyse a text file without first importing it - tho a macro could import the file, check if too old and if so delete the excel sheet..........

 

[Dark0Prince]

I deff don't want to destroy the sheet let's do the msg box after the import so that I'm informed that I imported an old date. That would be perfect.

 

[Rick Rothstein]

I'm not sure how to do this, but I have an imported file from text, and I need to make sure that the last modified date isn't older then 5days and if it is I need some text box that says "file too old" or something like that.

Can you show us the macro or event code that you are using to import your text file?