is there a way to open a file in macro where the user
selects the file...like opens the "open file dialogue box"

something like
Sub Macro1()

Workbooks.Open Filename:= _
"C:\Documents and Settings\test.xls _
UpdateLinks:=0
End Sub

but the file name can be chosen by the use?
thanks

As in:

myFile = Application.GetOpenFilename("Excel Files,*.xls")

See OLH for GetOpenFilename Method


--
HTH
Roger
Shaftesbury (UK)


"doug" wrote in message
...
is there a way to open a file in macro where the user
selects the file...like opens the "open file dialogue box"

something like
Sub Macro1()

Workbooks.Open Filename:= _
"C:\Documents and Settings\test.xls _
UpdateLinks:=0
End Sub

but the file name can be chosen by the use?
thanks

Note that this doesn't open the file, it just returns the full path and name
of the selected file. The file has to be separately opened.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Roger Whitehead" wrote in message
...
As in:

myFile = Application.GetOpenFilename("Excel Files,*.xls")

See OLH for GetOpenFilename Method


--
HTH
Roger
Shaftesbury (UK)


"doug" wrote in message
...
is there a way to open a file in macro where the user
selects the file...like opens the "open file dialogue box"

something like
Sub Macro1()

Workbooks.Open Filename:= _
"C:\Documents and Settings\test.xls _
UpdateLinks:=0
End Sub

but the file name can be chosen by the use?
thanks

Thats right Bob, my apologies Doug - moe complete code would be:

myFile = Application.GetOpenFilename("Excel Files,*.xls")
workbooks.open myfile
'or
workbooks.open Filename:=myfile

Check out OLH for full syntax

Roger

"Bob Phillips" wrote in message
...
Note that this doesn't open the file, it just returns the full path and
name
of the selected file. The file has to be separately opened.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Roger Whitehead" wrote in message
...
As in:

myFile = Application.GetOpenFilename("Excel Files,*.xls")

See OLH for GetOpenFilename Method


--
HTH
Roger
Shaftesbury (UK)


"doug" wrote in message
...
is there a way to open a file in macro where the user
selects the file...like opens the "open file dialogue box"

something like
Sub Macro1()

Workbooks.Open Filename:= _
"C:\Documents and Settings\test.xls _
UpdateLinks:=0
End Sub

but the file name can be chosen by the use?
thanks