Querytable in Excel

[csjoseph]

I have a querytable that I'm trying to put on an excel sheet and then format the spreadsheet. But the formatting happens first then the table shows up. My coding goes like this.

Click Display

Call procedure to get data via ODBC
return to Click Display

call procedure to format table.

But everytime the formatting is done before the data is posted to my spreadsheet.

Help me, what am I missing.

 

[Dreamboat]

I'm not a coder, but I sometimes get these anyway. Try one of these:

...Save the document after getting the data?

...Save it, move it into another file that has the formatting code and run that?

It's probably something to do with the way Excel fires the events; obviously something in your code isn't firing an event that you expect to fire? Just some thoughts until one of our resident coders arrives.
techsupportgirl@home.com
Brainbench MVP for Microsoft Word

http://www.brainbench.com

 

[csjoseph]

Actually it was the background refresh setting. I set it the false and then the procedure must finish before returning execution to the program

 

[Dreamboat]

Ouch. But it's fixed now, right? Cool beans.
techsupportgirl@home.com
Brainbench MVP for Microsoft Word

http://www.brainbench.com