Windows 7: How to run an "Elevated" command line?

In my VBA procedure, I need to run the app "Skitch" and use it to open a JPEG file. This is the command I've been using:

Please Login or Register  to view this content.

...where "aPic" is the path and filename.

After some experimenting, I think I need to run the command as if it were in an Elevated Command window (in other words, run it "as Administrator"). How can I do that?

Thanks.

Hi shawnvw,

I think you need 'ShellExecute'. I have run it with .bat files, but I have never tried it with .exe files directly. In Vista (32 bit and 64 bit), UAC asks for permission to run as administrator, after the command is invoked. See my attached file with code to follow, that deletes the print queue. You may be able to adapt the code to your needs.

Lewis

Please Login or Register  to view this content.

I tried this, based on a similar example I found:

Please Login or Register  to view this content.

However, it once again opens Skitch with a "new" image, not the one I specified, which suggests that it's not Elevating.

Is there something missing from my code that would Elevate it?

When the app is running, is there a way to confirm that it's running Elevated?

Thanks again.

The following worked for me:

Please Login or Register  to view this content.

Vista asks me if I want to run this program as Administrator. The only way around the prompt that I know of on Vista is to turn UAC off and reboot the computer.

The following is the Microsoft specs with 'runas' undocumented:
http://msdn.microsoft.com/en-us/libr...=vs.85%29.aspx

See also:
http://ss64.com/vb/shellexecute.html

The ss64 link states:

The runas verb is undocumented but can be used to elevate permissions. When a script is run with elevated permissions several aspects of the user environment may change: The current directory, the current TEMP folder and any mapped drives will be disconnected.

Lewis

When I do that, it asks me for permission to run, so I know it's running Elevated. Thanks.

Unfortuantley, having the picture open still seems to only work part of the time. Sometimes it opens a picture I viewed in a previous session! This means my problem is something else entirely.




Thanks again!