| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to Uncheck Save Query Definition
Would like a macro to remove the external data properties on a copied
worksheet. The goal is to make the data static. I have tried using the macro recorder but this does not record the process/task. Does anyone have any suggestions? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Macro to Uncheck Save Query Definition
activesheet.querytables(1).Delete
this would leave the data. -- Regards, Tom Ogilvy "NYbills" wrote: Would like a macro to remove the external data properties on a copied worksheet. The goal is to make the data static. I have tried using the macro recorder but this does not record the process/task. Does anyone have any suggestions? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Removing Query Definition | Excel Discussion (Misc queries) | |||
| lost query definition | Excel Discussion (Misc queries) | |||
| DISABLE "SAVE QUERY DEFINITION" | Excel Programming | |||
| Remove Query Definition with Macro or VBA | Excel Programming | |||
| disable save query definition in VBA sorry repost | Excel Programming | |||
Linear Mode
