Re: Compile error on VBA Function

This is a common problem. I'd look once more for that missing reference. (It
can't hurt!)

MSweetG222 wrote:

No missing DLL references on either machine.
Thanks for the suggestion.
--
Thx
MSweetG222

"Gary Brown" wrote:

On the other machine, get into the VBE.
Check Tools>References for a checked reference that stats with 'MISSING'.
Fix the reference.
--
HTH,
Gary Brown
gary.DeleteThis2SendMeAnEmail.Brown@xxxxxxxxxxxx
If this post was helpful to you, please select ''YES'' at the bottom of the
post.



"MSweetG222" wrote:

All - I have written a .xla program. Program works great on my machine.
However, when installed another computer, I receive a compile error on the
VBA functions. See below for an example...in example subroutine, the other
computer has a compile error on the LEFT function. On my computer, no issues.

Additional info: Tools | Options | Require Variable Declaration is not
checked on either computer. All variables are defined and option explicit is
set on every module in the .xla.

--------------------------------------------------
Example
--------------------------------------------------
Option Explicit

Sub Test

Dim AnyString as string
Dim MyStr as string
AnyString = "Hello World"
MyStr = Left(AnyString, 7) '<<< Compile error on LEFT function

End Sub

--------------------------------------------------

What do I need to do to the .xla or to the computer in question to get past
this compile issue?

Thank you for any assistance.

MSweetG222


--

Dave Peterson
.

Relevant Pages

  • Re: File Size Code not working
    ... The code seemed a bit of a mish-mash, but he did use FSO. ... (remove nothere from the email address if mailing direct) ... "Gary Brown" wrote in message ... >>> Without using a reference to FSO, ...
    (microsoft.public.excel.programming)
  • Re: Generating Field inputs from other fields
    ... The main portion is the random part. ... There are 3 parts put together with an ampersand. ... Reference to A1 is... ... Gary Brown ...
    (microsoft.public.excel.programming)
  • Re: File Size Code not working
    ... Sorry for confusing the issue. ... Gary Brown ... > The code seemed a bit of a mish-mash, ...
    (microsoft.public.excel.programming)
  • Re: Simple class library (dll) example?
    ... I want to begin understanding how class libraries are written under ... Option Explicit On ... I'm going to use what's called a project reference. ... Sub Main ...
    (microsoft.public.dotnet.languages.vb)
  • Re: multiple instances of the same form?
    ... >> I'll bet you don't have Option Explicit enabled. ... >> scope, and the reference it holds to the form, is destroyed. ... >> To get around this problem, declare the variable at module-level, ... >> Private Sub OpenAnotherWindow_Click ...
    (microsoft.public.access.formscoding)
Loading