Prev: Target Range Activation
Next: convert to capital letters
From: CellShocked on 25 Jan 2010 07:57
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
<manning24brett(a)googlemail.com> 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
 | 
Pages: 1
Prev: Target Range Activation
Next: convert to capital letters