Open a specific file in excel

[Drenda]

Can anyone help

I would like to open a specific excel file after click on a command button from a form

Is ther any code / macro that can do this

thanks

 

[kzutter]

Shell Function

Runs an executable program and returns a Variant (Double) representing the program's task ID if successful, otherwise it returns zero.

Syntax

Shell(pathname[,windowstyle])

The Shell function syntax has these named arguments:

Part Description
pathname Required; Variant (String). Name of the program to execute and any required arguments or command-line switches; may include directory or folder and drive.
windowstyle Optional. Variant (Integer) corresponding to the style of the window in which the program is to be run. If windowstyle is omitted, the program is started minimized with focus.

 

[PHV]

You may also consider the Application.FollowHyperlink method.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[Drenda]

Many thanks

 

[Remou]

Drenda
It is good to use the link
"Thank ... for this valuable post!"
to thank people in Tek-Tips.