Remove "Refresh external data" from template
 

Hi,

I created an Excel Template for storing macros related to importing a
CVS Text file and creating a chart as per my requirements.

Now that I have debuged the macros to the point I want to use them, I
saved my workbook as an Excel template file.

When I do a Save As..., Excel complains that my template contains
external data and wants to clear it and reload them each time the
template is opened.

I know this is caused by my debugging sessions I loaded a lot of
external data to do this.

I would like to remove these references to external data so that when
Excel opens up it does not prompt me to update data.

Is there a way to do this?

Regards,

--
Stefan Robert
(to email: remove the numbers)

Remove "Refresh external data" from template
 

possibly

for each sh in thisworkbook.worksheets
for each qtbl in sh.querytables
qtbl.delete
Next
Next

--
Regards,
Tom Ogilvy

"Stéfan Robert" a wrote in
message
news:2005082308593016807%s12robert3@skipthisandnum bers4usherbrooke56ca...
Hi,

I created an Excel Template for storing macros related to importing a
CVS Text file and creating a chart as per my requirements.

Now that I have debuged the macros to the point I want to use them, I
saved my workbook as an Excel template file.

When I do a Save As..., Excel complains that my template contains
external data and wants to clear it and reload them each time the
template is opened.

I know this is caused by my debugging sessions I loaded a lot of
external data to do this.

I would like to remove these references to external data so that when
Excel opens up it does not prompt me to update data.

Is there a way to do this?

Regards,

--
Stefan Robert
(to email: remove the numbers)