VB6 formula not working in excel

[Guest]

Hi,

I have a few formulas embedded in my vb6 code which calculate and enter the
results in the excel sheet. These formulas work for me and everyone at my
workplace. But for some reason these formulas have recently stopped working
for some of our model users in other countries.

I noted that the problem is only with the formulas that are calculating the
percentage, the rest of the formulas are working on the sheet.

I also wanted to ask, is there a difference in using N/A and N?A in VB6? I
should probably ask this question in the VB forum, but if anyone knows,
please advise.

Thanks,

 

[Jim Rech]

Without the specifics (formulas, countries) it's hard to try to duplicate
the problem. But then you too could change your country setting under
Windows Control Panel, Regional Settings to see what's going on and test
possible workarounds.

--
Jim
| Hi,
|
| I have a few formulas embedded in my vb6 code which calculate and enter
the
| results in the excel sheet. These formulas work for me and everyone at my
| workplace. But for some reason these formulas have recently stopped
working
| for some of our model users in other countries.
|
| I noted that the problem is only with the formulas that are calculating
the
| percentage, the rest of the formulas are working on the sheet.
|
| I also wanted to ask, is there a difference in using N/A and N?A in VB6? I
| should probably ask this question in the VB forum, but if anyone knows,
| please advise.
|
| Thanks,
|

 

[Harlan Grove]

I have a few formulas embedded in my vb6 code which calculate and
enter the results in the excel sheet. These formulas work for me
and everyone at my workplace. But for some reason these formulas
have recently stopped working for some of our model users in other
countries.

....

This is probably the salient point: different countries. That very
likely means different regional settings. For example, if you're in
the US and you have users in Germany, those German users will likely
have regional settings in which comma is the decimal point, periods
are thousands separators, and semicolons are list separators, thus
argument separators in Excel function calls.

What are the formulas?

And never just write "stopped working". Always provide RECISE and
COMPLETE details about what they should be doing but no longer do. For
instance, are users in other countries getting clearly wrong formula
results or syntax errors in which Excel won't accept the formulas
entered?