Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Integrate VBA to QM2
#2
1. Get variable of type Excel.Application.
2. Use the variable wherever a function called without a variable.

Macro Macro2142
Code:
Copy      Help
ExcelSheet es.Init
Excel.Application app=es.ws.Application
app.Range(app.Selection, app.Selection.End(Excel.xlToLeft)).Select
app.Range(app.Selection, app.Selection.End(Excel.xlUp)).Select
app.Selection.Delete(Excel.xlUp)
app.Range("D2").Select


Messages In This Thread

Forum Jump:


Users browsing this thread: 1 Guest(s)