Workbooks.Open Filename:="R:\xxx\yyy.xls"

Hope it helps,
Ozgur
"anar_baku" wrote:

>
> Hi,
>
> This should be very simple, but it doesn't work for some reason! I'm
> trying to open a file name when the user clicks on a command button and
> here is the code I'm using:
>
> Private Sub CommandButton1_Click()
> Documents.Open ("C:\Test.doc")
> End Sub
>
> I've also tried using Application.GetOpenFilename, but still no joy.
>
> Please help.
>
> Many thanks,
>
> Anar
>
>
> --
> anar_baku
> ------------------------------------------------------------------------
> anar_baku's Profile: http://www.excelforum.com/member.php...o&userid=18259
> View this thread: http://www.excelforum.com/showthread...hreadid=540260
>
>