Ms-Query stopping

[Steve M]

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

[Tom Ogilvy]

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
>
>