need to open a montly workbook based on a date in current workbook

I need to open a Monthly saved file based on the date entered in cell G4.

Our office saves a log of shipments every month, JANUARY 2015, FEBRUARY 2015, ETC.

When I enter the date for a particular shipment into report cell G4, I need vba to open the corresponding month's file to pull over the information for a separate report.

Thanks in advance

This assumes that your shipment logs were saved in the same path of the activeworkbook other wise you'd need to identify the path.

Please Login or Register  to view this content.

I am sorry, I tried to add the path, and I am sure I messed it up, which is why it isn't working, path listed below:

T:\EXCEL000\REPORTS\DOC DEPT\2015 DOC LOGS\

Try:

Please Login or Register  to view this content.

Of course the simplest answer is the best one. thanks!

You're welcome. Glad to help out and thanks for the feedback.