| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Creation date in cell
Hi
I posted yesterday and got a few ideas for this, but I've run into a problem. 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. Thanks. AndyB |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to show file creation date in a worksheet cell | Excel Worksheet Functions | |||
| How can I get date of file creation to XLS cell in date format? | Excel Worksheet Functions | |||
| Date Creation in Cell | Excel Worksheet Functions | |||
| Day before creation date in cell or as sheet name | Excel Programming | |||
| How do I show file creation date in a cell in Excel? | Excel Worksheet Functions | |||
Threaded Mode
