|
-
May 16th, 2016, 11:25 PM
#5
Fanatic Member
Re: Is it possible get open excel file via GetObject in 64-bit?
set xlApp = GetObject(, "Excel.Application")
If an instance of Microsoft Excel is running when this code is executed, you have access to the running instance's object model through the xlApp variable. If no instance is running, you receive the following trappable run-time error message:
Run-time error '429':
ActiveX component can't create object
https://support.microsoft.com/en-us/kb/288902
Use late binding...
http://windowssecrets.com/forums/sho...l-through-word
However using late binding, one looses intellisense, so best of both worlds - during development use early- and in compiled executable late binding.
http://nuke.vbcorner.net/Articoli/VB...T/Default.aspx
Last edited by Tech99; May 16th, 2016 at 11:45 PM.
Tags for this Thread
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|