I have a file path
G:\Asset Services MI\BSS PACK\ASSET SERVICES\2011\SEPTEMBER\CORPORATE ACTIONS
The spreadsheet i need to open is called Month End September11.xls
I want to open this file using a macrro button, so need code to open the latest file.
The only part of the path that changes is the month (SEPTEMBER), Next month will be OCTOBER
An the Spreadsheet will be called
Month End October11.xls
Has anyone got some code that could open this?