Xcel file corrupt?

R2005 Vlisp:

Somtimes when I open Excel with vlisp I can get the excel object and the active workbook and print the file and close excel.
But some times I get an null object error when I try to get the workbook or sheet.
WhenI look at the data inside the excel object it looks like this:

Command: (vlax-dump-object xls_obj t)
; _Application: nil
; Property values:
; ActiveCell (RO) = nil
; ActiveChart (RO) = Exception occurred
; ActivePrinter = "\\\\FS02\\HP5M(Engineering) on Ne04:"
; ActiveSheet (RO) = nil
; ActiveWindow (RO) = nil
; ActiveWorkbook (RO) = nil

Does this mean the excel file is corrupt? It prints fine when manually printed from excel.

TIA

Bill

 

Bill

Did you cleanup excel objects on close? Sample:

(defun VxExcelInterfaceClose (Sav / ClsFlg)
(if (and Gb:Wbk (not (vlax-object-released-p Gb:Wbk)))
(progn
(vlax-invoke-method Gb:Wbk 'Close Sav)
(vlax-release-object Gb:Wbk)
(setq ClsFlg T
Gb:Wbk nil
)
)
)
(if (and Gb:ExO (not (vlax-object-released-p Gb:ExO)))
(progn
(vlax-invoke-method Gb:ExO 'Quit)
(vlax-release-object Gb:ExO)
(setq ClsFlg T
Gb:ExO nil
)
)
)
(if ClsFlg (gc))
(princ)
)

Cheers

 

Workbook Locked ?

 

No,
But I rebooted the machine and now all is well.

Thanks

Bill

 

Bill,

As I understand it, restarting the machine resets any busy files to not busy. But
that doesn't say much about your original question, does it?

Joe Burke

 

Did you cleanup excel objects on close? <<

That could've been the problem, I tried something that didn't work right (may have been my fault) and closed the Excel file manually without releasing anything.

Thanks

Bill

 

Bill

Glad to help you...

Cheers