Strange Issue: Screenshots being pasted in Excel!

General Macro Scheduler discussion

Moderators: JRL, Dorian (MJT support)

Post Reply
Sosa
Newbie
Posts: 1
Joined: Mon Nov 10, 2008 8:33 pm

Strange Issue: Screenshots being pasted in Excel!

Post by Sosa » Mon Nov 10, 2008 8:39 pm

Hello,

I have been using Macro Scheduler to automate the running of MicroStrategy Desktop (a BI tool) reports. Basically, I press enter, wait for the window to change (report completes), close the window. Then I press down and enter again to run the next report (and loop through this till the end).

Now, MicroStrategy automatically exports these reports to Excel after they are run. For some strange reason, when running them using Macro Scheduler, the Excel file contains a screenshot of my system rather than the report data!

Could it be that MicroStrategy is using the clipboard to copy and then paste to Excel, but Macro Scheduler is overwritting the clipboard with screen shots of my system? If so, is there any way to stop Macro Scheduler from interfering with my clipboard?

Thank you.

User avatar
Marcus Tettmar
Site Admin
Posts: 7395
Joined: Thu Sep 19, 2002 3:00 pm
Location: Dorset, UK
Contact:

Post by Marcus Tettmar » Mon Nov 10, 2008 8:59 pm

Macro Scheduler itself does not take screenshots and does nothing to the clipboard. I cannot vouch for what your script is doing however. Feel free to post your script.
Marcus Tettmar
http://mjtnet.com/blog/ | http://twitter.com/marcustettmar

Did you know we are now offering affordable monthly subscriptions for Macro Scheduler Standard?

Post Reply
Sign up to our newsletter for free automation tips, tricks & discounts