Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 153
Default Filename changes daily, anyway to link to most recent file

All

I have a source file that changes names daily (date
included in name), is there anyway to look for the file
name but the pick up the lastest one created.

Either via vlookup or macro or Excel Query?
Reply
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
Copy filename from Excel 2010 Recent Workbooks to Clipboard JL-Seattle Excel Discussion (Misc queries) 0 May 14th 10 10:42 PM
Formula within filename link Bazy2k Excel Discussion (Misc queries) 2 September 11th 09 04:05 PM
changing the filename in a Link Ben Excel Discussion (Misc queries) 1 August 12th 09 04:20 PM
how do i delete a file from recent documents file in excel exile New Users to Excel 1 March 7th 09 01:59 AM
Macro to open most recent file with a particular filename string kwiklearner Excel Discussion (Misc queries) 1 August 23rd 06 01:24 AM


All times are GMT +1. The time now is 06:04 PM.

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

About Us

"It's about Microsoft Excel"