S
Sathyaish
I've been saving my Excel template many times till now for the last
two days into a file called Copiers1.xlt. Now, it has started giving
me a GPF and starts crashing Excel when I save it under the same name.
If I save it under a different name, it still does not save saying
"Document not saved." No help button is available on the message box.
What could be causing this? Please help me as I have been stuck for
the last 4 hours with this and have changed several machines and
re-installed Excel also but nothing seems to have changed.
What this template file is supposed to do is, pick up the path of an
Access database from the registry, read from the table in an Access
database and display the data in a tabular form in the spreadsheet. It
allows to the user to edit existing data displayed in the template
file, add more rows in the file and then click a menu item called
"Save to database" (this is also added by the VBA code I am writing in
the template file) to filter invalid data by validating it against a
set of rules and then save all the rows to the same table in the same
Access database. Finally all, this data travels over Winsock to a
server located in the head office of my client for whom I am
developing this application. The head office computer then issues a
read receipt for the data it has received.
The Excel module had 25 odd modules, which includes 18-20 class
modules and five odd Standard modules. It also includes the standard
object modules like the modules for each sheet and one for the
Workbook.
two days into a file called Copiers1.xlt. Now, it has started giving
me a GPF and starts crashing Excel when I save it under the same name.
If I save it under a different name, it still does not save saying
"Document not saved." No help button is available on the message box.
What could be causing this? Please help me as I have been stuck for
the last 4 hours with this and have changed several machines and
re-installed Excel also but nothing seems to have changed.
What this template file is supposed to do is, pick up the path of an
Access database from the registry, read from the table in an Access
database and display the data in a tabular form in the spreadsheet. It
allows to the user to edit existing data displayed in the template
file, add more rows in the file and then click a menu item called
"Save to database" (this is also added by the VBA code I am writing in
the template file) to filter invalid data by validating it against a
set of rules and then save all the rows to the same table in the same
Access database. Finally all, this data travels over Winsock to a
server located in the head office of my client for whom I am
developing this application. The head office computer then issues a
read receipt for the data it has received.
The Excel module had 25 odd modules, which includes 18-20 class
modules and five odd Standard modules. It also includes the standard
object modules like the modules for each sheet and one for the
Workbook.