View topic - COM excel issue • AutoHotkey Community

View unanswered posts | View active topics

Board index » AutoHotkey » Support

All times are UTC [ DST ]

COM excel issue

Page 1 of 1

[ 3 posts ]

Print view | E-mail friend

Previous topic | Next topic

Author

Message

neXt

Post subject: COM excel issue

Posted: February 9th, 2012, 4:07 pm

Joined: March 19th, 2007, 12:43 am
Posts: 532

I'm trying to utilize COM in one of my scripts, but can't seem to get the worksheet object reference assigned.

Code:

Excel := ComObjCreate("Excel.Application")
bulk_invoice_file := Excel.Workbooks.open("S:\ACCTS. INVOICES\EDE - EDD\2012\EDD 10415 01-05-12.xls")
bulk_invoice_tab := bulk_invoice_file.Worksheets("Canada")
MsgBox % bulk_invoice_tab.Range("A8")

How do I make this line work?

Code:

bulk_invoice_tab := bulk_invoice_file.Worksheets("Canada")

Top

Odlanir

Post subject:

Posted: February 9th, 2012, 5:19 pm

Joined: August 7th, 2011, 1:23 pm
Posts: 754

Code:

MsgBox % bulk_invoice_tab.Range("A8").value

_________________
Win7 - Firefox 10.0.2 - AHK_L 1.1.07.00
Please bear with me and my English which is so bad at times that even I don't understand myself

Top

neXt

Post subject:

Posted: February 9th, 2012, 5:29 pm

Joined: March 19th, 2007, 12:43 am
Posts: 532

Value is optional in VBA, didn't think it mattered in COM :roll:

. Thanks!

When I'm done with the file, do I need to release Excel object or will releasing bulk_invoice_tab object be enough?

Top

Page 1 of 1

[ 3 posts ]

Board index » AutoHotkey » Support

All times are UTC [ DST ]

Who is online

Users browsing this forum: BrandonHotkey, Edd and 16 guests

You can post new topics in this forum
You can reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum