Open files automatically within an excel file

P

Patrick Barao

I am trying to add a button on a excel file where it will allow me to open
another excel file. Can this be done with templates or by using formulas?

Patrick
 
F

Frank Kabel

Hi
can be done with using VBA. So you can add a button to
your worksheet (e.g. use the toolbox toolbar to add a
copmmand button) and add some code to this button.
e.g. something like

'...
workbooks.open "C:\temp\otherbook.xls"
'..
 
Top