| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how do you break the link with MS Query - Database via code
Hi
i have a spreadsheet that draws information from an access database and then is "saved as" a new workbook - i would like to (programmatically) break the link (ie untick save query definition) after the save as. I've done a google search and found a post by Tom Ogilvy that mentions a code solution but i couldn't find it anywhere. if this is not possible any other "workarounds"? Thanks. Cheers JulieD |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
how do you break the link with MS Query - Database via code
Hi JulieD;
Right click somewhere in the returned range and select Data Range Properties. You will find the options there to turn it off. Thanks, Greg -----Original Message----- Hi i have a spreadsheet that draws information from an access database and then is "saved as" a new workbook - i would like to (programmatically) break the link (ie untick save query definition) after the save as. I've done a google search and found a post by Tom Ogilvy that mentions a code solution but i couldn't find it anywhere. if this is not possible any other "workarounds"? Thanks. Cheers JulieD . |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
how do you break the link with MS Query - Database via code
Activesheet.QueryTables(1).Delete
will delete the querytable definition, but leave the data. It seems that is what you want. -- Regards, Tom Ogilvy "JulieD" wrote in message ... Hi i have a spreadsheet that draws information from an access database and then is "saved as" a new workbook - i would like to (programmatically) break the link (ie untick save query definition) after the save as. I've done a google search and found a post by Tom Ogilvy that mentions a code solution but i couldn't find it anywhere. if this is not possible any other "workarounds"? Thanks. Cheers JulieD |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
how do you break the link with MS Query - Database via code
Hi Tom
thanks - perfect - just what i was after. Cheers JulieD "Tom Ogilvy" wrote in message ... Activesheet.QueryTables(1).Delete will delete the querytable definition, but leave the data. It seems that is what you want. -- Regards, Tom Ogilvy "JulieD" wrote in message ... Hi i have a spreadsheet that draws information from an access database and then is "saved as" a new workbook - i would like to (programmatically) break the link (ie untick save query definition) after the save as. I've done a google search and found a post by Tom Ogilvy that mentions a code solution but i couldn't find it anywhere. if this is not possible any other "workarounds"? Thanks. Cheers JulieD |
| 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) | |||
| database query not showing foxpro database How I import data | New Users to Excel | |||
| Moved database, how do I change link to the database in excel | Excel Discussion (Misc queries) | |||
| Anyone Else Use Database Query to Query Another Sheet in the Same Excel Workbook? | Excel Discussion (Misc queries) | |||
| Anyone Else Use Database Query to Query Another Sheet in the Same Excel Workbook? | Excel Discussion (Misc queries) | |||
Linear Mode
