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]

As Norie points out, unless you are automating Excel from another application, there's no need to late-bind.

 

[talp101]

But, when I am using with functions that are working in excel 2010 and doesn't work on excel 2003, what should I do?

 

[shg]

If it needs to work in Excel 2003, don't use functions that are not supported. Design for the earliest version that will be used.