VBA Compile Error on Deployment
 

I have an Excel spreadhseet that makes use of the VBA function str. When it
is run on a machine in Germany they get a error with the str function, as if
it is not part of the language.

Another user in the U.S. was trying to use the spreadsheet (run from their
network) and got a Compile Error: Automation Error with the line:
Private Sub LegendSetFont(ByRef cht as ChartObject)

The speadsheet works on my Office 2003 and Office 2002 versions of Excel.

Any suggestions will be appreciated.

Thanks.

VBA Compile Error on Deployment
 

The Germany problem sounds like Germany is missing a Reference. Have them go
into the VBE and check for a 'Missing' Reference or build in the reference
via code. Check out "AddFromGuid" and "AddFromFile".
I don't know about the chart error, sorry.
HTH and Good luck,
Gary Brown


"ran010303" wrote:

I have an Excel spreadhseet that makes use of the VBA function str. When it
is run on a machine in Germany they get a error with the str function, as if
it is not part of the language.

Another user in the U.S. was trying to use the spreadsheet (run from their
network) and got a Compile Error: Automation Error with the line:
Private Sub LegendSetFont(ByRef cht as ChartObject)

The speadsheet works on my Office 2003 and Office 2002 versions of Excel.

Any suggestions will be appreciated.

Thanks.

VBA Compile Error on Deployment
 

"ran010303" wrote in message
...
I have an Excel spreadhseet that makes use of the VBA function str. When
it
is run on a machine in Germany they get a error with the str function, as
if
it is not part of the language.

Another user in the U.S. was trying to use the spreadsheet (run from their
network) and got a Compile Error: Automation Error with the line:
Private Sub LegendSetFont(ByRef cht as ChartObject)

The speadsheet works on my Office 2003 and Office 2002 versions of Excel.

Any suggestions will be appreciated.

Thanks.


Where is the Str function? In a cell? In a macro? As for the second problem,
I agree with Gary's reply.
Can you show the code or the function where Str appears?

/Fredrik

VBA Compile Error on Deployment
 

The reason I believe it's a reference issue is because when a reference is
missing you get errors that say the str function or the find function etc etc
are missing. I don't believe the issue is a problem with the str function at
all.
HTH,
Gary Brown

"Fredrik Wahlgren" wrote:


"ran010303" wrote in message
...
I have an Excel spreadhseet that makes use of the VBA function str. When
it
is run on a machine in Germany they get a error with the str function, as
if
it is not part of the language.

Another user in the U.S. was trying to use the spreadsheet (run from their
network) and got a Compile Error: Automation Error with the line:
Private Sub LegendSetFont(ByRef cht as ChartObject)

The speadsheet works on my Office 2003 and Office 2002 versions of Excel.

Any suggestions will be appreciated.

Thanks.


Where is the Str function? In a cell? In a macro? As for the second problem,
I agree with Gary's reply.
Can you show the code or the function where Str appears?

/Fredrik

VBA Compile Error on Deployment
 

Below is the VBA code section with the str function:

With Worksheets("Tables")
cmdPlotEnvelope.Caption = "Add/Del Mask #" & Str(.Cells(38, 2))
cmdSetXdbFloor.Caption = "Set X dB Floor #" & Str(.Cells(38, 2))
cmdSetS.Caption = "Set S (Slope) #" & Str(.Cells(38, 2))
End With


"Fredrik Wahlgren" wrote:


"ran010303" wrote in message
...
I have an Excel spreadhseet that makes use of the VBA function str. When
it
is run on a machine in Germany they get a error with the str function, as
if
it is not part of the language.

Another user in the U.S. was trying to use the spreadsheet (run from their
network) and got a Compile Error: Automation Error with the line:
Private Sub LegendSetFont(ByRef cht as ChartObject)

The speadsheet works on my Office 2003 and Office 2002 versions of Excel.

Any suggestions will be appreciated.

Thanks.


Where is the Str function? In a cell? In a macro? As for the second problem,
I agree with Gary's reply.
Can you show the code or the function where Str appears?

/Fredrik

VBA Compile Error on Deployment
 

"Gary Brown" wrote in message
...
The reason I believe it's a reference issue is because when a reference is
missing you get errors that say the str function or the find function etc
etc
are missing. I don't believe the issue is a problem with the str function
at
all.
HTH,
Gary Brown


Hmm... What you're saying is that this error is a side effect of the
missing reference? I have never seen this problem before. Interesting, you
learn something new every day.

/Fredrik

VBA Compile Error on Deployment
 

"ran010303" wrote in message
...
Below is the VBA code section with the str function:

With Worksheets("Tables")
cmdPlotEnvelope.Caption = "Add/Del Mask #" & Str(.Cells(38, 2))
cmdSetXdbFloor.Caption = "Set X dB Floor #" & Str(.Cells(38, 2))
cmdSetS.Caption = "Set S (Slope) #" & Str(.Cells(38, 2))
End With



This looks OK to me. AFAIK, VBA code doesn't get translated . I guess Gary
is right then.

/Fredrik