Command Button To Open Workbooks

I have command Buttons in my excel workbook that when clicked goto another sheet and cell.

I would like to use a command button to open another specified named workbook to enter data into. Is this possible?

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Collapse -

Yes, it is possible....

by ThumbsUp2 In reply to Command Button To Open Wo ...

First, start with a blank workbook. You will need to create a Macro which opens a message box so you can type the file name and maybe even the path to the file if it's not in My Documents which is the default but maybe the workbook you want to open is in a folder inside of My Documents. Then, you create a button which points to the macro and executes it when pushed.

Once that is done, you save the workbook as Personal.xls into a special folder, the location of which is different depending on which version of Excel you're running.

Folders that Excel uses at startup

If you install Excel in the default location, Excel opens files from the following paths (pick the one which applies to you):

* In Microsoft Office Excel 2003, the path is C:\Program Files\Microsoft Office\Office11\Xlstart

In Microsoft Office Excel 2007, the path is C:\Program Files\Microsoft Office\Office12\Xlstart

(the above two locations would apply to all users of the computer - below is just for you)

* C:\Documents and Settings\User_name\Application Data\Microsoft\Excel\XLSTART

In this path, User_name is your logon user name.

* The folder that is specified in the At startup, open all files in box


To find the At startup, open all files in box in Excel 2003, click Options on the Tools menu, and then click the General tab.

To find the At startup, open all files in box in Excel 2007, click the Microsoft Office Button, click Excel Options, and then click Advanced. The At startup, open all files in box is under General.

Hope this helps.

Collapse -

Command Button to Open Workbooks

Thankyou for your quick response however, I have never created a macro and do not know a code for the Command Button to make it work.
Therefore may I ask you, would you be kind enough to provide the code used for the command button to open up a workbook while I find out how to create a macro....Please

Collapse -

There is no better time to start learning than right now...

by ThumbsUp2 In reply to Command Button to Open Wo ...

If you have Excel 2003, click Tools, then hover over Macro, then click Macros, type a name for your new macro then click create. Once the VBScript editor has opened, click HELP and begin your introduction to a whole new world.

If you have Excel 2007, the instructions are similar, but you'll have to wade through the menu structure to see where MS hid the macros.

Sorry, no. We won't do it for you. There are people here who make their living off of doing this kind of stuff. If you want to begin learning though, we'll help with specific questions as you learn. Just dive in and get your feet wet. You won't/can't learn unless you try.

Collapse -

RE: Command Buttons to Open Workbook

My feet are drip wet of all this learning and the best way to learn is to ask the question; "How do you do that?" so I just want to say:
Thankyou very much for all your help as I learnt something again.

Related Discussions

Related Forums