External Data Updates

[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?

 

[Tom Ogilvy]

ActiveSheet.QueryTables(1).Delete

after you refresh the data.

 

[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.

 

[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.

 

[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