ActiveWorkbook.SaveAs Function - Can I specify the user account to save the file with
If what you want is to merely determine who last edited the file, you
can examine the file properties for that.
On Mon, 25 Jan 2010 04:06:02 -0800 (PST), 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
|