Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 12-11-2012, 09:34 AM
CatMan CatMan is offline Close 'downloads' window with VBA Windows 7 32bit Close 'downloads' window with VBA Office 2010 32bit
Intermediate
Close 'downloads' window with VBA
 
Join Date: Apr 2012
Posts: 39
CatMan is on a distinguished road
Default Close 'downloads' window with VBA

Hi forum, thanks to all for taking the time to read this.

I need to closed the File Explorer (FE) 'downloads' window and an Internet Explorer (IE) window using VBA. I am using windows 7. The downloads folder is generally located here: "C:\Users\User\Downloads". I can open it like this, but how do you close it? I also need to close an IE window. Both the FE an IE windows open as a result a process that is VBA launched using ShellExicute, which does not support any hand shaking between the VBA process and the ShellExicute process because ShellExicute does not support variable passing, unless someone knows better. Closing all FE windows would suffice but hopefully there is a way to close the downloads folder FE.



Code to open downloads folder:
Code:
 
Shell "explorer C:\Users\User\Downloads"

Last edited by CatMan; 12-12-2012 at 10:20 AM.
Reply With Quote
 

Tags
close window, downloads



Similar Threads
Thread Thread Starter Forum Replies Last Post
How to find the path to the downloads folder when it is different for each user CatMan Excel Programming 2 12-07-2012 09:59 PM
Outlook continues to run after I close it Shawn76 Outlook 1 08-23-2010 12:30 AM
Outlook 2007 downloads all emails everytime i send/receive helpmeplease Outlook 0 12-28-2008 12:22 PM
Is there an exit on close ? mhdadmh Word 0 10-12-2006 04:28 PM
Close 'downloads' window with VBA Mass attachment downloads? dpool2002 Outlook 1 06-21-2006 02:11 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:31 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft