Save to a CSV file and close that file

Matthew · Apr 17th, 2002, 06:35 AM

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.

Iain Lewis · Apr 17th, 2002, 06:45 AM

Have you tried putting the macro in your personal.xls file & running it from there ?

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 17th, 2002, 06:35 AM	#1
Matthew New Member Join Date: Apr 2002 Location: Matthew Posts: 23	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.

Apr 17th, 2002, 06:45 AM	#2
Iain Lewis Board Regular Join Date: Apr 2002 Location: Midlands, UK Posts: 217	Have you tried putting the macro in your personal.xls file & running it from there ?