Run Time Error: System Separators

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • astropurni
    New Member
    • Apr 2008
    • 3

    Run Time Error: System Separators

    Hi,

    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

    .DecimalSeparat or = "."
    .ThousandsSepar ator = ","
    .UseSystemSepar ators = False
    End With
  • lotus18
    Contributor
    • Nov 2007
    • 865

    #2
    Checks the field's datatype

    Rey Sean

    Comment

    Working...