Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Excel files stored on a different server
Hello,
I need to open Excel files using a macro that are stored in a different server which is controlled by user accounts. My normal practise is to map a drive to the server using my username and password and then use the mapped drive to point to the files stored there.. I want to automate this process, by enabling the macro to connect to the server by getting the user informations and open the excel files...(preferably by not mapping drives.. which i tried using MSDOS commands)... Can we use a similar sort of thing like... \\serverip\foldername\filename...(but don't know how to supply the user name and password of the serverin this) Any help please.. Thanks, Sri |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
How do I isolate my Excel server (automation) from other Excel instances? | Excel Discussion (Misc queries) | |||
sharing/using/saving Excel 2002 files in Excel 2003 | Excel Discussion (Misc queries) | |||
Excel Add-in Use on a Terminal Server | Excel Discussion (Misc queries) | |||
Problems opening Excel files using DFS links | Excel Discussion (Misc queries) |