View Single Post
  #11   Report Post  
Posted to microsoft.public.excel.newusers
VBasic VBasic is offline
external usenet poster
 
Posts: 2
Default Regional Settings / Finding out Array separator characters

Hi,
1. INFO
open a new Excel document
open Visual Basic Editor
in the help box type International
select international property
scroll down
there's the info

2. CODE
in Visual Basic Editor select insert new module
copy & paste the subceeding code:
Option Explicit
Sub ArraySeparators()
Dim strsep As String
'Set Application.International(xlColumnSeparator) = "\"
strsep = "Alternate Array Separator =" &
Application.International(xlAlternateArraySeparato r) & vbCrLf
strsep = strsep & "Column Separator =" &
Application.International(xlColumnSeparator) & vbCrLf
strsep = strsep & "Decimal Separator =" &
Application.International(xlDecimalSeparator) & vbCrLf
strsep = strsep & "List Separator =" &
Application.International(xlListSeparator) & vbCrLf
strsep = strsep & "Row Separator =" &
Application.International(xlRowSeparator) & vbCrLf
strsep = strsep & "Thousands Separator =" &
Application.International(xlThousandsSeparator) & vbCrLf
MsgBox (strsep)
End Sub

select Run to run the macro

3. CONCLUSION
Now you can see your separators in the message box. They are read-only which
probably means they can't be changed via Excel or Visual Basic Editor.
I have the English version of Excel 2003 Professional, but Croatian Regional
Settings
I have "Alternate Array Separator" set to @, and "Column Separator" set to
\. When I try to use them, Excel doesn't like them (The formula you typed
contains an error...).
Is it the end of the road?
Come on, you experts!