| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VB coding
I need to create a macro that opens an excel file, will click on "enable
automatic refresh," process the webqueries, and than save and close the file. The issue with the recording of the macro is that it will open the file however it will not recognize the query refresh option. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
VB coding
try something like
for each q in thisworkbook.querytables q.refresh next q -- Don Guillett SalesAid Software "ndn14" wrote in message ... I need to create a macro that opens an excel file, will click on "enable automatic refresh," process the webqueries, and than save and close the file. The issue with the recording of the macro is that it will open the file however it will not recognize the query refresh option. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Coding | Excel Discussion (Misc queries) | |||
| "=ROW()-1" type of coding doesn't appear in a filter / is there coding that does? | Excel Programming | |||
| Implant macro coding into ASP coding | Excel Programming | |||
| Need coding help. | Excel Programming | |||
| VBA coding | Excel Programming | |||
Hybrid Mode
