-
vbe and excel date settings
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!
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules