Opening an excel workbook doesnt work
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 |
Opening an excel workbook doesnt work
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 |
Opening an excel workbook doesnt work
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 |
All times are GMT +1. The time now is 10:32 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com