View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Koataus Koataus is offline
external usenet poster
 
Posts: 4
Default Button to open excel file

Thank you for your help! It worked great!
--
Do the one thing you think you cannot do. Fail at it. Try again. Do better
the second time. The only people who never tumble are those who never mount
the high wire. This is your moment. Own it.


"Chip Pearson" wrote:

Create a button, and assign the following macro to it.

Sub OpenFile()
Workbooks.Open filename:="C:\Whatever\book.xls"
End Sub


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"Koataus" wrote in message
...
I'm currious how to create a button in excel with the function
of opening
another specific excel file.

Thanks for any help!

Koataus
--
Do the one thing you think you cannot do. Fail at it. Try
again. Do better
the second time. The only people who never tumble are those who
never mount
the high wire. This is your moment. Own it.