Hi,

for some reason when I run my macro today the dates in my file appear as 08/07/2012 when I open via the following VBA statement:

sub tmp

dim wbBalance as workbook
dim sBalancename as string

sBalanceName = "C:\temp\Balance.csv"
Set wbBalance = Workbooks.Open(sBalanceName)

end sub

However, if I open manually in Excel the dates appear as 07/08/2012. How can I solve this problem?

regards
Colm