Results 1 to 5 of 5

Thread: Is it possible get open excel file via GetObject in 64-bit?

Threaded View

  1. #5
    Fanatic Member
    Join Date
    Apr 2015
    Location
    Finland
    Posts
    694

    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
  •  



Click Here to Expand Forum to Full Width