Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

VBA distribution: Compiler error

Status
Not open for further replies.
llamaman

llamaman

Programmer
Jan 9, 2002
49
US
Upon distribution of a VBA application, I've found that users get a compile error. How do I include all of my references so that as I distribute the application, the users do not get these errors?
Thanks!
Llamaman
 
Sort by date Sort by votes
Just a guess sonce you did not specif the "compile error".
If you programmed it in Office 2000 VBA using Replace, Split or Join functions and distributed it to an Office '97 CPU then you will get an error that references will not fix. '97 does not have those functions.
Compare Code (Text)
Generate Sort in VB or VBScript
 
Upvote 0 Downvote
I compiled the project, then saved it, then gave it to another user using the same release of Office 97, and it gave a compile error that crashed on a Trim() function.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

thanhthanh12
  • Locked
  • Question
Help vba
Replies
3
Views
333
combo
combo
Andrzejek
  • Locked
  • Question
Outlook VBA - Trust access
Replies
3
Views
464
hermanlaksko
hermanlaksko
SLW89
  • Locked
  • Question
VBA newbie needs help
Replies
4
Views
287
Andrzejek
Andrzejek
xwb
  • Locked
  • Helpful tip
Performing VBA operations in other languages
Replies
1
Views
233
strongm
strongm
f0rg3tfu1
  • Locked
  • Question
VBA Error in Excel
Replies
11
Views
332
combo
combo

Part and Inventory Search

Sponsor

Back
Top