Can anyone help me, I am running a macro that run's an odbc query and then saves the file in CSV format, this then loops for a set number of time at a set time period. My problem is that I need to close this file, i.e. the CSV file (so another programme can use it) and continue running the macro. When I use the close command the macro stops running.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
Save to a CSV file and close that file
- Thread starter Matthew
- Start date
Excel Facts
Which Excel functions can ignore hidden rows?
The SUBTOTAL and AGGREGATE functions ignore hidden rows. AGGREGATE can also exclude error cells and more.
Similar threads
- Replies
- 1
- Views
- 64
- Replies
- 2
- Views
- 318
- Replies
- 1
- Views
- 861
- Replies
- 2
- Views
- 193
