Sharing MAcros/Templates

[Zoltar54]

I have created a VBA program and will now be sending it to a few users. My
question is this - Will all of the references to the Jet and DAO db still
work on the new users PC or do they need to set them manually?

 

[Doug Robbins - Word MVP]

See the article "Distributing macros to other users" at:

http://www.word.mvps.org/FAQs/MacrosVBA/DistributeMacros.htm

If you are sending them the Template in which you have the references set,
they shoud be maintained.


--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

 

[Jezebel]

There's no guarantee that JET/DAO will be available on a new PC. Usually it
is (if only because there's still a lot of legacy software around that uses
it); but I've seen at least one corporate configuration of new XP machines
that didn't include it.

 

[Zoltar54]

Jezebel,

Would you advise that I use ADO/Jet references? And if so will that require
that I re-program?

Z

 

[Jezebel]

That's quite a big question.

ADO is the newer technology and has a lot of features that DAO does not
have. If you've already written your app, this is probably irrelevant.

Changing from DAO to ADO will involve re-programming. How much depends on
the app. DAO is simpler and easier to work with. You'll also have your own
learning curve to deal with. If most of your database work is done through
SQL statements, there won't be all that much to change, although ADO's SQL
syntax is slightly different.

DAO is quicker than ADO for some types of application.