-
October 22nd, 2008, 07:46 PM
#1
Making excel wait till query done
Hey all, got a quick question.
Im working on some vba stuff in excel and i have a query that runs and after, i build headers and footers based on the data returned. The problem im having is it doesnt seem that vba is waiting for the data to be returned before continuing. On some of the reports with only a few rows returned, the headers and footers are fine but on ones that take a while, the headers and footers are put in and when the data comes back it bumps the header and footer over to fit the data in.
Ive tried changing the .BackgroundQuery and .Refresh BackgroundQuery to false but those dont seem to fix it.. I could potentially just put a pause or something but i dont want the pause too long or too short so i would like to avoid that if possible.
Anyone have an idea?
Matt
Last edited by mungyun; October 22nd, 2008 at 07:54 PM.
I believe in making the world safe for our children, but not our children’s children, because I don’t think children should be having sex. -- Jack Handey
Similar Threads
-
By RebelToTheEnd in forum General Computer Discussions
Replies: 0
Last Post: January 11th, 2005, 03:01 PM
-
By IcSilk in forum Newbie Security Questions
Replies: 7
Last Post: July 5th, 2004, 08:23 PM
-
By SonofGalen in forum The Security Tutorials Forum
Replies: 7
Last Post: February 9th, 2004, 11:14 AM
-
By gore in forum Newbie Security Questions
Replies: 11
Last Post: December 29th, 2003, 08:01 AM
-
By NullDevice in forum Programming Security
Replies: 2
Last Post: October 15th, 2003, 09:06 PM
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|