Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 8
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 35,218
Default 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
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
Logging username, date and time Maddoktor Excel Programming 8 July 8th 06 12:27 PM
Network Username Adrian D. Bailey Excel Programming 2 January 20th 06 05:49 PM
Looking for network-username with Excel macro Geert Nauta Excel Programming 1 October 4th 04 04:12 PM
Logging on to network drives automatically. YiFai[_3_] Excel Programming 1 June 28th 04 09:27 PM
Logging on to network drives automatically. YiFai Excel Programming 1 June 28th 04 06:39 PM


All times are GMT +1. The time now is 05:31 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"