- (defun getsheet (sheetname / xlsapp sheets sheet)
- (if (not (VL-CATCH-ALL-ERROR-P
- (setq xlsapp (VL-CATCH-ALL-APPLY
- 'vlax-get-or-create-object
- '("Excel.Application")
- )
- )
- )
- )
- (if (not (VL-CATCH-ALL-ERROR-P
- (setq sheets (VL-CATCH-ALL-APPLY
- 'vlax-get-property
- (list xlsapp 'Sheets)
- )
- )
- )
- )
- (if (not (VL-CATCH-ALL-ERROR-P
- (setq sheet (VL-CATCH-ALL-APPLY
- 'vlax-get-property
- (list sheets 'item sheetname)
- )
- )
- )
- )
- (progn
- (VL-CATCH-ALL-APPLY
- 'vlax-invoke-method
- (list sheet 'Activate)
- ) ;_ 激活该表单
- sheet ;_ 返回值
- )
- )
- )
- )
- )
|