Hi Everyone!

Was anyone able to help with this?

I need help with the following section from that query:

" Is there any possible way to program in VBA in such way that when
msgbox pops up at the very start and I just type in the file name
"ABC123" Open up the correct file on
correct month?

i.e.

A. if file name is ABC123 for this report then go to path 'C:\Documents
\Database'\ABC123\
if file name is DEF456 then go to path 'C:\Documents
\Database'\DEF456\

B. Then, if it is Jan-05 go to correct year folder under then open up
correct xls file. i.e. 'C:\Documents\Database'\ABC123\2005\Jan 05.xls "

Many Thanks!






"James8309" wrote:

Are B5:AO5 real dates, or strings of month/years?

= I just typed Jan 05 in cell B5 then did autofill to AO5.