Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Nov 2001
    Thanked 0 Times in 0 Posts

    Import from Access (2003)

    I execute a query via code in Excel, which updates a list from Access. I then reformat the columns and rows because the update changes them all.

    1. Is there any way to prevent the update from affecting my column widths and row sizes?
    2. How can I tell my code to wait until the query has been executed before reformatting my spreadsheet?

    Thanks again

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Thanked 31 Times in 31 Posts

    Re: Import from Access (2003)

    1) Click the Data Range Properties button on the External Data toolbar and clear the 'Adjust column width' check box (see screenshot). Don't know about row heights.

    2) Does it help if you set the BackgroundQuery property of the query to False?
    Attached Images Attached Images
    • File Type: png x.PNG (18.8 KB, 0 views)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts