By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,950 Members | 986 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,950 IT Pros & Developers. It's quick & easy.

Run Time Error: System Separators

P: 3

I have used the following code to force Excel to accept dot as decimal separator.
Im using MS 2003 and it works fine for me.

But Users are u sing MS 2000 and it gives RUn Time Error 438:Object doesn't support this property or method.

How can I resolve it in MS 2000?

Appreciate any help i can get!!

With Application

.DecimalSeparator = "."
.ThousandsSeparator = ","
.UseSystemSeparators = False
End With
Apr 22 '08 #1
Share this Question
Share on Google+
1 Reply

P: 866
Checks the field's datatype

Rey Sean
Apr 23 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.