Costy
02-14-2008, 08:47 AM
Haye everyone,
First post so be nice :D
I have a piece of code which basically loops through files on a shared folder. Only problem is that the server requires you to enter a username and password. I was wondering is there some sort of way I can:
A. Get VBA to enter them for me
B. Ask for them off the user
This is the path. Is there somewhere in the Path i can enter them?
Path = "\\server\budgets\" & Branch & "\"
This is where it fails (Error number 52)
strFile = Dir(Path & "*.bas")
Thankyou in advance to everyone! :D
First post so be nice :D
I have a piece of code which basically loops through files on a shared folder. Only problem is that the server requires you to enter a username and password. I was wondering is there some sort of way I can:
A. Get VBA to enter them for me
B. Ask for them off the user
This is the path. Is there somewhere in the Path i can enter them?
Path = "\\server\budgets\" & Branch & "\"
This is where it fails (Error number 52)
strFile = Dir(Path & "*.bas")
Thankyou in advance to everyone! :D