Automatically select specific file from dialog Box

[gmmdinesh]

Hi
I'm trying to open one of the tool of 3rd party application through VBA.
When i trying open a dialog box is appeared to select that tool.

but I don't want to open this dialog box.
Any one know how to select the tool directly (without opening dialog box)

is that possible to do this?


Thanks in Advance

[westconn1]

is that possible to do this?

it depends what you want to do with the selected file

what code do you have that opens the dialog and after close?

[gmmdinesh]

Just i have a command button and assign a hyperlink for that file, but when i click the command button it is appeared a dialog box only.
again i need to select the file in that dialog box as manually then only it will open.

what i need , when i click the command button the application should be open automatically(dialog box should not be appeared)

Thanks

[westconn1]

what is the href for the hyperlink?

what is the name of the file you need to select?

[gmmdinesh]

i'm not using vba, just i have create a Shape and assign Hyperlink for that file.
The name of the file is CRIS_AB.zmd, its one of the application tool.

[westconn1]

as i do not have enough information, the only thing i can suggest is to use the shellexecute API, with the OPEN parameter, assuming that the .zmd files are associated to some application

search in this forum (or vb6 forum) for shellexcute, for declaration and usage

[gmmdinesh]

Hi westconn
Thanks for your suggetion. But i don't have any idea about shellexcute.
I want to open that application through Excel only.
shellexcute is Vba or what?

[westconn1]

shellexcute is Vba or what?

a windows API that can be called from VBA

[gmmdinesh]

Thank you so much for your info..

[westconn1]

a quick search brought me to http://www.vbforums.com/showthread.p...ecute-in-Excel and thousands of other



declaration

Private Const SW_SHOWNORMAL = 1

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

call like

vRetVal = ShellExecute(0, "Open", "fullpath\CRIS_AB.zmd", vbNullString, vbNullString, SW_SHOWNORMAL)

i can not in anyway say this will actually do what you want, but without a lot more information, it is probably your only option

you can look in windows to see if zmd files are associated with any application
if you can double click a .zmd file in windows explorer to open it, shellexecute should work

[gmmdinesh]

Thanks Westconn
I have tried the code which is getting from the link you given... it was working but again it's showing the dialog box only. again i need to select the file manually.

Thanks

[westconn1]

here is another you can try, i have no real idea if it might work
for more information see https://www3.rocketsoftware.com/blue...ne_Support.htm

shell BZMD.EXE /FCRIS_AB.ZMD

you may need to supply full path to both the exe and the config file, if the path to either may contain spaces, it will have to be enclose in quotes AND the quotes will have to be escaped