I have a routine that by clicking one button, that calls a macro, that currently opens Excel, or Word, or WordPerfect. The following macro uses a Case Statement looking at what the extension is, such as for Excel . . . xls
I have added a case statement for a shortcut . . . exe
This 1st macro works perfect
When the Case "exe" is encountered, it calls the below macro that I have copied from my macro that opens excel.Please Login or Register to view this content.
My problem is that I do not know how to change the code in the following macro below the row of XXXXXXXXXXXXXXXXXXXX. I want those lines to open C:\Program Files\McAfee\MSC\mcshell.exe not Excel. With the correct code changes in the lines below the XXXXXXXXXXXX's, it should work.
Please Login or Register to view this content.
Certainly hope one of you out there can assist me. Leith Ross has helped me so much with my difficult coding, l would like to give him a break and hopefully someone else can assist me. Thanks Leith.
Bookmarks