Could not load automation class "Excel.Application" - VBScript Move Mouse

Question

I'm using the code from my previous question : Move Mouse - VBScript and Excel Macro

My aim is to move the mouse using VBScript and this works through using Excel. The problem is, this runs fine on my home machine, which has Office 2007 on.

However, when running this script at work, I get the following error:

"Could not locate automation class named "Excel.Application""

The only difference I can see that these work computers have is that they have Office 2003 installed instead, so Excel.Aplacation needs to be changed to something else maybe?

Google yielded no useful results. I'm creating this in notepad. Can someone help? If I can get this working it's be pretty amazing.

Your code worked fine on my Excel 2003, so that isn't the issue. — Jean-François Corbett
– Jean-François Corbett, Commented Jul 11, 2011 at 20:13
After a bit of rooting, it MIGHT be the case that the Office Suite is installed on the server. How would I go about performing the same thing I want to, with limited access to administrative settings, if Excel is installed on the server? Citrix I think... — Jimbo
– Jimbo, Commented Jul 12, 2011 at 14:31

Jimbo · Accepted Answer · 2012-10-18 15:59:38Z

0

This is because Excel cannot be referenced correctly on a Citrix environment.

A local copy of excel is most likely needed to reference this from the client hard drive (as it's actually referencing the server's installation on Citrix).

answered Oct 18, 2012 at 15:59

Jimbo

26.7k16 gold badges93 silver badges135 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Could not load automation class "Excel.Application" - VBScript Move Mouse

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related