I have a question regarding the regional settings on a PC.
I have two applications, one is an Excel workbook with lots of VBA and another is a Word document also with lots of VBA.
The Word document will only work properly when the LIST SEPARATOR is set to ;
The Excel sheet will only work properly when the LIST SEPARATOR is set to ,
This is set via:
Regional & Language Options
Regional Options Tab
List Separator , or ; depending on application.
Its not possible to modify things to make it work with a general list separator... tried that earlier ... see
However, my question is, is there any way of setting the regional settings via VBA when the sheet opens so that an error does not occur ?
Alternatively can i check the value of the List Seperator and if its not a ; as required then use a pop up box to issue a warning to the user.