Making excel wait till query done
Results 1 to 1 of 1

Thread: Making excel wait till query done

Threaded View

  1. #1
    Senior Member mungyun's Avatar
    Join Date
    Apr 2004
    Location
    Illinois
    Posts
    172

    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 08: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

  1. Creating an Excel query...
    By RebelToTheEnd in forum General Computer Discussions
    Replies: 0
    Last Post: January 11th, 2005, 03:01 PM
  2. Secure Spreadsheets
    By IcSilk in forum Newbie Security Questions
    Replies: 7
    Last Post: July 5th, 2004, 09:23 PM
  3. Foot Printing with Host
    By SonofGalen in forum The Security Tutorials Forum
    Replies: 7
    Last Post: February 9th, 2004, 11:14 AM
  4. Tcp/ip
    By gore in forum Newbie Security Questions
    Replies: 11
    Last Post: December 29th, 2003, 08:01 AM
  5. Explore ways to pass a Microsoft Excel file to the client side
    By NullDevice in forum Programming Security
    Replies: 2
    Last Post: October 15th, 2003, 10: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
  •