Opening a workbook from another workbook using VBA

**J_barber** · 04-29-2013, 10:31 AM

Is there a way to open an excel workbook via a button located in another workbook? I want to be able to open a workbook that has a list of standard notes that I can copy and paste in the workbook I am currently working on. I would like to just click a button and have the file open up. Any help would be greatly appreciated.

JB

**NeedForExcel** · 04-29-2013, 10:59 AM

Yes.. You Can easily do it.. Just give me the path and file name of the Workbook that needs to be opened..

**arlu1201** · 04-29-2013, 11:01 AM

Sure this can be done. Input the below code into your VBE editor and attach it to a button. Change the path as per your system.

Please Login or Register  to view this content.

**NeedForExcel** · 04-29-2013, 11:04 AM

Please put the Code in a Module

Please Login or Register  to view this content.

**J_barber** · 04-29-2013, 11:41 AM

Originally Posted by msexcelathome

Yes.. You Can easily do it.. Just give me the path and file name of the Workbook that needs to be opened..

Works great!

Thanks!

**arlu1201** · 04-29-2013, 11:58 AM

Based on your last post in this thread, its apparent that you are satisfied with the solution(s) you've received and have solved your question, but you haven't marked your thread as "SOLVED". I will do it for you this time.

In future, to mark your thread as Solved, you can do the following -
Select Thread Tools-> Mark thread as Solved.

Incase your issue is not solved, you can undo it as follows -
Select Thread Tools-> Mark thread as Unsolved.

Also, since you are relatively new to the forum, i would like to inform you that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post which helped you. This adds to the reputation of the person who has taken the time to help you.

**csrwpb** · 05-06-2013, 04:51 PM

Instead of listing the file to open in a sub, is it possible to enter the filename in a userform? I'm asking because I have a template that will consistenly have a different file name when sent to me. I'd like to simply enter the file into a text field and click ok to open. After the workbook is open I have a sub written to copy the necessary data.

Thanks,

Connor

**arlu1201** · 05-07-2013, 02:41 AM

Connor,

Unfortunately you need to post your question in a new thread, it's against the forum rules to post a question in the thread of another user. If you create your own thread, any advice will be tailored to your situation so you should include a description of what you've done and are trying to do. Also, if you feel that this thread is particularly relevant to what you are trying to do, you can surely include a link to it in your new thread.