| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using Network folders
Try using this Windows API function:
Declare Function SetCurrentDirectoryA Lib "kernel32" (ByVal lpPathName As String) As Long Sub SetDir(PathStr as String) SetCurrentDirectoryA PathStr End Sub Just call SetDir with the path you want: SetDir \\Whatever\... Put the declaration at the top of the module. -- Jim Rech Excel MVP |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| numbering folders | Excel Worksheet Functions | |||
| Passwords for folders? | Excel Discussion (Misc queries) | |||
| Can't see/use folders on home network signed on as administrator | Excel Discussion (Misc queries) | |||
| Excel 2003 won't load files from shared network folders. | Excel Discussion (Misc queries) | |||
| Copying files ...Network to Network | Excel Programming | |||
Linear Mode
