Insert Column in Excel in VB .NET

[kmercer46]

Unable to Shift Excel Colums to the Right.

Portion of my current VB .NET code is:

Dim oXL As Excel.Application
Dim oWBook As Excel.Workbook
Dim oWSheet As Excel.Worksheet
Dim oRng As Excel.Range
Dim oCell As Excel.Range
..
..
I have code here that successfully opens the excel file
consisting of one Workbook and one Worksheet
..
..
..
At this point I want to insert a Column in "A"
and cause all Columns to shift to the right.

Can you help me?

Thanks

 

[Paul Clement]

On 9 Jan 2006 08:49:25 -0800, (e-mail address removed) wrote:

¤ Unable to Shift Excel Colums to the Right.
¤
¤ Portion of my current VB .NET code is:
¤
¤ Dim oXL As Excel.Application
¤ Dim oWBook As Excel.Workbook
¤ Dim oWSheet As Excel.Worksheet
¤ Dim oRng As Excel.Range
¤ Dim oCell As Excel.Range
¤ .
¤ .
¤ I have code here that successfully opens the excel file
¤ consisting of one Workbook and one Worksheet
¤ .
¤ .
¤ .
¤ At this point I want to insert a Column in "A"
¤ and cause all Columns to shift to the right.
¤
¤ Can you help me?

Have you tried using the Macro Recorder in Excel to help you generate the code?


Paul
~~~~
Microsoft MVP (Visual Basic)