On May 20, 8:05*pm, alshiks wrote:
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.- Hide quoted text -

- Show quoted text -

see your other post.
Regards,
Madiya