Implementing late binding for VBA

[VanS]

Hello,
I have a VB, Excel/Word VBA app running in Excel with automation. I have
developed it on my Win XP Pro, OFfice 2003 system, but need to make it
backward compatible to a Win 98 Office 97 platform. After researching it
seemed best to implement via late binding which I did by removing references
to Word which helped that issue. Then I had issues with losing references to
the VBA 5.3 Extensibility library and KB articles suggested using late
binding for that as well, so I removed that reference. Now my app (again
under Win 98 Office 97 VPC) bombs out unable to use String functions as Left,
Mid and Format which are under the VBA Object library. I tried removing the
VBA reference but it wouldn't allow me since it was in use. Since Office 97
uses the VB5 model, I'm assuming I need to do late binding for that as well.
Can anyone tell me if that is the case and how to implement it? Or if it is
another issue?
Thanks, God bless,
Van

 

[Cindy M -WordMVP-]

Replied to duplicate question the other day. (Probably in
another group, but I don't remember which one)

Cindy Meister

 

[VanS]

Hi Cindy,
Yes, you did reply to my same question previously in Discussions in
OfficeDev newsgroup. I appreciated your response, but I had some followup
questions for you which I posted there. I didn't know if you got my response,
but if you are able I would very much appreciate your help.I have been trying
to make my app backward compatible for this prospective client for over a
month now. Every time I get one layer of the problem solved, another layer
appears.
Thanks, God bless
Van