velohead66

Any one know the command to open a specific file in a specific location.

Idealy looking to put the file name in a certain excel cell, and then a macro opens the specified file, then does certain operations.

The crux is getting the macro to open any file !!

Ta.

[edited to make more sense]

[Edited by velohead66 - 11/5/2002 8:16:01 AM]

Fosters

you mean open the file with the windows associated application?

Private Declare Function ShellExecute Lib "shell32.dll" Alias "ShellExecuteA" (ByVal hwnd As Long, ByVal lpOperation As String, ByVal lpFile As String, ByVal lpParameters As String, ByVal lpDirectory As String, ByVal nShowCmd As Long) As Long

ShellExecute0, vbNullString, "C:\test.doc", vbNullString, vbNullString, vbNormalFocus
or
ShellExecute0, vbNullString, "http://www.website.com", vbNullString, vbNullString, vbNormalFocus

velohead66

em, seems a bit complicated, and it doesnt seem to work.
Error message is "sub or function not defined".
"ShellExecute0" is highlighted in blue.

Presume this is "VB for excel" rather then "VBA" ??

Thought the statement might be more simple,
and of the order of "filename.xls.openfile"
or similiar ??

velohead66

...anyone ??????

dsmith

Well from a simple "Macro Record" and look at the code I think you want

Workbooks.Open Filename:= "FileNameHere"

So stick the filename in "A1" and use

Workbooks.Open Filename:=Range("A1").Value

Deano

beemerboy

exactimundo deano....

Sub Macro1()
'
' Macro1 Macro
' Macro recorded 05/11/2002 by daren williams
'

'
Workbooks.Open Filename:= _
"C:\Documents and Settings\daren\My Documents\Clients.xls"
End Sub

velohead66

Ta.

Forgot rule number one, record it if poss.

Good rule to learn I guess.
Effective, and Simple Too.

Thanks Again.