Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Handle to existing Excel document
#11
Try this
Macro Macro1571
Code:
Copy      Help
;/exe 1

ExcelSheet es1

;this code is simplified Init version
IDispatch xlApp._getactive("Excel.Application")
es1=xlApp.ActiveSheet


es1.SetCell("OK" 1 22)

And try this. It uses VBScript and runs in wscript as .vbs file, not in QM. Should be True. If fails, will be False.
Macro Macro1572
Code:
Copy      Help
str vb=
;Set xlApp=GetObject(,"Excel.Application")
;Set es1=xlApp.ActiveSheet
;MsgBox not Nothing is es1
VbsExec2 vb


Messages In This Thread

Forum Jump:


Users browsing this thread: 1 Guest(s)