Query

D

dantb

Active Member
Joined
Mar 20, 2002
Messages
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 ?
 

Excel Facts

Lock one reference in a formula
Need 1 part of a formula to always point to the same range? use $ signs: $V$2:$Z$99 will always point to V2:Z99, even after copying
Sort by date Sort by votes
All three are in one sheet? Each has their own sheet?
 
Upvote 0
You must log in or register to reply here.

Similar threads

M
  • Question
Ideas Power Query and/or Python?
Replies
8
Views
81
mickeystanford_alumni
M
M
  • Question
Getting Power Query data to an Excel worksheet
Replies
4
Views
207
MichaelMorris
M
T
  • Question
Web query basics
2
Replies
13
Views
195
Domenic
D
J
  • Question
Xlookup with multiple unique values (attached)
Replies
1
Views
158
Fluff
Fluff
itsgrady
  • Question
VBA - to update a cell when a query is ran.
Replies
2
Views
161
itsgrady
itsgrady

Forum statistics

Threads
1,215,067
Messages
6,122,949
Members
449,095
Latest member
nmaske

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top