I'm running an MS-Query to populate my spreadsheet from 2 DBF files -
have a macro that formats the data afterwards

I want the date to go from dd-mm-yyyy to yyyy-mm-dd but Ms-Query won'
allow this to happen

So presently I am needing to save the file as a CSV and shutting dow
excel and reopening to stop the query then running the macro - is ther
any VBA Icould use to resolve this problem?

Any help appreciated
Stev

--
Steve
-----------------------------------------------------------------------
Steve M's Profile: http://www.excelforum.com/member.php...fo&userid=3252
View this thread: http://www.excelforum.com/showthread.php?threadid=52428