| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
open browser window at my given location
through vba only... When I click browser button on my userform it opens the default folde of "my documents" to open any excel file I need to open the default folder to be = "C:\my project\new" to ope file from there.. -- ilyaskaz ----------------------------------------------------------------------- ilyaskazi's Profile: http://www.excelforum.com/member.php...fo&userid=2396 View this thread: http://www.excelforum.com/showthread.php?threadid=37591 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
open browser window at my given location
Sub Open_Folder()
Dim MyPath As String Dim SaveDriveDir As String Dim FName As Variant SaveDriveDir = CurDir MyPath = "C:\my project\new" ChDrive MyPath ChDir MyPath FName = Application.GetOpenFilename(filefilter:="Excel Files (*.xls), *.xls", _ MultiSelect:=False) 'Do whatever you need to do with file.... ChDrive SaveDriveDir ChDir SaveDriveDir End Sub This should get you started, Mike F "ilyaskazi" wrote in message ... through vba only... When I click browser button on my userform it opens the default folder of "my documents" to open any excel file I need to open the default folder to be = "C:\my project\new" to open file from there... -- ilyaskazi ------------------------------------------------------------------------ ilyaskazi's Profile: http://www.excelforum.com/member.php...o&userid=23969 View this thread: http://www.excelforum.com/showthread...hreadid=375911 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
open browser window at my given location
thanku Mike, it is working perfect. I was stuck with this problem for last 3 days t get solved on so many forum's website. finally on this forum, today only I hv registered and happy to see it solution so quickly. thankyou once again. Regards, ilyaskaz -- ilyaskaz ----------------------------------------------------------------------- ilyaskazi's Profile: http://www.excelforum.com/member.php...fo&userid=2396 View this thread: http://www.excelforum.com/showthread.php?threadid=37591 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
open browser window at my given location
is it possible??? or my question is not cleared???? -- ilyaskaz ----------------------------------------------------------------------- ilyaskazi's Profile: http://www.excelforum.com/member.php...fo&userid=2396 View this thread: http://www.excelforum.com/showthread.php?threadid=37591 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Workbooks opening in browser window | Excel Discussion (Misc queries) | |||
| file browser window | Excel Discussion (Misc queries) | |||
| Open all various hyperlinks in SAME browser window? | Links and Linking in Excel | |||
| Opening browser window | Excel Programming | |||
| Close Browser window with VBA | Excel Programming | |||
Hybrid Mode
