Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Logging to a network folder with username/password
Hi group
I want to check a remote network folder using "dir" If dir(REMOTE_HOME, vbDirectory) = "" Then MkDir (REMOTE_HOME) End If after this I want to place a file in the folder... I works if I have mapped up the server in explorer. If I don't have the mapped drive dir(REMOTE_HOME,vbDirectory) fails with error 52 "Bad file name..." How do I temporary connect to the server and placing the file in the folder? Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Logging to a network folder with username/password
Why not just use the UNC path instead of the mapped drive?
Teddy wrote: Hi group I want to check a remote network folder using "dir" If dir(REMOTE_HOME, vbDirectory) = "" Then MkDir (REMOTE_HOME) End If after this I want to place a file in the folder... I works if I have mapped up the server in explorer. If I don't have the mapped drive dir(REMOTE_HOME,vbDirectory) fails with error 52 "Bad file name..." How do I temporary connect to the server and placing the file in the folder? Thanks -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Logging username, date and time | Excel Programming | |||
Network Username | Excel Programming | |||
Looking for network-username with Excel macro | Excel Programming | |||
Logging on to network drives automatically. | Excel Programming | |||
Logging on to network drives automatically. | Excel Programming |