The documentation seems poor here. No matter how i change this property, seems in practice i always get same result. What is the real difference? Thank you very much, have a nice day!
I executed all the options for Opening NotePad, options 1-4 and 6 and each worked as expected and differently.
What exactly are you trying to accomplish?
VBA Code:
' Specifying 1 as the second argument opens the application in
' normal size and gives it the focus.
Dim RetVal
RetVal = Shell("C:\WINDOWS\NOTEPAD.EXE", 1) ' Open Notepad.
I executed all the options for Opening NotePad, options 1-4 and 6 and each worked as expected and differently.
What exactly are you trying to accomplish?
VBA Code:
' Specifying 1 as the second argument opens the application in
' normal size and gives it the focus.
Dim RetVal
RetVal = Shell("C:\WINDOWS\NOTEPAD.EXE", 1) ' Open Notepad.
Thank you. The only thing I don't understand is that what is the difference between vbMinimizedFocus and vbMinimizedNoFocus? Max and min refers to size of the window, but what is the meaning of focus? They seem to do the same thing, hence it confuses me about the meaning of focus. Thank you very much for your answer.
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.