LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #6   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 30
Default Open Foldr Macro..?

Hail the Messiah...
Shell "Explorer /e,MyDocuments", vbNormalFocus

That's the one.. Shell.

Silly me, for the life of me could not remember.
I'll sleep tonight.
Thx Kenneth.

"Kenneth Hobson" wrote in message
...
| To explore or just select and return selection? If the first, one
these
| methods will work.
|
| Sub OpenExplorer()
| Dim x As Variant
| Dim sPath As String
|
| 'sPath = """E:\MyDirectory\Williams,Bob 7264\"""
| sPath = Application.path
| x = Shell("explorer /n,/e," & sPath, 1)
| End Sub
|
| Sub t()
| Dim sPath As String
| sPath = """E:\MyDirectory\Williams,Bob 7264\"""
| IExplorerOpen sPath
| End Sub
|
| Private Sub IExplorerOpen(sPath As String)
| 'early binding. Requires reference to Microsoft Internet Controls
| (shdocvw.dll).
| Dim ieo As SHDocVw.InternetExplorer
| Set ieo = New SHDocVw.InternetExplorer
| ieo.FullScreen = True
| ieo.Navigate sPath
| ieo.Visible = True
| Exit Sub
|
| 'late binding
| Dim IE As Object
| Set IE = CreateObject("internetexplorer.application")
| IE.Navigate sPath
| IE.Visible = True
| Exit Sub
| End Sub
|


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Open Excel file from VB and open MACRO no1jimmyman Excel Discussion (Misc queries) 0 February 14th 11 10:10 PM
Macro runs upon wkbk open, but no Workbook_Open or Auto_Open Macro Ron Coderre Excel Programming 2 September 26th 06 05:50 PM
Open workbook macro- find correct month to open? buzzharley[_10_] Excel Programming 8 July 8th 06 04:30 AM
open up an excel program with an auto open macro [email protected] Excel Programming 2 July 17th 05 04:48 PM
How do I get my personal macro worksheet to open whenever I open . Claudia_R Excel Discussion (Misc queries) 3 December 9th 04 11:59 PM


All times are GMT +1. The time now is 05:24 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"