PDA

View Full Version : vbe and excel date settings



domfrance
02-18-2007, 07:04 PM
Hello,
I created a workbook and included a vb parameter to refresh automatically some sheets to auto refresh when selected. On one of these sheet, a pivot table was here, sorted by months/days ... if I group by months/days and I refresh the sheet only by excel ( without the vb parameter ), my date format s are dd - mmm with uk settings. But if I refresh the same sheet by activating this vb parameter, my date format become US : dd - mmm with just one digit for the first days ( ex: 02 - feb will become 2 - feb ) and the field are not sorted properly anymore ... I hope I was clear....
I am sure that the excel settings are correct, but not the VBe default setting

Does anyone could tell me what to do, so that Excel and VB will use the same settings ?

( by the way, Excel + Windows settings have the same values, but I don't know for Vb )

Please help me!