Open the latest workbook

L

Lauraswint

Board Regular
Joined
Aug 27, 2010
Messages
87
Help I am wanting a Macro command to open a workbook in a set location. The trouble is that our MRP program dumps the excel into a set folder.

Is there a command that will open up the newest file in the folder so you would be looking at the latest date to be the file opened for the Macro?

Any ideas as Im sure its an easy command? (Famous last words!)

Thank you in advance
:biggrin::eeek::rofl:
Laura!
 

Excel Facts

Will the fill handle fill 1, 2, 3?
Yes! Type 1 in a cell. Hold down Ctrl while you drag the fill handle.
You must log in or register to reply here.

Similar threads

F
  • Solved
VBA to open all files in a folder, put the file's name in a cell and copy it to another opened workbook
Replies
5
Views
1K
feni1388
F
T
  • Solved
Open all files in a folder and run macro
Replies
3
Views
677
Trebor76
T
O
  • Question Question
How to automatically recalculate all workbooks in a office 365 spreadsheet each time its opened without using vba or macros.
Replies
5
Views
316
felixstraube
F
Y
  • Question Question
Pivot Table deletes on opening of workbook
Replies
3
Views
251
cooleomter
C
T
  • Question Question
Automatically Copying Data To A New Workbook When Closing A Workbook
Replies
4
Views
467
Tmini
T

Forum statistics

Threads
1,224,583
Messages
6,179,682
Members
452,937
Latest member
Bhg1984

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