Thread: Converting dates into xml file

Hi

I have a problem which I need help for. I have a macro (but I did not write it) which converts some data in a spreadsheet into and xml file. Amongst the data is some dates. On my machine and some other colleagues, when we inspect the xml file generated the date appears yyyy-mm-dd (even if the day of the month is single digit)

Now another colleague gets the same file (because it is stored on a LAN drive) but on his machine runs the same macro and when we inspect the xml file generated, where the day of the month is single digit the date appears as yyyy-mm-d, dropping off the 0.

We are both running the same version of excel and using the same file and macro which is a module within the workbook. Does anyone have any idea what may be causing this?

Thanks for looking/helping!

The Dang

Hi

Please post the macro code you are currently using. Possibly it has something to do with the default date format being used on your systems but it is very difficult to help further without seeing the code.

Richard