E
ecease
I'm running a third party application that has hooks in it to Excel, in a
Terminal Services (Win 2K3) session, with the server GPO enabled to "hide
drives" and "prevent access to drives" on all the server's local drives.
Excel 2003 is also installed and published on the server.
I can generate a report in the third party app (they are plain text
reports), and use that app's "open in Excel" button just fine. What I can't
do is use the Excel Wizard that parses the file--the "text to columns"
wizard, directly. I receive a message that I can't write to the disk.
If I just "open in Excel", I can use "text to columns" from within
Excel. I just can't run that wizard as a standalone/plug-in to the other app.
I assume that it is trying to write something temporarily to the
server's local disk, and since the disk is protected by the GPO, that is why
it fails. What I would like to know is where (what path) is it trying to
write the temp files and can I change it somehow? It is not any of the
locations for files that I can control from within Excel itself--I already
tried that. And it isn't a location within my profile, because I can write
to my profile.
I appreciate any help you can give me.
Terminal Services (Win 2K3) session, with the server GPO enabled to "hide
drives" and "prevent access to drives" on all the server's local drives.
Excel 2003 is also installed and published on the server.
I can generate a report in the third party app (they are plain text
reports), and use that app's "open in Excel" button just fine. What I can't
do is use the Excel Wizard that parses the file--the "text to columns"
wizard, directly. I receive a message that I can't write to the disk.
If I just "open in Excel", I can use "text to columns" from within
Excel. I just can't run that wizard as a standalone/plug-in to the other app.
I assume that it is trying to write something temporarily to the
server's local disk, and since the disk is protected by the GPO, that is why
it fails. What I would like to know is where (what path) is it trying to
write the temp files and can I change it somehow? It is not any of the
locations for files that I can control from within Excel itself--I already
tried that. And it isn't a location within my profile, because I can write
to my profile.
I appreciate any help you can give me.