How to change the date format yyyy/mm/dd to dd/mm/yyyy in below code?

In India we are using the date format as dd/mm/yyyy (United Kingdom). By default short date is mm/dd/yyyy (United State). How to change the short date format though VBA code in ms excel. Kindly help me. Dhandapani

QUESTION: Expert Mr. Tom Ogilvy refered me to you. I have following code to copy range and paste inand bring to Outlook. Could you advice the same in MS Word(If you can make copy -Paste special-Bitmap it would be better). I would really appreciate if...

Hi Having a bit of a problem with printing with Excel. I have itemised the area on the worksheet I want to print and it is a single page. When I print the page and also when Preview the page it only prints or displays the top 2/3 of the required info...

<?php if (!isset($_SESSION)) {   session_start();   } ?> <?php require_once('../Connections/QUIZ.php'); ?> <!---------------------------------extra new  update coding---------------------------------------------------------------...

QUESTION: Feels good to get back to you with another question :-). Here is the scenario. I have two sheets, One is called 'Old Data' and another one is called 'New Data'. What I was looking for is that the code needs to check the rows in sheet 'Old Data...

I have the following code in access 2010 and I want to add in the format for time. Here is what I have which works perfectly but I need a time format with the date. DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel12Xml, "DMV WEB DATA"...

I have a blog and would like to add a "Random Post" button. I'm hosted with a company called Blogware which, unlike Blogger and WordPress, seems to have no no way to add a "random post" button. I'm not a programmer but suspect this...

QUESTION: A very good morning to you Sir. I am using2007. In a workbook I am entering data in row 3 from A3: Y3 onwards (about 600 rows approx) in the 1st sheet named Master Sheet. My subsequent sheets are named e.g. (25-Jul-10, 26-Jul-10 etc) (same...

In the minds of many confused people, a single-celled human zygote,  which has no nerves and cannot suffer, is infinitely sacred, simply  because it is 'human'. Changing what it means to remember changes what it means to be. New studies show that these...