Using Shellexecute to start a program - Excel Help & Excel Macro Help
SEARCH ENTIRE SITE LOADING..

Excel Help & Excel Best Practices Forums

 

Proudly Affiliated With: Intelligent Converters & AnalyserXL <Affiliate Program & ExcelUser Affiliate>

 

SPECIALS PAGE FOR BARGAINS | FREE EXCEL TRAINING | FREE CUSTOM FUNCTIONS ADD-IN


Go Back Excel Help & Excel Macro Help > HELP FORUMS > EXCEL HELP
HOME Register Forum Help Calendar Search For Today's Posts Mark Forums Read

Reply

Using Shellexecute to start a program

ANSWERS TO SIMILAR QUESTIONS
Display Bar Where Start & Length Determined Start & End DatesOpen Workbook With ShellExecute



Javascript DHTML Drop Down Menu Powered by dhtml-menu-builder.com

Create Excel dashboards quickly with Plug-N-Play reports.


 
Thread Tools Search this Thread
Old 2 Weeks Ago
Intelligent Converters
FREE DOWNLOADS
File/Password Recovery
mtheriault mtheriault is offline
I agreed to these rules
 
I'm a Spammer: NO
MS Office Version: 2007 Non-English
Op System: Other
Assumed Experience: Average (know many formulas)
Join Date: 4th November 2009
English is 1st Language: No
Posts: 2 -- Threads: 0
Using Shellexecute to start a program

Hello

How can i use ShellExecute command to start an application. Since the application as to be run in administrator mode, i suppose that i need to pass a Vbyes parameter to the comnmand line. When started manualy, Windows open a secutity box and ask if i approved it.

The application is use for a text capture process
name is: Hypersnap6.exe
Directory: "c:\Program Files (x86)\Hypersnap 6\"

I did use before the shell() command, but it doesn't work anymore when the targeted application is under administrator mode

Any help appreciated

Martin
Montreal, Canada
__________________
ADS BY OZGRID. FREE DOWNLOADS SmartVBA | SmartVB6 | CodeVBA | CodeVB6 | Code Generator Pro | TraderXL Pro Package. MORE..
Print [Post / Thread] Reply With Quote
Old 2 Weeks Ago
Wigi's Avatar
Wigi Wigi is offline
OzMVP
 
I'm a Spammer: NO
MS Office Version: 2003 English
Op System: Windows XP
Assumed Experience: Expert (I wont be needing help)
Join Date: 15th August 2005
English is 1st Language: No
Location: Lier, Belgium
Posts: 3,386 -- Threads: 46
Re: Using Shellexecute to start a program

Please do not crosspost:

http://www.mrexcel.com/forum/showthread.php?t=426920
__________________
http://www.wimgielis.be. Excel (VBA code + example files), sports and music.
Print [Post / Thread] Reply With Quote
Old 2 Weeks Ago
norie's Avatar
norie norie is offline
OzMVP
 
I'm a Spammer: NO
MS Office Version: 2000 English
Op System: Windows Vista
Assumed Experience: Expert (I wont be needing help)
Join Date: 14th July 2004
English is 1st Language: Yes
Posts: 9,763 -- Threads: 21
Re: Using Shellexecute to start a program

I've re-opened this thread.

If anybody is familiar with MrExcel then they will realise that they are having a lot of problems over there at the moment.

I think this might be the reason that Martin has cross-posted.
__________________
Boo!
Print [Post / Thread] Reply With Quote
Old 2 Weeks Ago
Intelligent Converters
FREE DOWNLOADS
File/Password Recovery
mtheriault mtheriault is offline
I agreed to these rules
 
I'm a Spammer: NO
MS Office Version: 2007 Non-English
Op System: Other
Assumed Experience: Average (know many formulas)
Join Date: 4th November 2009
English is 1st Language: No
Posts: 2 -- Threads: 0
Re: Using Shellexecute to start a program

Solutioned....

Thank you Norie, your a great man. Sol

Yes i had problem with MrExcel site yesterday, i taught it was another problem that i had. I was in hurry to solution that one. First time that i post on multiple forum. I had to be up and running fast. Did learn my lesson.

I did found the solution witch consist to give Excel an administrator right also.

1- Right click on Excel icon, select compatibility, Priviledge level, execute as an administrator
2- close and re-open Excel
3- From the opened Excel page, load the worksheet
4- Since my Excel worksheet was starting two others .exe application, i did give them also the administrator right in their property.

et voila

I did found that Starting directly my worksheet with is icone ( next to Excel in start menu), won't work as my worksheet will not get is administrator right

Martin
__________________
ADS BY OZGRID. FREE DOWNLOADS SmartVBA | SmartVB6 | CodeVBA | CodeVB6 | Code Generator Pro | TraderXL Pro Package. MORE..
Print [Post / Thread] Reply With Quote
Old 2 Weeks Ago
norie's Avatar
norie norie is offline
OzMVP
 
I'm a Spammer: NO
MS Office Version: 2000 English
Op System: Windows Vista
Assumed Experience: Expert (I wont be needing help)
Join Date: 14th July 2004
English is 1st Language: Yes
Posts: 9,763 -- Threads: 21
Re: Using Shellexecute to start a program

Martin

No problem.

If you do cross-post then if you provide a link to the other forum then most people don't mind.

Oh, and thanks for posting the solution - one thing I don't like is when people just reply saying they've solved their problem without further details.
__________________
Boo!
Print [Post / Thread] Reply With Quote
Reply Lifetime Upgrade To Ad Free Styles

   « PREVIOUS Allow User To Automatically Add Data To Data Validation List || Sort Set Range Across Multiple Worksheets NEXT »
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump


All times are GMT +9. The time now is 22:43.


Powered by vBulletin Version 3.5.4
Copyright ©2000 - 2009, Jelsoft Enterprises Ltd.
Ozgrid is Not Associated With Microsoft. Ozgrid Retains the Rights to ALL Posts and Threads