Thread: Browser window
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Ron de Bruin Ron de Bruin is offline
external usenet poster
 
Posts: 11,123
Default Browser window

See Example 6 on this page
http://www.rondebruin.nl/copy3.htm#select

--
Regards Ron de Bruin
http://www.rondebruin.nl


"Ron de Bruin" wrote in message ...
Hi tcbootneck

You can use this

Private Declare Function SetCurrentDirectoryA Lib _
"kernel32" (ByVal lpPathName As String) As Long

Public Sub ChDirNet(szPath As String)
' Rob Bovey
Dim lReturn As Long
lReturn = SetCurrentDirectoryA(szPath)
If lReturn = 0 Then Err.Raise vbObjectError + 1, "Error setting path."
End Sub

See how I use it here
http://www.rondebruin.nl/copy3.htm#select


--
Regards Ron de Bruin
http://www.rondebruin.nl


"tcbootneck" wrote in message ...
I want to be able to force a browser window to look in a particular polder,
whenever I wish to import data.

I have tried ChDir and path commands, but am a bit stuck.

Can anybody please help?