Re: Compile error on VBA Function

Is this why I sometimes can't use the Format function?

Really ?

does this work for you -

MsgBox VBA.Strings.Format(Date, "ddd dd mmm yy")

Regards,
Peter T

"Niek Otten" <nicolaus@xxxxxxxxx> wrote in message
news:uxXggfs$GHA.1556@xxxxxxxxxxxxxxxxxxxxxxx
Hi Dave,

Is this why I sometimes can't use the Format function? I've been
struggling with that one for years! Of course I found
workarounds, but they use work*** functions which is always less
efficient.

--
Kind regards,

Niek Otten
Microsoft MVP - Excel


"Dave Peterson" <petersod@xxxxxxxxxxxxxxxx> wrote in message
news:454A63F0.E653FE44@xxxxxxxxxxxxxxxxxxx
| 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




.