Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
mid function causes a compile error | Excel Programming | |||
mid function causes a compile error | Excel Programming | |||
Trying to use INDEX function in VBA Code, compile error | Excel Programming | |||
Help With - Compile Error: Sub or Function Not Defined | Excel Programming | |||
compile error using Left() function | Excel Programming |