Updating Showcase Queries

S

simpleminds

New Member
Joined
Oct 11, 2006
Messages
6
Hi World

Im using a spreadsheet with several third-party add-in queries using Showcase. The trouble I'm having is in writing a macro that will automatically refresh the queries. Currently I am using the line "application.run ("refreshdata")" however this refreshes all the queries and at several points I only need to refresh one or two. If anyone has any suggestions then I'd be very gratefull.

Also I feel the need to confess that I pilfered the above code from another post on this site and so I dont actually know how it works :oops: . VBA help doesnt seem to have anything relevant to say and I'd feel better knowing what the code I'm using actually does.

Thanks
 

Excel Facts

Which lookup functions find a value equal or greater than the lookup value?
MATCH uses -1 to find larger value (lookup table must be sorted ZA). XLOOKUP uses 1 to find values greater and does not need to be sorted.
Sort by date Sort by votes
Sorry for the mistake. I have updated the relevant posts on other forums accordingly. Safe to say its now obvious why I choose the name SimpleMinds.
 
Upvote 0
Problem Solved

After some extensive trwling of the internet I managed to find a reference to the showcase online help that had the answers i needed. For anyone who's interested the macros available with the showcase add-in can be found in the Online help under Reference Information> Query Add-ins> Query add-in API References.
 
Upvote 0
You must log in or register to reply here.

Similar threads

H
  • Question
'How to' question about a Dashboard
Replies
5
Views
213
etaf
etaf
V
  • Solved
How to insert a row into a data sheet or worksheet and update the referenced cells in the other worksheets
2
Replies
14
Views
798
vladi305
V
R
  • Question
Adding Additional ActiveX Control From OCX File
Replies
6
Views
782
Dan_W
D
N
  • Question
Xlookup vs Power Query with Merge Queries?
Replies
1
Views
833
GraH
GraH
R
  • Question
Opinions on external query
Replies
1
Views
343
EFANYoutube
E

Forum statistics

Threads
1,214,991
Messages
6,122,628
Members
449,095
Latest member
bsb1122

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