Variable must be of type "Object"

[gdzeek]

Hi everyone

I have a teeny bit of experience using Java and c programming, but Im pretty much brand new to using Autoit, been going through tutorials getting myself up to speed

At the moment though I am tasked with troubleshooting a code that was written by someone else, it was working just fine until we upgraded our computers from Windows 7 to windows 10,  I believe we upgraded to a newer version of Microsoft office as well, we now have Excel 16 installed.

I attached the error code window and a screenshot of the code being a trouble maker below

Error: Variable must be of type object

The program itself is setup up to copy information that was inputted into a spreadsheet and plug it in to another program for the purpose of generating serial numbers, and then output those serial numbers to a notepad file.  as far as I can tell Autoit cant detect Microsoft excel or atleast has the wrong commands to utilize it (potential updates with new terminology on excel's side)?), or if it is detecting it the commands are failing to bring it forward and access the workbook tab it needs. any help or input is appreciated <3

Edit:  Im currently reading through this: https://www.autoitscript.com/autoit3/docs/functions/ObjCreate.htm

Edit2:  Solved,  The program couldn't access the file location or didn't have read/write priveleges enabled for that server

 

Edited November 28, 2018 by gdzeek
progress and typos

[mLipok]

Reading HelpFile in example for ObjGet:

#include <MsgBoxConstants.au3>

; Example getting an Object using it's class name
; ; Excel must be activated for this example to be successful

Example()

Func Example()
    Local $oExcel = ObjGet("", "Excel.Application") ; Get an existing Excel Object

    If @error Then
        MsgBox($MB_SYSTEMMODAL, "", "Excel File Test" & @CRLF & "Error Getting an active Excel Object. Error code: " & Hex(@error, 8))
        Return False
    EndIf

    $oExcel.Visible = 1 ; Let the guy show himself
    $oExcel.workbooks.add ; Add a new workbook
EndFunc   ;==>Example

there is @error checking.

You should do the same.

btw.

to AutoIt forum.

 

Edited November 28, 2018 by mLipok

[gdzeek]

3 minutes ago, mLipok said:

Reading HelpFile in example for ObjGet:

#include <MsgBoxConstants.au3>

; Example getting an Object using it's class name
; ; Excel must be activated for this example to be successful

Example()

Func Example()
    Local $oExcel = ObjGet("", "Excel.Application") ; Get an existing Excel Object

    If @error Then
        MsgBox($MB_SYSTEMMODAL, "", "Excel File Test" & @CRLF & "Error Getting an active Excel Object. Error code: " & Hex(@error, 8))
        Return False
    EndIf

    $oExcel.Visible = 1 ; Let the guy show himself
    $oExcel.workbooks.add ; Add a new workbook
EndFunc   ;==>Example

there is @error checking.

You should do the same.

btw.

to AutoIt forum.

 

Oh that is true, that will definitely give me more info
 

And thank you!

[water]

Welcome to AutoIt and the forum!

You know that AutoIt provides an Excel UDF?

[gdzeek]

23 minutes ago, water said:

Welcome to AutoIt and the forum!

You know that AutoIt provides an Excel UDF?

Thanks!

That would be handy!  especially if theres an old version too so I can see if anything changed. how do i access that?

[water]

You can find detailed information in the wiki and the help file (and scroll down to _Excel_BookAttach).

Edited November 28, 2018 by water

[gdzeek]

Well it was easier than I thought

I moved all the related documents the script needed to find and edit to my desktop temporarily and rerouted the pathway and its working just fine

so it must have been some kind of write permission error, or when the software was installed on the new machine it was never given read/write permissions to alter stuff on its own

I'll keep learning though, the program doesn't open the spreadsheet on its own so it might be fun to figure out how to do that instead of opening the spreadsheet to fullscreen before running the script. or at very least beef up its ability to report what the error actually is XD

Thank you for the help

Edited November 28, 2018 by gdzeek