CreateObject

[snowsride]

I have trie instantiating Excel an Graph by using CreateObject but I'm clealry not using the corect syntax. Can someone send me the code - all of it including the Dim statements to open Excel, insert a column, and then release Excel. Hopefully I can then amend the code as necessary.

Thanks

 

[PearlGI]

This code will do the basics of what you want:


dim objExcel As Object

Set objExcel = CreateObject("Excel.Application")

Columns("C:C").Insert Shift:=xlToRight

objExcel.Quit
Set objExcel = Nothing


HTH