Open files automatically within an excel file

  • Thread starter Thread starter Patrick Barao
  • Start date Start date
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
 
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"
'..
 
Back
Top