How To Apply A Button To Open Another Workbook In Excel

How to apply a button to open another workbook in Excel?

This one is excellent when you are working with several workbooks at once. You can now format your workbook like a webpage by linking them with one another through a button.

This tutorial is done using visual basic and macro. Though this is an advanced level tutorial but it is easy one when you know how to do it.

Let’s learn How to apply a button to open another workbook in Excel step by step.

1. First you will need a button which you can create from insert and then clicking shape. You need to design the button according to your need.
2. Now you need the visual basic code and you can access it by clicking “Developer- Visual Basic- Insert- Module.
4. Save It.
5. Now right click on the button you created and select assign macro.
6. Now double click “Openworkbook_Click” and Its done.

Now you can click the button to open another workbook.

If the file path is correct then you will see a new workbook and a dialogue box saying “This workbook is opened!”.

If the path is wrong you will get a message saying "This workbook does not exist!"
Have fun.

#excel10tutorial #excelbutton

Thanks for watching.

-------------------------------------------------------------------------------------------------------------
-------------------------------------------------------------------------------------------------------------

If you like this tutorial, please subscribe:

Checkout our Advance Excel Tutorial Playlist:

Checkout our Excel Case Playlist:

Connect us on social media

[hambalioke]

Thanks for your tutorials. That is the code that I have been looking for a long time.

[franciscovillalobos]

I just tested this out and it worked for me. Thank you for your tutorial

[mohamadsiddeek]

Thanks for your response, because this project would be helpful for me carry out my work and it will help many establishedment. please show your generosity.so I begged many of them no body extend the hand
Thanks and God bless you
Siddeek

[NadimTopsecret]

Hello Brother,
Thanks for the tutorial you shared.
Can I know how to stop that dialog box when open the file.

[lisafrankland]

This is great is it possible to have the code to open up a copy of the file instead of the original file ? Please

[asifullslam]

Can I open a specific workbooks by writing filename in a textbox and open it in a new window by pressing a command button?

If you have solution please share with me.

All of your videos have inspired me to learn ExCeL. Thanks a lot and waiting for your answer

[gingebadoy]

Hi, I already signed up but didnt receive the code. Thank you!

[krishneniyasamy]

Hello thanks for this very useful video, will it be long to receive the code...am still waiting. Thanks

[srilathasrilatha]

I am getting error while click on the button, error is can't run the macro, the macro may not be available in this workbook, or all macros may be disabled, can u plz help on this

[andrewmatthews]

Hi Liked your video but its not quite what I am after.
I have a user form with 12 buttons on it and I trying to attach a diffferent workbook to each button. Have trolled through countless videos but none of them put me on the right track to discover how ii moght achieve this. Andrew

[mohamadsiddeek]

Siddeek from KSA, Please help me in this movement so this will help for many of them. I hope In Excel VBA can do that when ever opening excel application there has to open user form that user form consist Name ID No and login time while finishing work logout time has to enter automatically in a specific folder. further all the details should be hidden only allowed to see supervisor and that folder has to consist a password as well and the sheet has to be veiled I hope you won't distinguish this request Thank and God bless you Siddeek

[rahulmarch]

hi thanks for the awesome tutorial .. can you please share the code it is kind of urgent. thanks in advance

[mohamedelnour]

hi . I have form and am trying to open another workbook but when the workbook opened I can't use it without closing the form . can you support me in this please

[being.ramesh]

Hi How to save and close current workbook and open Access database ? Command button macro please

[markywolfy]

hi, i have signed up and not had the VB code as of yet

[simonastoyanova]

Hello! Thanks for the useful video but can I receive the code on my email because I really need it

[bftshopping]

dear i have an error, when i assign the module code the result is opening the desktop file not the workbook assigned !
why ?

[waiyunwinnko]

Hello Dear, thank you for this video. can you share me that I had already done the signup.

[AbdullahAlMamun-xuef]

Dear Brother, I wait to get your This video code by Mail. it's very argent.