I have a database query that is refreshing every 5 minutes. What I need to
do is to save that file as a csv so that I can import the file into our
shipping software.

When I try and record a macro to "save as" and select csv, the csv file is
created but it closes out the xls and the macro that was being recorded and
the only thing that is open is the csv. So that stops my progress right
there. Being a newbie to the macro world I am having problems writing this
myself.

What I need is to have the csv created while keeping the macro open to run
every 5 minutes as well, thus updating the csv file. Is there an easier way
to accomplish what I am trying to do?

CSV files can't contain code. I think what you need to do is use
SaveCopyAs to create a copy on disk of your workbook, open that
workbook, then save that workbook as CSV. It would be simpler if
you took the code out of your original workbook and put it in a
separate workbook or add-in.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com




"Rick Deemer" wrote in message
...
I have a database query that is refreshing every 5 minutes.
What I need to
do is to save that file as a csv so that I can import the file
into our
shipping software.

When I try and record a macro to "save as" and select csv, the
csv file is
created but it closes out the xls and the macro that was being
recorded and
the only thing that is open is the csv. So that stops my
progress right
there. Being a newbie to the macro world I am having problems
writing this
myself.

What I need is to have the csv created while keeping the macro
open to run
every 5 minutes as well, thus updating the csv file. Is there
an easier way
to accomplish what I am trying to do?

Rick:

I did this on the Recorder:

Sub Macro1()
ActiveWorkbook.SaveAs Filename:="C:\Book1.csv", FileFormat:=xlCSV, _
CreateBackup:=False
ActiveWorkbook.SaveAs Filename:="C:\Book1.xls", FileFormat:=xlNormal, _
Password:="", WriteResPassword:="", ReadOnlyRecommended:=False, _
CreateBackup:=False
End Sub

Running it leaves the file open and in .xls mode.
--
Gary''s Student


"Rick Deemer" wrote:

I have a database query that is refreshing every 5 minutes. What I need to
do is to save that file as a csv so that I can import the file into our
shipping software.

When I try and record a macro to "save as" and select csv, the csv file is
created but it closes out the xls and the macro that was being recorded and
the only thing that is open is the csv. So that stops my progress right
there. Being a newbie to the macro world I am having problems writing this
myself.

What I need is to have the csv created while keeping the macro open to run
every 5 minutes as well, thus updating the csv file. Is there an easier way
to accomplish what I am trying to do?