Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Excel Macro
#6
Macro
Code:
Copy      Help
;/exe 1
ExcelSheet es.Init
IDispatch a=es.ws.Application

a.Range("E:E,G:G,I:I,J:J,K:K,L:L").Select
a.Range("L1").Activate
a.Selection.NumberFormat = "#,##0.00"

As you see, i only appended a. to every function. Other macros may require some more changes. For example, join lines when split using _.


Messages In This Thread

Forum Jump:


Users browsing this thread: 1 Guest(s)