Re: Locate Most Recent File

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Tom Ogilvy (twogilvy_at_msn.com)
Date: 10/27/04 

Date: Wed, 27 Oct 2004 07:13:29 -0400

The filesearch object should be able to help you. Look in Excel VBA help
for details and sample code. 

-- 
Regards,
Tom Ogilvy
"andibevan" <andibevan.1es6om@excelforum-nospam.com> wrote in message
news:andibevan.1es6om@excelforum-nospam.com...
>
> Hi All,
>
> I need to be able to locate the most recent file within a specified
> directory so that I can use it for other parts of my code.
>
> Does anyone have any clever ideas on how you can do this?
>
> Thanks
>
> Andy
>
> ;)
>
>
> -- 
> andibevan
> ------------------------------------------------------------------------
> andibevan's Profile:
http://www.excelforum.com/member.php?action=getinfo&userid=9882
> View this thread: http://www.excelforum.com/showthread.php?threadid=272742
>

Relevant Pages

  • Re: Use FIND to return an array of items
    ... use the Union method combined with the sample code in Excel VBA help for the ... Regards, ... Tom Ogilvy ...
    (microsoft.public.excel.programming)
  • Re: Findind values in a worksheet and fornatting them
    ... Look at the sample code provided with the FindNext method of the range ... object (in Excel VBA help). ... > cells on the worksheet to say bold blue text and italic that match the ...
    (microsoft.public.excel.programming)