Jump to content

Excel / COM problems? / Error: Variable must be of type "Object"


Recommended Posts

Hello

I have prepared a script which works fine on my XP + Office 2007.

However the script will be used on Server 2008 + Office 2003.

The script below is just to show you the problem:

#include <WinAPI.au3>

$oExcel = ObjCreate("Excel.Application")

$oExcel.WorkBooks.Open("rz.xls")

It works on my local machine but fails on Server 2008 + Office 2003.

The message is:

Error: Variable must be of type "Object"

The file of course exists and is accessible.

I believe it has something to do with COM.

Please help me!

thanks,

Jarek

EDIT: I do not know what have I done but suddenly this script stopped working on my local machine (XP + Office 2007).

The error message is different:

The requested action with this object has failed

Edited by jarek
Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...