Excel 2007 : Can link workbook 1 to another workbook?

[st3vi3]

Hi all

I'm trying to link from workbook to another workbook using Button (Form Control). For example, I have main.xls (workbook 1). In the workbook 1, I have Button (Form Control) want to click to show/activate another worksheet for example to show/activate personal.xls (workbook 2). How to do that? Can excel link like that?

Thank you.

Regard
st3vi3

[gjlindn]

It can...maybe not exactly with a form control button itself, but with a little VBA coding sure. That's not really a link in the sense that we use the term in Excel; its more like a command or event.

[st3vi3]

The code or command can be like this or not?
"Workbooks.Open Filename:=..\personal.xls"

I try use this code but got error.

[st3vi3]

Already fix that! Thanks guys! [SOLVED]

[vlady]

hello..
maybe

Windows("personal.xls").Activate