VBA:Open file with current date

[Robert Mika]

I have s folder with file in format
"text date".

Examples:
"CV 24/05/11"
"CV 25/05/11"


Howe to point a macro to open a file with current date?
somthing like "CV" & TODAY()" ?

 

[Sandeep Warrier]

Probably something like

Workbooks.Open FileName:="D:\.....\CV" & Format$(Date, "dd/mm/yyyy") & ".xls"


BTW..... I don't think you can have file names such as "CV 24/05/11"!

 

[Robert Mika]

Hi Sandeep,
Thanks a lot and you are right with the format.
This was just general example.

 

[oceangirltt]

Hello All any help would be appreciated...

I have a file "=(VLOOKUP(A:A,'S:\LOGISTICS DEPARTMENT\PRODUCT SPEC SHEET\Product Specifications and Distribution 10-18-2017" instead of putting the date 10-18-2017 because the file gets updated and the date changes daily what can I use ??? also if the file date doesnt gets updated how can I use the current file in that location to retrieve my information.

 

[Preya]

I need to open and copy the sheet from file in the folder which is daily updated with current date .And also need to save the copied sheet with current date

Example: "ResourceData - 20171120 v1.xlsb"
Save as " ResourceData - 20171120 - Permanent v1.xlsb"

Can anyone help me to sort out this??