Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
ONe Macro won't call another
Hi All.........
I'm having a heck of a time with Excel97,SR2. I have a macro which runs a MSQuery and returns data to my Excel sheet from an outside database. It works fine when run by itself. I have another macro which runs a Pivot Table on that data. It works fine when run by itself. When I try to call the second macro from the first, I get error message "Run time error '1004', AddFields method of Pivot Table class failed". Yet each macro will run individually and the whole thing will run if stepped through from the beginning by hand. This combination of macros is for retrieving Materials Data. I have another pair, very nearly the same which retireve Labor Data and they run together just fine. I've tried changing the name of the called macro, and using both "Call PivotMaterials" and "Application.run "PivotMaterials"".....no difference. Any help would be much appreciated... Vaya con Dios, Chuck, CABGx3 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can run a macro ( call a macro) on selection of any filtercriteria? | Excel Worksheet Functions | |||
Call an Access macro from an Excel macro | Excel Discussion (Misc queries) | |||
Excel Macro call Word Macro with Parameters | Excel Programming | |||
macro call | Excel Discussion (Misc queries) | |||
Call another Macro | Excel Programming |