Devendra
April 30th, 2001, 02:10 PM
Here is a problem statement:
I made one dll in VB6.0, which reads some data values
from the database(SQL Server). Then it opens the Excel
Work Book that already exists and inserts data into
some fixed cells. Then I am calling Workbooks Save
method to save this workbook. This is how the
application works. I am calling this dll in ASP page.
This application is working fine in Windows NT server
and PWS. But if I try to run the application on Win2k
then it gives the error "Document Not Saved" at the
line where I am calling the save method of the
workbook. If I call this dll through VB application on
same Win2k server it is working fine. I saw the
Microsoft Help for the error "Document Not Saved" for
excel but the reasons that are given for this error
are not matching with my problem. Because we have full
access permissions on the folder, there is no chance
of termination of saving process in between.
I made one dll in VB6.0, which reads some data values
from the database(SQL Server). Then it opens the Excel
Work Book that already exists and inserts data into
some fixed cells. Then I am calling Workbooks Save
method to save this workbook. This is how the
application works. I am calling this dll in ASP page.
This application is working fine in Windows NT server
and PWS. But if I try to run the application on Win2k
then it gives the error "Document Not Saved" at the
line where I am calling the save method of the
workbook. If I call this dll through VB application on
same Win2k server it is working fine. I saw the
Microsoft Help for the error "Document Not Saved" for
excel but the reasons that are given for this error
are not matching with my problem. Because we have full
access permissions on the folder, there is no chance
of termination of saving process in between.