Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Break link between excel and access
Hi, I have an excel template that is linked to an access query. When the template is opened, it automatically downloads the latest data from the access query. Using code, I am then saving the template as a unique excel spreadsheet. The problem is that the link is still active between the new spreadsheet and access. So, when I open the newly saved spreadsheet, it automatically downloads the latest data from the access query. How can I save the template as a unique spreadsheet - and have the link broken? In other words, how can I have the new spreadsheet contain the template's data only, so it never grabs the access data again? -- Smithochris ------------------------------------------------------------------------ Smithochris's Profile: http://www.excelforum.com/member.php...o&userid=17004 View this thread: http://www.excelforum.com/showthread...hreadid=498729 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Break link between excel and access
QueryTable.Delete deletes the querytable (but keeps the values) and thus
should "break the link." -- - K Dales "Smithochris" wrote: Hi, I have an excel template that is linked to an access query. When the template is opened, it automatically downloads the latest data from the access query. Using code, I am then saving the template as a unique excel spreadsheet. The problem is that the link is still active between the new spreadsheet and access. So, when I open the newly saved spreadsheet, it automatically downloads the latest data from the access query. How can I save the template as a unique spreadsheet - and have the link broken? In other words, how can I have the new spreadsheet contain the template's data only, so it never grabs the access data again? -- Smithochris ------------------------------------------------------------------------ Smithochris's Profile: http://www.excelforum.com/member.php...o&userid=17004 View this thread: http://www.excelforum.com/showthread...hreadid=498729 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do break the link from my excel workbook to a access database. | Excel Discussion (Misc queries) | |||
break a link in excel 2003 | Excel Discussion (Misc queries) | |||
Break link MS Excel 2000 | Excel Discussion (Misc queries) | |||
How do i break a link to another excel workbook? | New Users to Excel | |||
Can I break an external link in Excel 97? | Excel Discussion (Misc queries) |