On the click event of commandbutton open another excel workbook

[aman1234]

Hi All

I have designed a form where there are lots of commandbuttons. When the user click on commandbutton1 then I want to open up another project stored in the shared folder. SO when the user click on commandbutton2 then the another project should be opened. similarly for other commandbuttons as well. Is it possible? If yes can anyone please help me do it.

Thanks a lot for your help in advance!!!!

[snb]

Most of the time you can replace a lot of commandbuttons by 1 combobox.
Instead of opening new projects it could be much easier to use multipage in a userform.