error inconsistency

[xxentric]

im not understanding why some of the code below works fine and some gives an error

These work fine
.PageSetup
.Borders
.Range

These give error "Option strict on disallows late binding"
.Cells
.Rows
.Columns

what is the difference???

example...

    dim oExcel As Excel.Application
    dim oBook As Excel.Workbook
    dim oSheet As Excel.Worksheet

With oSheet

'WORKING FINE
.PageSetup.Zoom = 65

.Borders(Microsoft.Office.Interop.Excel.XlBordersIndex.xlEdgeTop).LineStyle = Microsoft.Office.Interop.Excel.XlLineStyle.xlContinuous

.Range("A27").Value = "Hello"



'GIVING ERROR
.Cells(1, 1).value = "Hello"

.Rows("60:60").Font.Bold = True

.Columns("A:Z").ColumnWidth = 8.0

End With

[.paul.]

you need to cast those erroneous lines to the correct datatype

[.paul.]

Imports excel = Microsoft.Office.Interop.Excel
 
Public Class Form1
 
    Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
        Dim oExcel As excel.Application
        Dim oBook As excel.Workbook
        Dim oSheet As excel.Worksheet
 
        With oSheet
 
            'WORKING FINE
            .PageSetup.Zoom = 65
            'borders isn't a member of excel.Worksheet
            .Borders(Microsoft.Office.Interop.Excel.XlBordersIndex.xlEdgeTop).LineStyle = Microsoft.Office.Interop.Excel.XlLineStyle.xlContinuous
            .Range("A27").Value = "Hello"
 
 
 
            'GIVING ERROR
            'value isn't a member of excel.Worksheet.Cells
            .Cells(1, 1).value = "Hello"
            'Font isn't a member of excel.Worksheet.Rows
            .Rows("60:60").Font.Bold = True
            'ColumnWidth isn't a member of excel.Worksheet.Columns
            .Columns("A:Z").ColumnWidth = 8.0
 
        End With
    End Sub
End Class

[xxentric]

oops sorry for the late reply.. i think it may be way too much to go through all the code and try to fix everything to make it work... thanks for the info though