View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
onedaywhen onedaywhen is offline
external usenet poster
 
Posts: 459
Default Changing Regional Settings from VBA

Michael Rekas wrote ...

The situation is that there are ±60 workstations countrywide.
A further problem is that there is a routine which extracts data from
an SQL database where the date is in text format.
We need for everyone in the organisation to set their Short Date to
this format.


If you have a business need to change the all machines' regional
settings, regardless of your Excel project, then do it as a separate
project.

As regards your Excel project, in your SQL query you should use the
CAST function to convert from text to a date on the server i.e. before
it arrives into your workbook.

--