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

I suppose you have tried just recording a macro?

ChDir "D:\documents and settings\blab\Desktop\workbook.xls"
ActiveWorkbook.SaveAs Filename:= _
"D:\documents and settings\blab\Desktop\filename\workbook.xls", _
FileFormat:=xlNormal, Password:="", WriteResPassword:="", _
ReadOnlyRecommended:=False, CreateBackup:=False

The password stuff may get you hung up, but that is about all i can see.

"xux" wrote:

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

Hi xux,

xux wrote:
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?

I don't really know the internals of the SaveAs method, but have you tried
using filemon from sysinternals? You should be able to see exactly where
the access denied error is cropping up with that tool. Maybe it's the one
you referred to.

--
Regards,

Jake Marx
www.longhead.com


[please keep replies in the newsgroup - email address unmonitored]