<div>
That looks good, that is picking the right file, now how do i open it?<br />
<br />
Thanks
</div>


That looks good, that is picking the right file, now how do i open it?

Thanks

<div>
Got it<br />
<br />
Workbooks.Open (strFile)
</div>


<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
I have a file called<br />
<br />
Call_Report_June_2014.xlsx<wbr /><br />
<br />
next month it will be <br />
<br />
Call_Report_July_2014.xlsx<wbr /><br />
<br />
It will be ran on the 01/08/2014<br />
<br />
<br />
Can i get some code that recognises the last month, so on 01/08/2014 - it will seek file name<br />
<br />
Call_Report_July_2014.xlsx<wbr /><br />
<br />
on the 01/09/2014 it will seek file name<br />
<br />
Call_Report_September_2014<wbr />.xlsx<br />
<br />
<br />
Many thanks
</div>
</div>


Hi,

I have a file called

Call_Report_June_2014.xlsx

next month it will be 

Call_Report_July_2014.xlsx

It will be ran on the 01/08/2014


Can i get some code that recognises the last month, so on 01/08/2014 - it will seek file name

Call_Report_July_2014.xlsx

on the 01/09/2014 it will seek file name

Call_Report_September_2014.xlsx


Many thanks

Open file with changing month

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.