Solved: Loop files on shared folder

[Costy]

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

[CCkfm2000]

try this

Shell "net use X: \\server\budgets$ (file://server/budgets$) /user:DOMINE NAME\USERNAME PASSWORD"

[Costy]

Not exactly what I was hoping for, don't really want to start mapping drives. Is there anyway to enter the username and password within the path ?

Thanks :D

[Costy]

Is there anyway I can store a username and password within Windows from VBA. e.g. "go to run, type control userpasswords2"

[Costy]

No worries all sorted now...I basically just used CCkfm2000's post.

Thankyou, much appreciated! :D