topic Re: Help MACRO in QlikView https://community.qlik.com/t5/QlikView/Help-MACRO/m-p/540923#M1138108 <HTML><HEAD></HEAD><BODY><P>User Preference can be set like:</P><P></P><P>set up&nbsp; = ActiveDocument.GetApplication.GetUserPreferences</P><P>&nbsp;&nbsp;&nbsp; up.UseSystemDateTime = true</P><P>&nbsp;&nbsp;&nbsp; up.DateTimeFormat = "YY-MM-DD"</P><P>&nbsp;&nbsp;&nbsp; ActiveDocument.GetApplication.SetUserPreferences up</P></BODY></HTML> Thu, 19 Sep 2013 10:00:50 GMT tresB 2013-09-19T10:00:50Z Help MACRO https://community.qlik.com/t5/QlikView/Help-MACRO/m-p/540922#M1138107 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>How can I change Regional Seetings Date format using Qlikview Macro?</P><P></P><P>thankx</P></BODY></HTML> Thu, 19 Sep 2013 09:54:47 GMT https://community.qlik.com/t5/QlikView/Help-MACRO/m-p/540922#M1138107 2013-09-19T09:54:47Z Re: Help MACRO https://community.qlik.com/t5/QlikView/Help-MACRO/m-p/540923#M1138108 <HTML><HEAD></HEAD><BODY><P>User Preference can be set like:</P><P></P><P>set up&nbsp; = ActiveDocument.GetApplication.GetUserPreferences</P><P>&nbsp;&nbsp;&nbsp; up.UseSystemDateTime = true</P><P>&nbsp;&nbsp;&nbsp; up.DateTimeFormat = "YY-MM-DD"</P><P>&nbsp;&nbsp;&nbsp; ActiveDocument.GetApplication.SetUserPreferences up</P></BODY></HTML> Thu, 19 Sep 2013 10:00:50 GMT https://community.qlik.com/t5/QlikView/Help-MACRO/m-p/540923#M1138108 tresB 2013-09-19T10:00:50Z Re: Help MACRO https://community.qlik.com/t5/QlikView/Help-MACRO/m-p/540924#M1138109 <HTML><HEAD></HEAD><BODY><P>Sorry for&nbsp; insufficient information.</P><P></P><P>I want to change the regional setttings date format of my Machine and not of the Qlikview App</P><P></P><P>Thanx</P></BODY></HTML> Thu, 19 Sep 2013 10:11:22 GMT https://community.qlik.com/t5/QlikView/Help-MACRO/m-p/540924#M1138109 2013-09-19T10:11:22Z Re: Help MACRO https://community.qlik.com/t5/QlikView/Help-MACRO/m-p/540925#M1138110 <HTML><HEAD></HEAD><BODY><P>May be like this?</P><P></P><P>Set WSHShell = CreateObject("Wscript.Shell")</P><P>WSHShell.Run "CMD.EXE /C DATE 12/10/2013"</P></BODY></HTML> Thu, 19 Sep 2013 11:34:02 GMT https://community.qlik.com/t5/QlikView/Help-MACRO/m-p/540925#M1138110 tresB 2013-09-19T11:34:02Z