Hi All,
I have a connection which is web query. I want to use macro to refresh the connection. after refresh, I want to process other code.
Would you help to revise me an idea to do that? Thanks.
let say,
Please Login or Register to view this content.
Last edited by JBeaucaire; 01-07-2015 at 12:09 PM. Reason: Added missing CODE tags. Please read and follow the Forum Rules, link above in the menu bar. Thanks.
Try inserting a line of code:
Please Login or Register to view this content.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
Hi Jerry,Originally Posted by JBeaucaire
Still not ok.
I run the above code. I get a "ok" message before the connection refresh.Please Login or Register to view this content.
Then the trick will be to insure the BackGroundQuery=False parameter is set in your actual connection. Can you edit your original connections to set that?
If not, maybe you can adapt something like this:
Please Login or Register to view this content.
Thank you Jerry. Now is ok.
Then the trick will be to insure the BackGroundQuery=False parameter is set in your actual connection. Can you edit your original connections to set that?
If not, maybe you can adapt something like this:
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks