Opening an excel spreadsheet from Command Button

**cruiser102** · 01-26-2009, 06:36 AM

Good Morning,
I am looking for some assistance, this may be a simple and easy question to answer for some of you guys however i am struggling with this.

I have an excel sheet that has 3 command buttons on it, i am wanting to open a saved excel sheet that i have on my shared drive from the command button. I know the path of the saved file but how do i get the button to open this file?

As well as this i this i also have another command button what i want to open another sheet in the excel document with the command buttons.

Your assistance is greatly appreciated

**Cheeky Charlie** · 01-26-2009, 06:42 AM

Please Login or Register  to view this content.

?

Many things can be deduced by recording a macro and then inspecting the results - try that first, it's normally quicker than posting.

HTH

**cruiser102** · 01-26-2009, 06:52 AM

Thanks, Call me simple but i am still not sure on this.

I have tried to record a Macro and done the following:
-Clicked on the command button,
-Minimized the excel sheet,
-located the file and opened it,
- stopped the macro recording

When i looked at the Code in the edit screen it just said

Application.WindowState = xlMinimized

??

**Cheeky Charlie** · 01-26-2009, 07:13 AM

oh dear! Never mind.

The code is pretty simple, just type 'workbooks.open ' and the arguments should pop up for you to define.

HTH

**cruiser102** · 01-26-2009, 07:27 AM

I think i must be stupid....

I still cant get them to work. I enter the path as this
'Private Sub CommandButton1_Click()
Workbooks.Open (C\DocumentsandSettings\Mark\Desktop\NewTaskingTemplate.xls)As Workbook

End Sub

And it comes up with errors and i cant get it to work.