Automatically open file

[sabbur]

I have a file called Don's Gas & Hardware. When I open it, I would like a file called Daily Price Sheet to open automatically. How do I achieve this?

[Mordred]

Try something like:

Please Login or Register  to view this content.

This assumes the workbook is in the same path as your workbook that is already open.

[JBeaucaire]

Note, you should be able to use simple lookup formulas like VLOOKUP in your Don's workbook to retrieve prices by part numbers (or such) from the Price sheet without having to open it.

[JBeaucaire]

If that takes care of your need, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.