>Hello,
>
>I'm trying to add a title, using VBA, to an Excel Worksheet to which I've already imported a .dbf table.
>
>The following code works OK except that it does NOT move the contents down 1 row and insert the title.
>
>I've you know the appropriate syntax I'd appreciate your sharing it with me. TIA.
>
>oExcel = CREATEOBJECT("Excel.Application"
>oExcel.Visible = .T.
>oWorkbook = oExcel.Workbooks.open("E:\CVS3\Letters\ExportX1.XLS")
>WITH oExcel.ActiveSheet
.Range("A1").Select
.Selection.EntireRow.Insert
> oRange = .Range("A1:H1")
> oRange = oRange.Offset(1,0)
> .Range("A1").Value = "My Title"
>ENDWITH
Imagination is more important than knowledge