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

first, make sure you have the Backgroundrefresh property set to false. If
that doesn't help, then You could delete the query. This should leave the
data on the worksheet and you could then reformat it.

--
Regards,
Tom Ogilvy




"Steve M" wrote:


I'm running an MS-Query to populate my spreadsheet from 2 DBF files - I
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't
allow this to happen

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

Any help appreciated
Steve


--
Steve M
------------------------------------------------------------------------
Steve M's Profile: http://www.excelforum.com/member.php...o&userid=32520
View this thread: http://www.excelforum.com/showthread...hreadid=524282