I wrote a program in VB.Net (doesn't matter). The program will save a
modified excel book to a new filename. The window login user shall not have
permission to write files to the destination folder. The program uses
Impersonation of another user (have permission to write to the folder). Here
is the simple logic:
Impersonate()
MyBook.SaveAs (theTagartFile)
UnImpersonate()
However, I have problem with this. It seems when using SaveAs or Save, it
switches to window user instead of using the impersonated user. I have used
Implersonate functions in many places in the application without any problem.
But with this excel save or SaveAs, it gets a permission error. Luckly I had
anthoer program that finds out the SaveAs involves many intermediate steps
(processes) such as creating, modifying, and deleting temporary files. But I
can not see if any temp files created in other folders. Anyone knows the
detail process of SaveAs function?

Thanks