PDA

View Full Version : workbook full path



lior03
12-05-2006, 02:17 AM
hello
i want to attach a macro to a button for a workbook that has all my macros in it. i want it to open the workbook.



Workbooks.Open [C:\Documents and Settings\user1\My Documents\excelove.xls]


what is wrong?
thanks

moa
12-05-2006, 02:27 AM
Workbooks.Open("C:\Documents And Settings\user1\My Documents\excelove.xls")

should work.

Bob Phillips
12-05-2006, 04:08 AM
Workbooks.Open Filename:="C:\Documents And Settings\user1\My Documents\excelove.xls"

moa
12-05-2006, 04:28 AM
What's the difference?