Working with late biding vba

[talp101]

hi,

i am working on a project that might be running on diffrent versions of Excel 2003/2007/2010

i heard of late biding and setting up all the Excel objects as Object type. but i haven't realized yet how should i work with this method. should i create a global object and will use it in every function, sub or sending an Object by ref to every function?

help me please.

 

[shg]

What objects, specifically?

 

[talp101]

What objects, specifically?

Like, dim xlApp as Object
Instead of dim xlapp as Excel.Application
And then use the createObject

 

[shg]

You mean like ...

    Dim xlApp       As Object
    Dim wks         As Object

    Set xlApp = CreateObject("Excel.Application")
    xlApp.Workbooks.Open "C:\myPath\myFile.xlsx"
    Set wks = xlApp.ActiveWorksheet

 

[talp101]

Exactly, now what if I have several functions and subs how I am spouse to work with the Objects? Make them global are as an argument by ref for each function?

 

[shg]

Either way. IMO, public variables are overused, and make code less modular and more difficult to debug, but they have their place.

 

[talp101]

What is your recommendation/ the preferred way of working with late biding

 

[shg]

Not knowing what you're trying to do, I can't recommend one or the other. Choosing whether to use Public, module-level, or local variables seems to me to be unrelated to late versus early binding.

 

[Norie]

Why are you using late-binding?

Is this code going to be in an application other than Excel?

 

[talp101]

No, it will run on different excel version like I mentioned above.