Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Sri
 
Posts: n/a
Default Connecting to a network drive using VBA

Hi,

I would like to call a excel file which is actually stored in a network.
There are two networks which i want to connect, one is controlled by user
account and the other is a open one.

Can anyone please help me to write a code which will either connect to the
network drive by getting the username/password or by anyother way of directly
calling the network folder probably using FileSystemObject library.

Its ok even if it has to connect a drive to the network path. But would be
useful if you tell me how to remove this within the code!!

For Eg: the network path would look like \\10.10.10.10\sharedfolder

Many Thanks
Sri
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
Automatically save a copy of worksheet from C: to Network Drive doosbug Excel Discussion (Misc queries) 1 May 3rd 05 06:23 PM
Link workbooks-C drive to network drive Earl Excel Worksheet Functions 0 April 19th 05 05:50 PM
Default Drive Question Mel Excel Discussion (Misc queries) 2 March 11th 05 03:34 PM
Why does Help go to network? How to avoid it? [email protected] Excel Discussion (Misc queries) 5 March 11th 05 02:17 PM
Linking an entire worksheet from a restricted drive? mkichar Excel Worksheet Functions 1 November 4th 04 06:29 PM


All times are GMT +1. The time now is 12:04 AM.

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"