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 . 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
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 . 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