Query

dantb · Mar 24th, 2002, 04:11 PM

Hi all. I have 3 Query's in a Excel file to external Dbase's. What I was interested in doing is having 3 buttons one for each dbase. Since all dbases would not be used all the time, I was hopeing this would save some load time on the program. Is this possable with some vba ?

Anne Troy · Mar 24th, 2002, 05:30 PM

All three are in one sheet? Each has their own sheet?

dantb · Mar 24th, 2002, 05:33 PM

All 3 databases are importing to different sheets.

Mar 24th, 2002, 05:30 PM	#2
Anne Troy MrExcel MVP Join Date: Feb 2002 Location: Allentown, PA Posts: 2,512	All three are in one sheet? Each has their own sheet? __________________ ~Anne Troy

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

Mar 24th, 2002, 04:11 PM	#1
dantb Board Regular Join Date: Mar 2002 Location: Arkansas Posts: 358	Hi all. I have 3 Query's in a Excel file to external Dbase's. What I was interested in doing is having 3 buttons one for each dbase. Since all dbases would not be used all the time, I was hopeing this would save some load time on the program. Is this possable with some vba ?

Mar 24th, 2002, 05:33 PM	#3
dantb Board Regular Join Date: Mar 2002 Location: Arkansas Posts: 358	All 3 databases are importing to different sheets.