Results 1 to 5 of 5
  1. #1
    Kluaoha is offline Novice
    Windows 10 Access 2013 32bit
    Join Date
    Jul 2017
    Posts
    20

    Access hangs indefinitely when setting Excel Application Object

    In my simple export script, I have the following:
    Code:
    ...
    Dim XLapp As Excel.Application
    ...
    Set XLapp = New Excel.Application
    ...
    It usually runs fine, but now for seemingly no reason it just freezes on this second line, and what used to take a fraction of a second is still not continuing after 5 minutes of waiting.
    This happened for a while the other day and somehow managed to correct itself, but now it's back again.


    I am using Microsoft Excel 15.0 Object Library.

  2. #2
    aytee111 is offline Competent At Times
    Windows 10 Access 2013 64bit
    Join Date
    Nov 2011
    Location
    Nomad
    Posts
    3,936
    Is the Excel file open?

  3. #3
    Kluaoha is offline Novice
    Windows 10 Access 2013 32bit
    Join Date
    Jul 2017
    Posts
    20
    No, at least I don't think it is. According to the task manager it's not, but that hasn't been a true indicator for the times where I've locked myself out of my own spreadsheet.
    Then again, I've been running into some file issues during development that I guess might have caused this. I'll see if a restart fixes it.

  4. #4
    Kluaoha is offline Novice
    Windows 10 Access 2013 32bit
    Join Date
    Jul 2017
    Posts
    20
    Ok, after restarting my computer it works again. I suppose that be my solution to this problem.

  5. #5
    aytee111 is offline Competent At Times
    Windows 10 Access 2013 64bit
    Join Date
    Nov 2011
    Location
    Nomad
    Posts
    3,936
    I have also found sometimes that there is a message hidden behind a window, coming from Excel, but as Access has the focus it is not apparent. Minimizing every window one at a time will show the message. Argh!

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 2
    Last Post: 08-10-2016, 08:05 PM
  2. Replies: 6
    Last Post: 08-21-2015, 10:07 AM
  3. Replies: 1
    Last Post: 04-15-2015, 05:50 AM
  4. Replies: 4
    Last Post: 12-19-2013, 01:18 PM
  5. Open a specific Excel application in Access
    By Hobbes29 in forum Programming
    Replies: 1
    Last Post: 02-14-2011, 06:48 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums