G
Guest
I wrote a template in Excel 97 that on "Workbook_Open", it checks to see if
the fileformat is a template. If it is, the user is informed that they are
going to edit the template. If it is not a template, then the code checks to
see if there is data in a cell called "Event". If there if data in "Event",
then the user is opening a file to continue to work on the workbook. If the
Cell is blank, the user is starting a new workbook and a start up routine is
started.
This all works fine in 97 but when the file is opened in 2000, Excel
crashes. It will open to edit the template. It will open a workbook with the
data in the "Event" cell. It seems to have the problem when "converting" (I
don't know if this is the correct term) the file from a .xlt to .xls. The
only thing I can think to work around this is to save the template as a .xls
file, but I would rather not do that. Why is this happening, and what can I
do to make this work in 2000?
the fileformat is a template. If it is, the user is informed that they are
going to edit the template. If it is not a template, then the code checks to
see if there is data in a cell called "Event". If there if data in "Event",
then the user is opening a file to continue to work on the workbook. If the
Cell is blank, the user is starting a new workbook and a start up routine is
started.
This all works fine in 97 but when the file is opened in 2000, Excel
crashes. It will open to edit the template. It will open a workbook with the
data in the "Event" cell. It seems to have the problem when "converting" (I
don't know if this is the correct term) the file from a .xlt to .xls. The
only thing I can think to work around this is to save the template as a .xls
file, but I would rather not do that. Why is this happening, and what can I
do to make this work in 2000?