Launch .exe file that has associated .set file?

Hi, I am trying to launch Microsoft Dynamics GP (2010) via a macro, and have hit a snag.

Here is the code I am using to launch MS Paint as a test (which works just fine):

Please Login or Register  to view this content.

However, when I create a shortcut to MS Dynamics GP, then look at the properties, here is the filepath:

"C:\Program Files (x86)\Microsoft Dynamics\GP2010\Dynamics.exe Dynamics.set"

I pasted that shortcut in to the FILE_LOCATION cell, and naturally it didn't work.

The ".set" file is a notepad file that has a bunch of programming code of some sort.

Here is what a quick google search says about a .set file (which seems to make sense):

What is a SET file?

Files that contain the .set file extension can be associated with Microsoft's Backup File Set. The SET file contains the set of files that a user wants to back up. When you back up additional files, the new files are also are added to the SET file archive.

The .set file extension is also used by a number of applications to store the user's application configuration settings and preferences. The file is loaded by the application when the program is run on the system. Some of the applications that commonly use the SET file format for this purpose include Diablo II, AutoCad and Corel Painter.

I figured that the Dynamics.set is used in conjunction (AKA 'with') Dynamics.exe, I tried the following code:

Please Login or Register  to view this content.

but I get "Error '424' Object Required"

So then I tried this code:

Please Login or Register  to view this content.

but I get "Compile Error: With object must be user-defined type, object, or variant"

Does anyone have any ideas of how can I get the .exe file to launch, but also utilize this mandatory .set file?

Perhaps you may try:

Please Login or Register  to view this content.

Perhaps you must include the path for the .set file as well?

Originally Posted by Izandol

Perhaps you must include the path for the .set file as well?

That's what I was thinking too, but I'm not quite sure how to go about it.

Please Login or Register  to view this content.

Result:
Run Time Error '53': File Not Found

Please Login or Register  to view this content.

Result:
Compile Error: With object must be user-defined type, object, or variant

Originally Posted by Norie

Is the path for the 'set' file the same as the 'exe' file?

Yes, they are.

Originally Posted by Leith Ross

Hello Rerock,

Add a new VBA Module to workbook and past this code into it. The macro will return the executable program (full path) associated with a file.

Please Login or Register  to view this content.

Hi, thank you for the reply. I created a new module and pasted the code, but it doesn't seem to 'do' anything? I see a private declaration and a function, but no routine to run? Am I missing something?

Perhaps:

Please Login or Register  to view this content.

Hi Leith,
VBA isn't liking that format for Shell. It asks for a "=", which I add, but then it says it's a compile error and wants to replace the "," with a ")"; negating the rest of the statement. Looked promising though.

Originally Posted by Izandol

Perhaps:

Please Login or Register  to view this content.

Ding ding ding; we have a winner folks; thank you!

Thank also to everyone else who provided solutions to try as well!