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

On 9 Jan 2006 08:49:25 -0800, kmerce***@yahoo.com 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)

Reading Binary File in VS2005
Bug or By Design...
number of lines in Richtextbox
LRC Calculation algorithm
How to change a VB solution/project name?
What version of SQL Server can I install in my Windows XP PC and..
Migration of MSFLEXGRID to DATAGRID in vb.net...
Releasing a loaded assembly in ASP.NET 2.0
Bind dinamicly dlls without createobject
sending Fax from vb.net with Microsoft Fax Service Extended COM Type Libary