late binding error

[xxentric]

i turned Option Strict On

and i get an error on all the ".Cells" lines saying option strict on disallows late binding.

                a = 1
                b = 3
                c = 2
                d = 1
                With oSheet
                    Do Until a > 7
                        Do Until .Cells(b, a).Value = ""
                            .Cells(b, a).activate()
                            If .Cells(b, a).Value = .Range("IV" & d).Value Then
                                .Cells(b, c).Value = .Cells(b, c).Value + 1
                                d = d + 1
                            Else
                                If .Range("IV" & d).Value = "" And d < 20 Then
                                    d = d + 1
                                    b = b - 1
                                End If
                            End If
                            b = b + 1
                        Loop
                        a = a + 2
                        b = 3
                        c = c + 2
                        d = 1
                    Loop
                End With

[aashish_9601]

option strict on disallows late binding.

That's the answer, If you want to use Late Binding in .net then you have to let the option strict off

[xxentric]

oh.. heh.. right, i as told that having that Off is bad ans i should have it On .... can someone give me an example of my code if it wasnt late binding?

[aashish_9601]

you can follow the second link in my signature.

[techgnome]

If it's not late binding, then it's early binding... and the code itself would be exactly the same. The difference comes in on how & what the variables get dimmed as and how they are created. And if there's a reference or not.

Yes, normally Option Strict On is a good thing... the exception is when it comes to office products. The problem with early binding there is if you reference a particular version of Office... you're locked into that version. No other version will work.

Best way to deal with it is to set a reference for development and use early binding - this will give you intellisense. do your best to keep the code isolated in its own module or class. Once done, turn off Option Strict FOR THAT FILE ONLY... but putting Option Strict Off at the top of just that code file. The remove the reference, and change the types so that they are objects... and you should be set for late binding, which will allow it to run against almost any version of office.

-tg