Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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) |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do you remove a "Template Help" hyperlink from appearing? | Excel Discussion (Misc queries) | |||
"Refresh" in Pivot reports after entering data | Excel Discussion (Misc queries) | |||
Automatic "data refresh" when XLS file is opened? | Excel Discussion (Misc queries) | |||
Excel Service error "cannot connect to external data source" | Excel Discussion (Misc queries) | |||
excel: external data "data range properties" button dosent work | Excel Programming |