Problem copying results to Excel from MARK

[Rotella]

I have a new computer with Windows XP and Office 2007. MARK provides an error message and aborts when I try to use MARK to copy results from MARK to Excel.

The message is

Object variable or With block variable not set
Subsystem: ExcelStart
Error Subcode: 1
Function: FILLCELL
Description: Object variable or With block variable not set
CallStack:
EXCELDIALOG: COPYARRAY (Line: 26)
EXCELDIALOG:POSTINIT (Line: 10)
EXCELDIALOG: INIT (Line: 14)
DISPLAY_RESULTS:RESULTSTABLETOEXCEL (Line: 53)
APP: START (Line: 739).

If anyone has suggestions for getting around this problem, I'd appreciate seeing them.
Thanks.
Jay

[gwhite]

Jay:
When I first got Excel 2007, I also had problems with MARK. There is something different between Excel 2007 and Excel 2003. I figured out that there was one statement in my existing MARK code that caused the problem, and that removing that statement fixed the problem. So, the way I determined whether the user was running Excel 2007 or Excel 2003 was to put in a check for what subdirectory Excel is stored in:

// Kludge to work around Excel 2007
IF !File("C:\Program Files\Microsoft Office\Office12\EXCEL.EXE")

The ! in the IF statement above means "not", so if you have Excel stored in the subdirectory "C:\Program Files\Microsoft Office\Office12\EXCEL.EXE", then the statement that follows the IF statement is not excecuted.

There must be a better way to determine what version of Excel you are running, and maybe what I will have to do is set a flag in the Preferences window that says you are using Excel 2003 or Excel 2007. That may also be the fix that Vista needs.

Gary