Open a document using VBA

[anar_baku]

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

[Ozgur Pars]

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
>
>

[anar_baku]

This works fine for files that can open in Excel, but not for those that can't. I'm trying to open .doc/.pdf files. Any alternatives?

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
>
>

[anar_baku]

In case anyone needs it, I've now found a simple way:
ActiveWorkbook.FollowHyperlink Address:="C:\File.xxx", NewWindow:=True

[Ozgur Pars]

For word documents you can use:
Documents.Open FileName:="c:\xxx.doc"

or alternatively:

Sub AAA()
Dim App As Application
Dim W As Document

Set App = Word.Application
Set W = app.Documents.Open("c:\xxx.doc")
End Sub

Just call AAA in your code...



"anar_baku" wrote:

>
> This works fine for files that can open in Excel, but not for those that
> can't. I'm trying to open .doc/.pdf files. Any alternatives?
>
> Ozgur Pars Wrote:
> > 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
> > >
> > >
>
>
> --
> 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
>
>