Macro to Open another workbook in the same dir!

Posted by Paul on April 19, 2001 10:48 AM

I have tried to use the macro below, but it doesn't work. Can anyone tell me why or another way of doing it?

Sub SOO()
ChDir "..\"
Workbooks.Open Filename:="Section one.xls"
End Sub

Posted by Dax on April 19, 2001 11:10 AM

Hi,
Try this:-

Sub SOO()
Workbooks.Open ThisWorkbook.Path & "\Section One.xls"
End Sub

Dax.

Posted by Paul on April 19, 2001 2:02 PM

Thanks