Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
CLosing Linked datatable
I have a report template that saves a report twice; a 'DatedReport 20070227'
and a 'LastReport'. I created a 'LastDate' table in the LastReport report that is refered to in the template (it is in a small data query). So when the template runs it updates the datatable linked to the LastReport.LastDate, but now I want to save the report. The file will save as DatedReport 20070227 just fine, but it will not allow me to overwrite the LastReport saying #70: Access Denied. I think the link from the tempolate to the LastReport is still open. Q- How do I close the connection to the LastReport so I can overwrite the file? Thanks so much for you help. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
CLosing Linked datatable
I found the answer using :
Sheets("Corrective Action Record").QueryTables("Latest_Report").Delete "Candyman" wrote: I have a report template that saves a report twice; a 'DatedReport 20070227' and a 'LastReport'. I created a 'LastDate' table in the LastReport report that is refered to in the template (it is in a small data query). So when the template runs it updates the datatable linked to the LastReport.LastDate, but now I want to save the report. The file will save as DatedReport 20070227 just fine, but it will not allow me to overwrite the LastReport saying #70: Access Denied. I think the link from the tempolate to the LastReport is still open. Q- How do I close the connection to the LastReport so I can overwrite the file? Thanks so much for you help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Chart's DataTable | Charts and Charting in Excel | |||
CHARTS DATATABLE | Excel Programming | |||
how to delete row from the runtime Datatable | Excel Programming | |||
Excel into DataTable using OleDbDataAdapter | Excel Programming | |||
DataTable number format | Excel Programming |