Advanced Analisys (Excel) problem with refresh

Good day.

I would like to use (business requirements) Advanced Analisys (Excel) instead of BEx Analyzer.

I have BEx query. I have created Advanced Analisys (AA) workbook on this query.

But I have the problems with refresh and VBA.

- How to tune AA to refresh workbook automatically then I open it?

- Where I should insert VBA-code to run automatically on refresh?

Is it possible?