Posted to microsoft.public.excel.programming

Tachikrusher Tachikrusher is offline

external usenet poster

Posts: 1

Do I have to close an odc in a macro?

I have set up a macro in Excel that imports Access queries. The number of
queries the macro imports varies depending upon the number of changes showing
on the summary tab in my workbook. For each change, there are 3 queries that
run and I have an odc for each query. After the query is run, does the odc
have to be "closed"? I get an error if there are several changes on my
summary sheet.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Run Macro on close	Donnie	Excel Programming	6	August 29th 05 09:42 PM
On Close macro	JudithJubilee[_2_]	Excel Programming	14	March 8th 05 09:40 AM
Close Workbook from Macro	Lou	Excel Programming	2	May 18th 04 02:26 AM
Macro Close 2	Ronbo	Excel Programming	1	May 5th 04 10:11 PM
Close Macro	Ronbo	Excel Programming	1	May 5th 04 08:33 PM

All times are GMT +1. The time now is 02:22 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us