About Excel.Application

[David Huang]

Hi:
When I use the Excel.Application object in window 2000 Advanced Server,
I have the following issue
'------------------------------------------get excel template file
'create excel application
Set xlApp = server.CreateObject("Excel.Application")

'open excel file
Set xlbook = xlApp.Workbooks.Open(targetFile)
xlApp.Workbooks.Open(targetFile) will create a shortcut under the C:\ etc.
So when I open as many as files, the shortcuts under c:\ are so many.

How could I avoid create the the shortcuts under c:\????

[David Huang]

I continue study this problem.
And find if I changed the anonymous user to visite this web page I could
resovle this problem.
I change the user IUSR_HUANGCHENCHUN from Guests to user .
But how about the security ?

"David Huang" <ch************@hp.com> wrote in message
news:k8***************@news.cpqcorp.net...

Hi:
When I use the Excel.Application object in window 2000 Advanced Server, I have the following issue
'------------------------------------------get excel template file
'create excel application
Set xlApp = server.CreateObject("Excel.Application")

'open excel file
Set xlbook = xlApp.Workbooks.Open(targetFile)
xlApp.Workbooks.Open(targetFile) will create a shortcut under the C:\ etc.
So when I open as many as files, the shortcuts under c:\ are so many.

How could I avoid create the the shortcuts under c:\????