M
MSweetG222
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
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