Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Macro
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
macro with F9 | Excel Discussion (Misc queries) | |||
Make Alignment options under format cells available as shortcut | Excel Discussion (Misc queries) | |||
Help with macro looping and color query function | Excel Discussion (Misc queries) | |||
Playing a macro from another workbook | Excel Discussion (Misc queries) | |||
Date macro | Excel Discussion (Misc queries) |