data linked to files in shared computer
 

I have written a macro to update cells with new links daily, when new data
comes up.

The new data is saved as a new file everyday, in some shared computer.

Problem is, if the file is not available that day, the macro prompts me with
a window to choose where the file can be found. How do I get it to not update
the link if the new file cannot be found?

My next problem, is how to write in codes, the user name and password
required to access the said computer for the files?

Thanks a million