vba help - split input file name and fine latest date file

M

Mallesh23

Well-known Member
Joined
Feb 4, 2009
Messages
976
Office Version
  1. 2010
Platform
  1. Windows
Hi Team,

I have a folder, Which contain input files day wise.
this is below standard day wise files.

Folder Name Aug_2020.
Input files
US Bank File_13.08.2020
US Bank File_14.08.2020
US Bank File_15.08.2020
US Bank File_16.08.2020

Task is how to find Latest file after splitting input files name.
that will be Current workbook.
and Previous dates file will be Previous workbook.

In above example - Current workbook will be - US Bank File_16.08.2020
In above example - Current workbook will be - US Bank File_15.08.2020

please help, thanks in advance.


thanks
mg
 

Excel Facts

Repeat Last Command
Pressing F4 adds dollar signs when editing a formula. When not editing, F4 repeats last command.
You must log in or register to reply here.

Similar threads

GMC The Macro Man
  • Solved
VBA Script - Return to named file
Replies
6
Views
123
mumps
mumps
H
  • Question
VBA split file based and send splitted file in separate emails
Replies
0
Views
148
harmless92
H
A
  • Question
Creating a workbook from a Tracker spreadsheet that links back to cells within the Tracker spreadsheet
Replies
2
Views
173
AndyEd
A
D
  • Question
Retrieve values from workbooks saved in another drive
Replies
8
Views
234
mumps
mumps
M
  • Question
Excel VBA Save PDF within workbook folder and send as email attachment
Replies
1
Views
217
rpaulson
rpaulson

Forum statistics

Threads
1,214,805
Messages
6,121,656
Members
449,045
Latest member
Marcus05

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top