Attaching Excel Sheet

[Indhu]

Hello people,
I'm trying to attach an excel sheet, with my script, so that I can have my excel sheet data into clipboard, from which I can use those in a seperate application. I started off like in the following code, but I keep on getting this error "The following variable name contains an illegal character: 'XL.Visible'. The program will exit."
When I tried to make that line as comment, I got another error, saying, "Call to non-existent function" at "ComObjCreate("Excel.Application")". If I try something else, I get an error again at my file path, saying "The leftmost character in the above expression is invalid". So what shall I do to make it work?

Thanks in advance

This is my script.

Code: Select all

Path := "%A_Desktop%\Data\Input.xlsx"
XL := ComObjCreate("Excel.Application")
XL.Workbooks.Open(Path)
XL.Visible := True

[Tigerlily]

Hello people,
I'm trying to attach an excel sheet, with my script, so that I can have my excel sheet data into clipboard, from which I can use those in a seperate application. I started off like in the following code, but I keep on getting this error "The following variable name contains an illegal character: 'XL.Visible'. The program will exit."
When I tried to make that line as comment, I got another error, saying, "Call to non-existent function" at "ComObjCreate("Excel.Application")". If I try something else, I get an error again at my file path, saying "The leftmost character in the above expression is invalid". So what shall I do to make it work?

Thanks in advance

This is my script.

Code: Select all

Path := "%A_Desktop%\Data\Input.xlsx"
XL := ComObjCreate("Excel.Application")
XL.Workbooks.Open(Path)
XL.Visible := True

You are combining Expression and Legacy Syntax (please read this AHK docs page). When using Excel COM, I would try to exclusively stick to Expression syntax, if possible.

try this:

Code: Select all

Path := A_Desktop "\Data\Input.xlsx"
XL := ComObjCreate("Excel.Application")
XL.Workbooks.Open(Path)
XL.Visible := True

[Indhu]

@Tigerlily

Hello TL, tried your way. Still the same error with file path, " The leftmost character above is illegal in an expression".

[gregster]

Please show your updated code that causes this error message.

[Indhu]

This was my code, after the above suggesstion

Code: Select all

Path := A_Desktop"\Data\Input.xlsx"
XL := ComObjCreate("Excel.Application")
XL.Workbooks.Open(Path)
XL.Visible := True

[AviationGuy]

Try adding a space after A_Desktop, works for me that way.
Good luck!

[Indhu]

Nope..Still shows 'XL.Visible' contains illegal character. @AviationGuy

[Kobaltauge]

The script is running here. My input.xlsx was an empty excel sheet. Probably there is a problem with the file. Replace it of a test.

[Indhu]

@Kobaltauge

The same error again . Is there any issue with 'XL.Visible'?

[Indhu]

This is the error message I get everytime
@Kobaltauge

ER.PNG (16.56 KiB) Viewed 2844 times

[gregster]

Perhaps you copy/pasted an invisible character from somewhere into your script. Try to delete the line and type it again by hand...

Edit: Which AHK version are you using (and which bitness? ANSI/Unicode?) ?

[AviationGuy]

Strange, it should work this way. Try @gregster's suggestion, maybe this is the case.
Also, what do you have on top of your script, since this is line 6...?

[Indhu]

This is how I started my code. I have only declared a hotkey at the top of my script.

My AHK version is: 1.0.48.05, 32 bit, and ANSI encoding.

[Kobaltauge]

error at line 6
but the script you posted has only 4 lines.
please post the complete script.
It is not much code. Retye it in notelpad. I think somes strange characters are in your .ahk

[Indhu]

This is my script.

Code: Select all

a::

Path := A_Desktop "\Data\Input.xlsx" 
XL := ComObjCreate("Excel.Application")
XL.Workbooks.Open(Path)
XL.Visible := True

Still the same error with a new notepad file.

[Tigerlily]

This is my script.

Code: Select all

a::

Path := A_Desktop "\Data\Input.xlsx" 
XL := ComObjCreate("Excel.Application")
XL.Workbooks.Open(Path)
XL.Visible := True

Still the same error with a new notepad file.

Does this work?

Code: Select all

Path := A_Desktop "\Data\Input.xlsx" 
Run, % Path

Does this work?

Code: Select all

excel:=ComObjCreate("Excel.Application")
excel.Workbooks.Add
excel.Visible:=true

What do you mean a new notepad file? Are you trying to open a .txt file?

[Indhu]

Code: Select all

Path := A_Desktop "\Data\Input.xlsx" 
Run, % Path

This works fine.

Code: Select all

excel:=ComObjCreate("Excel.Application")
excel.Workbooks.Add
excel.Visible:=true

This one shows the same error at 'excel.Visible'

What do you mean a new notepad file? Are you trying to open a .txt file?

No. I retyped the code in a new notepad and tried again.

@TigerLily

[Kobaltauge]

This is very strange. Did you take a look at the log?
Right mouse button on the AHK Icon next to the clock an "open".
Mine looks like this.

Code: Select all

Script lines most recently executed (oldest first).  Press [F5] to refresh.  The seconds elapsed between a line and the one after it is in parentheses to the right (if not 0).  The bottommost line's elapsed time is the number of seconds since it executed.

---- D:\Programmier\autohotkey\AHK-Studio\*
003: SendMode,Input
004: SetWorkingDir,%A_ScriptDir%
006: Return (3.09)
008: Path := A_Desktop "\Data\Input.xlsx"
009: XL := ComObjCreate("Excel.Application") (0.95)
010: XL.Workbooks.Open(Path)   (0.47)
011: XL.Visible := True   (0.23)
013: {
018: Exit (15.59)

Press [F5] to refresh.

[Indhu]

@Kobaltauge

I'm not able to open up the log due to this error. I don't get the AHK icon next to the clock, whenever I get an error. I can open the log for other AHK scripts.

Moreover, which ever example codes I try from internet, I always get the same error at " XL.Visible" line, saying it has got an illegal character.

A solution for this will be of major help for me

[Datapoint]

My AHK version is: 1.0.48.05, 32 bit, and ANSI encoding.

That's AHK "Basic" / "Classic". It doesn't have objects or COM etc. You need a newer version to use COM. (or use the old COM standard library with that version. Upgrade to AHK 1.1+ if possible)