Solved

Better Shell Function

Posted on 1998-10-29
4
131 Views
Last Modified: 2010-04-30
I need to be able to shell and application, file shortcut etc. from my application. The RUN command on the START menu can do this, so I figure there must be a suitable API call. I have found lots of them, but they all do slightly different things. I need to be able to shell a file as if I had just double clicked on it. Can someone show me some code to do this???
0
Comment
Question by:bubbles
  • 2
  • 2
4 Comments
 
LVL 2

Expert Comment

by:chrisbolt
ID: 1442477
0
 

Author Comment

by:bubbles
ID: 1442478
This is a good answer, but there are a couple of problems. I had actually already written code to do this. Anyway, this code cannot shell .lnk files (shortcuts). The other problem is that I need to be able to open a file using it's default action. E.g., if I make the filename a .wav file, I will want the function to Play it, not Open it, but I don't want my program to have to work out which action to perform. Maybe there is a constant to do this. I basically want something that will behave in the same way as the Run command on the Start menu.
0
 
LVL 2

Accepted Solution

by:
chrisbolt earned 120 total points
ID: 1442479
Option Explicit

Put this in the General: Declarations section of your main module:

Private Declare Function GetDesktopWindow Lib "user32" () As Long
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

Private Const SW_SHOWNORMAL As Long = 1
Private Const SW_SHOWMAXIMIZED As Long = 3
Private Const SW_SHOWDEFAULT As Long = 10

Then put this in the subroutine where you want to open a file with the default associated program using the default action, and working on .lnk files:

Dim RetVal As Long, hWndDesk As Long
hWndDesk = GetDesktopWindow()
RetVal = ShellExecute(hWndDesk, vbNullString, "C:\WHATEVER.TXT", vbNullString, "C:\", SW_SHOWNORMAL)

Obviously, replace C:\WHATEVER.TXT with the filename of the file you want to open/play/whatever.
0
 

Author Comment

by:bubbles
ID: 1442480
Sorry, but I actually got your previous answer to work. I had to play around with a few things. Anyway, sorry that I rejected your answer. Also, I have an identical question posted (something went wrong when I submited it) so if you answer that as well, you can have both lots of points. The question number is Q.10093842
0

Featured Post

What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

Join & Write a Comment

Suggested Solutions

The debugging module of the VB 6 IDE can be accessed by way of the Debug menu item. That menu item can normally be found in the IDE's main menu line as shown in this picture.   There is also a companion Debug Toolbar that looks like the followin…
Enums (shorthand for ‘enumerations’) are not often used by programmers but they can be quite valuable when they are.  What are they? An Enum is just a type of variable like a string or an Integer, but in this case one that you create that contains…
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
Get people started with the process of using Access VBA to control Outlook using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Microsoft Outlook. Using automation, an Access applic…

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

23 Experts available now in Live!

Get 1:1 Help Now