View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
TyreDude[_2_] TyreDude[_2_] is offline
external usenet poster
 
Posts: 2
Default ActiveWorkbook.SaveAs Function - Can I specify the user account tosave the file with

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