Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-04-2013, 07:07 AM
AndyDDUK AndyDDUK is offline Open/close window in Outlook Windows 7 64bit Open/close window in Outlook Office 2010 64bit
Advanced Beginner
Open/close window in Outlook
 
Join Date: Oct 2012
Posts: 32
AndyDDUK is on a distinguished road
Default Open/close window in Outlook

Hi
Help....I'm using the below and it works great, however if you run it again, it opens the window again...(and again, and again etc...)




Sub sub_OpenFolder()
Dim str_folder As String
str_folder = "C:\Test" ' folder to open
Call Shell("explorer.exe " & str_folder, vbNormalFocus)
End Sub


Can you modify it for me so it

1) doesnt reopen if it is open already

2) activates the folder window

3) opens it not as maximised

Many thanks for your help
cheers
Andy
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Open/close window in Outlook Close 'downloads' window with VBA CatMan Excel Programming 6 12-14-2012 01:34 PM
Open/close window in Outlook Word 2003 slow to open/close HAWJOHN Word 1 04-05-2011 06:47 AM
There are too many find public folders dialogs open. You must close them in order to asiatic Outlook 1 01-08-2011 10:56 AM
Lines move between close and open jsmath22 PowerPoint 0 12-15-2010 07:44 AM
Open/close window in Outlook Cannot open two separate MS word window bunny_biceps Word 2 08-17-2010 01:51 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:16 PM.


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