Creating a Simple macro

[Gintaras]

In Excel you can record Excel macro. I tried to record and this is the macro:

Sub Macro1()
'
' Macro1 Macro
' Macro recorded 2008.08.15 by G
'
' Keyboard Shortcut: Ctrl+k
'
Columns("E:E").Select
Selection.Cut
Columns("B:B").Select
ActiveSheet.Paste
End Sub

Now convert to QM:
Macro

Code:

Copy      Help

;/exe 1
ExcelSheet es.Init
IDispatch a=es.ws.Application
a.Columns("E:E").Select
a.Selection.Cut
a.Columns("B:B").Select
a.ActiveSheet.Paste