Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #2  
Old 01-17-2014, 11:06 AM
BobBridges's Avatar
BobBridges BobBridges is offline Open Folder in Excel 2010 VBA Windows 7 64bit Open Folder in Excel 2010 VBA Office 2010 32bit
Expert
 
Join Date: May 2013
Location: USA
Posts: 700
BobBridges has a spectacular aura aboutBobBridges has a spectacular aura about
Default

There's a standard dialogue you can use in VBA and VBS. Let's see, I know I've used it in a few programs ... Yes, here it is. There are other ways, but in Excel itself the Application object has a GetOpenFilename method that you can use to present the standard open-file dialogue to the user; your program can set the starting folder, the filter that determines which file extensions will be displayed, all that sort of thing, and when the user has found the right file and clicks on it to indicate "Yes, this is the file I want" the method returns the name of the file back to the program, without opening it. That way the program can do to the file whatever you choose.
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Office 2010 Can't Open Or Save Documents in My Documents Folder trippb Office 1 07-12-2013 07:29 AM
Cannot open folder in Outlook marketshare Outlook 0 03-17-2013 04:07 PM
Open Folder in Excel 2010 VBA Set a task folder to open as default ghumdinger Outlook 1 07-03-2011 05:34 AM
Open Folder in Excel 2010 VBA Outlook slow to open folder rtankersley Outlook 1 09-16-2008 05:42 AM
OPEN FOLDER starts a search Gwyn Word 0 02-22-2006 06:38 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:46 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