Hi
I posted this last week and now I can't find the replies in Outlook - only
online!
The file that I am working on is an imported .txt and the macro that I am
using crashes with a Run-time error 5 - Invalid procedure call or argument.
The line I'm trying to use is this:
Range("A2").Value =
ActiveWorkbook.BuiltinDocumentProperties("Creation Date")
and I'm wondering if it's because the sheet is not technically a workbook.
The macro imports a .txt file, deletes junk from it and formats some of the
columns and I need to get the creation date of the txt file.

The response I had was to try ("Creation Date"). I have tried this on a few
worksheets, using the immediate window. I get the same date and time for 2
of the sheets (even though they weren't created at the same time) and when I
try it on my txt file I get
Runtime error '-2147467259 (80004005)'. Automation error. Unspecified error.
A search for this on the net doesn't help.
Thanks..
Andy.