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