Results 1 to 12 of 12

Applicatin is closing automatically without throwing any exception.

Threaded View

Gaurav Singh Applicatin is closing... 03-07-2014, 03:18 AM
tony h Re: Applicatin is closing... 03-07-2014, 03:42 PM
Gaurav Singh Re: Applicatin is closing... 03-08-2014, 03:33 AM
Gaurav Singh Re: Applicatin is closing... 03-11-2014, 01:25 AM
:) Sixthsense :) Re: Applicatin is closing... 03-12-2014, 05:16 AM
Gaurav Singh Re: Applicatin is closing... 03-12-2014, 06:16 AM
:) Sixthsense :) Re: Applicatin is closing... 03-12-2014, 06:27 AM
Gaurav Singh Re: Applicatin is closing... 03-12-2014, 07:15 AM
Gaurav Singh Re: Applicatin is closing... 03-12-2014, 06:15 AM
tony h Re: Applicatin is closing... 03-12-2014, 02:03 PM
Gaurav Singh Re: Applicatin is closing... 03-13-2014, 06:43 AM
tony h Re: Applicatin is closing... 03-13-2014, 03:33 PM
  1. #1
    Registered User
    Join Date
    03-01-2014
    Location
    Hyderabad
    MS-Off Ver
    Excel 2003
    Posts
    13

    Question Applicatin is closing automatically without throwing any exception.

    Hi all,

    I have devloped an application in VBA (Excel 2003) which imports lot of data (around 2,00,000 to 5,00,000 rows) from .csv files (as raw files) to .xls files.
    These .xls file will be created month wise (date is avalilable in csv files). Tool also creates one log file in which tool writes the number of rows updated from each file with file name and also logs errors if any occured. At a time tool can import 32 files. Most of the raw files are more than 15 MB. Tool takes around 1/2 an hour to import each file. I am using error handeler in each and every function and subroutines, but some times tool gets close without throwing any exception.
    The problem I am facing is some times tool suddenly gets closed while running which throwing any exception. From log file we can see that while importing which file tool got closed. And when we try to import the same file second time it gets imported without any error or without closing the tool.
    One of our user using this tool in Excel 2010 and he is facing the issue "Automation error: The object invoked has disconnected from its clients". This error is repeating for him in every 2 to 3 days . Problem is also same here when he import the same file second time, tool imports it without any error. I am not able to understand problem and not even able to duplicate the error. Please suggest me something to resolve this issue.

    Thanks in advance....
    Last edited by Gaurav Singh; 03-07-2014 at 03:30 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Interop.Excel.dll 11.0 throwing exception on Machine having only Excl 2003
    By namijami in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 08-27-2009, 08:05 AM
  2. Interop.Excel.dll 11.0 throwing exception on Machine having only Excl 2003
    By namijami in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-17-2009, 09:26 AM
  3. Win32 exception while closing from VBA
    By rtandon in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-25-2008, 08:05 AM
  4. Automatically closing workbook
    By zapszipszops in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-19-2006, 11:50 AM
  5. closing userform automatically
    By Jim Brass in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-05-2005, 11:05 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1