Network location - Username and Password

[arcootje]

I want to open a file on a network ... so for example: \\networkname\c$\
This networklocation is username and password protected.
Then run a vb script
Delete the file or replace it with a emtpy csv file.

How can I open the file with a VB Script (with vb code for the username and password)?

 

[Johnny C]

There's nothing in native VBA to do this.

You're going to need Shell functionality and use either a DOS .bat file or a series of DOS commands to copy the file to somewhere you can use it and create a blank file, something along the lines of

Set objShell = CreateObject("Wscript.Shell")
objShell.Run (run a .bat or a DOS command)