Williams Renault
New Member
- Joined
- Feb 3, 2010
- Messages
- 1
Hi, wonder if anyone can help me with this please?
I'm trying to construct a macro to open an excel file that is stored on a networked PC.
I've got the following code:
Workbooks.Open (\\10.99.1.4\Alarms\20100717.xls)
The problem I have is the networked drive needs a userid and password entering the first time you access it, so If I run the macro firstly, it hangs and eventually the macro fails, the logon prompt box doesn't even appear on screen.
If I connect to the network drive first, such as from the run command and enter the userid and password, then run the macro, it works fine and opens the file
Is there anyway I can store the userid and password to access the networked drive within the macro so that it can access the file without me having to access the drive manually, first?
Thanks in advance!
I'm trying to construct a macro to open an excel file that is stored on a networked PC.
I've got the following code:
Workbooks.Open (\\10.99.1.4\Alarms\20100717.xls)
The problem I have is the networked drive needs a userid and password entering the first time you access it, so If I run the macro firstly, it hangs and eventually the macro fails, the logon prompt box doesn't even appear on screen.
If I connect to the network drive first, such as from the run command and enter the userid and password, then run the macro, it works fine and opens the file
Is there anyway I can store the userid and password to access the networked drive within the macro so that it can access the file without me having to access the drive manually, first?
Thanks in advance!
Last edited: