Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 52
Default Windows Exporer Shell

Hello - I need some code that will open a windows exporer window with an FTP
session started. I would like for the FTP folders to be in the explore pane
and the contents of a local folder (I:\) to be in the contents pane.

I have found documentation to shell a windows exporer window - but I'm not
sure I can start an FTP session with shell. Can something be added to this
to start an FTP session?:
Shell "C:\WINDOWS\explorer.exe I:\", vbNormalFocus

I have found documentation on starting an FTP session with wininet and but
not I'm not sure I can open a windows explorer window with wininet.

Is there a way to both at the same time?

--
Thanks,
Mike
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 860
Default Windows Exporer Shell

Hi Mike,

Does this get you closer to what you're looking to do? I'm not sure how you
could extend this to show different content in another pane of Explorer.
You may have to resort to API calls for something like that. If you want to
play around with this, you can set a reference to "Microsoft Shell Controls
and Automation" via Tools | References in the VBE.

Sub gBrowseFTPSite(rsUsername As String, _
rsPassword As String, rsURL As String)
Dim sh As Object

Set sh = CreateObject("Shell.Application")

sh.Explore "ftp://" & rsUsername & ":" & rsPassword & "@" & rsURL

Set sh = Nothing
End Sub

--
Regards,

Jake Marx
www.longhead.com


[please keep replies in the newsgroup - email address unmonitored]


Mike Archer wrote:
Hello - I need some code that will open a windows exporer window with
an FTP session started. I would like for the FTP folders to be in
the explore pane and the contents of a local folder (I:\) to be in
the contents pane.

I have found documentation to shell a windows exporer window - but
I'm not sure I can start an FTP session with shell. Can something be
added to this to start an FTP session?:
Shell "C:\WINDOWS\explorer.exe I:\", vbNormalFocus

I have found documentation on starting an FTP session with wininet
and but not I'm not sure I can open a windows explorer window with
wininet.

Is there a way to both at the same time?



  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 52
Default Windows Exporer Shell

Jake - Thank you! That gets me closer. I will continue to research how to
specify a folder in the contents pane.

--
Thanks Again,
Mike


"Jake Marx" wrote:

Hi Mike,

Does this get you closer to what you're looking to do? I'm not sure how you
could extend this to show different content in another pane of Explorer.
You may have to resort to API calls for something like that. If you want to
play around with this, you can set a reference to "Microsoft Shell Controls
and Automation" via Tools | References in the VBE.

Sub gBrowseFTPSite(rsUsername As String, _
rsPassword As String, rsURL As String)
Dim sh As Object

Set sh = CreateObject("Shell.Application")

sh.Explore "ftp://" & rsUsername & ":" & rsPassword & "@" & rsURL

Set sh = Nothing
End Sub

--
Regards,

Jake Marx
www.longhead.com


[please keep replies in the newsgroup - email address unmonitored]


Mike Archer wrote:
Hello - I need some code that will open a windows exporer window with
an FTP session started. I would like for the FTP folders to be in
the explore pane and the contents of a local folder (I:\) to be in
the contents pane.

I have found documentation to shell a windows exporer window - but
I'm not sure I can start an FTP session with shell. Can something be
added to this to start an FTP session?:
Shell "C:\WINDOWS\explorer.exe I:\", vbNormalFocus

I have found documentation on starting an FTP session with wininet
and but not I'm not sure I can open a windows explorer window with
wininet.

Is there a way to both at the same time?




Reply
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
i want all windows in one excel frame (windows in taskbar) Subramanya Excel Discussion (Misc queries) 1 December 18th 09 03:14 PM
cannot open exel from windows xp in windows vista and visa versa lildiana New Users to Excel 4 February 25th 09 07:26 PM
can windows vista edit shared document from windows xp sasa Excel Worksheet Functions 1 January 9th 08 06:44 PM
Shell command stopped working: is it part of Excel 95 , or Windows? Charles Jordan Excel Programming 9 May 4th 04 06:39 AM
Use Windows Script to run Windows Explorer Search? Ian Elliott[_3_] Excel Programming 0 January 12th 04 05:03 PM


All times are GMT +1. The time now is 05:56 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"