Hello,
I have a file with multiple tables in powerpivot and I've set up a system with macros that send automatically PDFs to email recipients.
What I've not been able to do at the moment are two important steps that could help
me save more time.
1. I've created a task which opens the file in Win8 Task Scheduler. If I open the file in Excel this way, the process runs in the background and I'm not able to see the file and progress of refresh. Is there a way to show the opened file?
2. The problem that I have is when I schedule that 120 seconds after I've opened the file,
macro runs the "refresh all" command in powerpivot ( active model refresh VBA macro cmd). The command starts the refresh, but the refresh of data runs in loop. So, I'm not able to stop it. Since I'm not able to stop it, I'm also not able to set up that i.e. 15 mins after the file has been opened, I run other set of macro commands that would send the refreshed data as PDFs to my email account.
I'd really appreciate if someone could take a look what can be done with this VBA situation that I have.
Many thanks.
I have a file with multiple tables in powerpivot and I've set up a system with macros that send automatically PDFs to email recipients.
What I've not been able to do at the moment are two important steps that could help
me save more time.
1. I've created a task which opens the file in Win8 Task Scheduler. If I open the file in Excel this way, the process runs in the background and I'm not able to see the file and progress of refresh. Is there a way to show the opened file?
2. The problem that I have is when I schedule that 120 seconds after I've opened the file,
macro runs the "refresh all" command in powerpivot ( active model refresh VBA macro cmd). The command starts the refresh, but the refresh of data runs in loop. So, I'm not able to stop it. Since I'm not able to stop it, I'm also not able to set up that i.e. 15 mins after the file has been opened, I run other set of macro commands that would send the refreshed data as PDFs to my email account.
I'd really appreciate if someone could take a look what can be done with this VBA situation that I have.
Many thanks.
