Question:
hi all!
I'm facing a problem that I thought it won't happened!
I have a hierarchy displayed in my query and for each node I have a result.
I made a macro that for each time that the query is refreshed add two lines before the Result line. This is for add formula excel data, like average results and comparison values.
But for my surprise these values aren't stored for each time that the query is refreshed.
It only keep excel formulas after a refreshing when these formulas are write outside for the query space.
Now, my question is how to store the excel formulas inside the space query?
Thank you,
Marta.
Answer:
The macro is stored into the workbook (Excel file). If you don't store the workbook, it of course will never work !
But, can't you make the calculation in the query ?
If you want, just copy the complete VB code you created, to have a look.
_________________
When my car stops, I first look at the gasoline's level before dismounting the engine.
Tuly Idiot's fan club active member.
Answer:
Fred is right:
1. you have to save the query as a workbook
2. don't mess in the query area!
3. try to do the calculations in the query (unfortunately this is not always possible )