I have tried to get a workbook to open with the following code,if i take the
Staff Folders section out and use any other combination no problem but using
that particular name Staff Folders in the address path it will not work any
ideas please.



Sub Rectangle1_Click()
Workbooks.Open "C:\Documents and Settings\Tommy\My Documents\Correct
New\Staff Folders\23Ferris T\Holidays.xls"
End Sub

--
BD3

Just a guess, but 'Folders' is a reserved keyword. Perhaps change the folder
name to 'Staff_Folders' or 'StaffFolders' and see if that works.

Mike F
"bigdaddy3" wrote in message
...
I have tried to get a workbook to open with the following code,if i take
the
Staff Folders section out and use any other combination no problem but
using
that particular name Staff Folders in the address path it will not work
any
ideas please.



Sub Rectangle1_Click()
Workbooks.Open "C:\Documents and Settings\Tommy\My Documents\Correct
New\Staff Folders\23Ferris T\Holidays.xls"
End Sub

--
BD3

Thanks for that mike
--
BD3


"Mike Fogleman" wrote:

Just a guess, but 'Folders' is a reserved keyword. Perhaps change the folder
name to 'Staff_Folders' or 'StaffFolders' and see if that works.

Mike F
"bigdaddy3" wrote in message
...
I have tried to get a workbook to open with the following code,if i take
the
Staff Folders section out and use any other combination no problem but
using
that particular name Staff Folders in the address path it will not work
any
ideas please.



Sub Rectangle1_Click()
Workbooks.Open "C:\Documents and Settings\Tommy\My Documents\Correct
New\Staff Folders\23Ferris T\Holidays.xls"
End Sub

--
BD3