LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 10
Default Test for File Creation Date

I have a workbook which runs a macro to import various files and run
reconciliations between them. Problem is that those files need to be current
- ie. the VBA needs to test the files BEFORE the import process starts and if
the source files don't have today's date then the user needs to be notified
and the process prevented from running.

I think I can do it with adding a reference to Windows Scripting or
something, but how do I guarantee that my user(s) will also have that
reference?

Any help gratefully received!
Thanks
HMA
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
File Creation Date Thomas M.[_2_] Excel Worksheet Functions 3 January 5th 10 01:15 AM
How can I get date of file creation to XLS cell in date format? Radek Simek Excel Worksheet Functions 3 November 8th 07 04:24 PM
File Creation Date Felicity Excel Discussion (Misc queries) 2 February 5th 07 06:06 PM
How to get the creation date of imported file? n_ice Excel Programming 0 October 8th 06 04:06 PM
file creation date munken Excel Worksheet Functions 2 August 31st 05 01:40 PM


All times are GMT +1. The time now is 11:52 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"