On Jan 25, 7:06*am, TyreDude wrote:
Hello,

Can I use the ActiveWorkbook.SaveAs function and include the user
account to save the file as? For example, I want to save the file to a
directory where the user running the macro only has read only access.
This is why I want to specify the account to use (which has full
access), to save the file successfully.

i..e. ActiveWorkbook.SaveAs User: Domain\Name Password: xxxxxxx

Is there a way this can be done?

Thanks,

Brett

Security is based on the user that is signed onto the machine. Change
permissions on the directory so the user can write to the directory,
or re-assign the task to someone that has the necessary permissions.
Goshute