please help - sub or function not defined

[prepressmonkey]

hello,

we use a database-app (based on aci 4D), that uses vba to export data to word.

it worked without problems for years (with office 98, office 2001 and now
office 2004), but since 2 weeks two colleagues always get the following error
message (when the database app opens word and tries to fill in data):

error while compiling:
sub or function not defined

it seems to be a problem with their user-accounts, on both computers we have
a second user installed with this users the database/word combination works
without problems.

so I tried to delete several preferences-files (e.g. microsoft-folder in
preferences), but this also didn't helped. afterwards I deleted several files
of the microsoft user data folder in the documents folder (e.g. die
tmp-word-files after crashes, the mail-tmp-folder), this helped for two
restarts.

so I would like to ask, if there are any specific files in the
library-folder, that could interfere the word/ vba-routines?

thanks for your help in advance,

regards,


ferdinand

 

[Bob Greenblatt]

hello,

we use a database-app (based on aci 4D), that uses vba to export data to word.

it worked without problems for years (with office 98, office 2001 and now
office 2004), but since 2 weeks two colleagues always get the following error
message (when the database app opens word and tries to fill in data):

error while compiling:
sub or function not defined

it seems to be a problem with their user-accounts, on both computers we have
a second user installed with this users the database/word combination works
without problems.

so I tried to delete several preferences-files (e.g. microsoft-folder in
preferences), but this also didn't helped. afterwards I deleted several files
of the microsoft user data folder in the documents folder (e.g. die
tmp-word-files after crashes, the mail-tmp-folder), this helped for two
restarts.

so I would like to ask, if there are any specific files in the
library-folder, that could interfere the word/ vba-routines?

thanks for your help in advance,

regards,


ferdinand

Has the application been updated? It's pretty difficult to determine what
may be the problem without seeing the code. It sounds to me like the
application may have been updated and the update uses some VBA 6 functions
that work in windows, but no on the Mac.

 

[prepressmonkey]

hello bob,

no, unfortunately nothing changed - no new version of the aci 4d database
and no new version of office 2004

that's the strange thing - my guess is, that a library- or preference-file
is defect, but I can't find it...

regards,


ferdinand

 

[Bob Greenblatt]

hello bob,

no, unfortunately nothing changed - no new version of the aci 4d database
and no new version of office 2004

that's the strange thing - my guess is, that a library- or preference-file
is defect, but I can't find it...

regards,


ferdinand

Well, without knowing which sub or function is undefined, and what the code
is attempting, it's vary hard to progress further.

 

[John McGhie]

Hi Ferdinand:

If I were a betting man, I would suggest that the database code calls out to
an external module in the user's local data folder.

Which, of course, is invisible to the other user.

Go through the code looking for "Call" or "Run" statements -- that's a sure
sign that the code developer is calling out to a library module in a
different template.

The sub or function is undefined in the current user's context, which means
its in file the current user can't access.

Cheers

hello,

we use a database-app (based on aci 4D), that uses vba to export data to word.

it worked without problems for years (with office 98, office 2001 and now
office 2004), but since 2 weeks two colleagues always get the following error
message (when the database app opens word and tries to fill in data):

error while compiling:
sub or function not defined

it seems to be a problem with their user-accounts, on both computers we have
a second user installed with this users the database/word combination works
without problems.

so I tried to delete several preferences-files (e.g. microsoft-folder in
preferences), but this also didn't helped. afterwards I deleted several files
of the microsoft user data folder in the documents folder (e.g. die
tmp-word-files after crashes, the mail-tmp-folder), this helped for two
restarts.

so I would like to ask, if there are any specific files in the
library-folder, that could interfere the word/ vba-routines?

thanks for your help in advance,

regards,


ferdinand

--
Don't wait for your answer, click here: http://www.word.mvps.org/

Please reply in the group. Please do NOT email me unless I ask you to.

John McGhie, Consultant Technical Writer
McGhie Information Engineering Pty Ltd
http://jgmcghie.fastmail.com.au/
Sydney, Australia. S33°53'34.20 E151°14'54.50
+61 4 1209 1410, mailto:[email protected]

 

[prepressmonkey]

hi john,

I now found a solution - I created a new user on this workstation, moved the
files from the old user-folder to the new user-folder, but only really needed
files of the library folder (eg. bookmarks, addressbook, ...).

now it works again.
so word must have a problem with a file in the library folder, I already
tried before to delete the preference-files of the office apps and some other
files - that didn't helped; there must be a file, that's relevant to word
but doesn't have a com.microsoft... part the filename...

regards,


ferdinand

 

[John McGhie]

Hmmm... Fascinating

That indicates that part of the VBA project itself was outside the
jurisdiction of that user ID.

Strange... None of the VBA stuff is IN the Library folder. But the Library
folder does contain the .plists that tell VBA where to find its various
pieces...

Cheers

hi john,

I now found a solution - I created a new user on this workstation, moved the
files from the old user-folder to the new user-folder, but only really needed
files of the library folder (eg. bookmarks, addressbook, ...).

now it works again.
so word must have a problem with a file in the library folder, I already
tried before to delete the preference-files of the office apps and some other
files - that didn't helped; there must be a file, that's relevant to word
but doesn't have a com.microsoft... part the filename...

regards,


ferdinand

--
Don't wait for your answer, click here: http://www.word.mvps.org/

Please reply in the group. Please do NOT email me unless I ask you to.

John McGhie, Consultant Technical Writer
McGhie Information Engineering Pty Ltd
http://jgmcghie.fastmail.com.au/
Nhulunbuy, NT, Australia. S12.22.1918,E136.99.5392
+61 4 1209 1410, mailto:[email protected]