Open Explorer in Full screen with Shell

[Eikenhorst]

Hello,

I have used the following VBA script in Access to open a certain map in the Explorer:

Shell "C:\WINNT\Explorer.exe C:\My Documents \" & Me.Combonumber & "\"

This opens the map with the name of the number in the Combobox. The problem is now that after it opens the Explorer window isn’t maximized and it doesn’t get the focus. How do I get that to happen too? Thanks for any help!

 

[Bodisathva]

I believe the proper argument for the shell command is vbMaximizedFocus, but you'll get the options if you type a comma after your commandline.

after opening, you could also use SendKeys to pass the "F11" full-screen command as well