External Data Updates

G

Guest

I have an excel template which pulls some data from my SQL server when
opened. I need to set it so that it only pulls up the data when first opened
from a template, but not after being saved as an xls file.

Any ideas?
 
G

Guest

Thanks for your help - I'm still not sure how to do it though.
Does that get pasted in verbatim? and where exactly do i put it?

The code that i use to populate the tables is in a module - i don't program
with excel very often, so i don't really know where every thing goes.
 
G

Guest

Now i only need to know where to put it.

Thanks for your help - I'm still not sure how to do it though.
Does that get pasted in verbatim? and where exactly do i put it?

The code that i use to populate the tables is in a module - i don't program
with excel very often, so i don't really know where every thing goes.
Click to expand...
 
T

Tom Ogilvy

I would guess either in the open event of the template - you would have to
include code to do the query with backgroundrefresh set to false, the code I
gave you to delete the query table on that sheet (this all assumes you are
using a querytable). Then possibly save the template as a workbook with a
new name.

http://www.cpearson.com/excel/events.htm
 
Top