Excel Instance Hangs In NET Class Project Application
Aug 7, 2009
I am writing a class project application that is loadable from within AutoCAD. This application generates an Excel workbook with extracted data. I am having a problem with Excel closing when finished. It seems the Excel instance hangs until my application is unloaded. I have found the section of code that seems to be causing to hang, but I'm not sure why its hanging to prevent it.
Below is a copy of my code for the class (top to bottom with exception of the FileExistValidation method... too many characters ). The code section that is commented out seems to be what is causing it to hang. If I uncomment that, Excel hangs, with it commented out, Excel closes out in the background.[code]...
View 10 Replies
ADVERTISEMENT
Feb 23, 2011
I want to encapsulate the use of Excel Interop to make it easier to use somehow in a reuseable library.So far, I have written some tests that work good altogether, except that between each test, I force Excel to quite so that it does have handle on the test file no more in order to be able to delete.Once I quit the application instance between after each of my tests, Excel seems to be no longer responding, causing Windows to display "Excel has stopped working and is looking for a solution"
message. This message lasts a few seconds, meanwhile Excel is closing, causing the hang on the file to occur and my tests to throw an exception like "Cannot access file because it is being used by another process..."
[Code]...
View 2 Replies
Feb 19, 2009
I'm creating what I believe is an mdi app.I have a login form.I have a class for security.My login form creates an instance of the security class. There are all kinds of security parameters for each user (permissions to different things, etc.)These parameters are part of my security class.Once the user logs in, many other forms will all be opened and closed within the main mdi frame.All of these other forms need the information of the security class to know what the user has permission to do.Do I have to create a new instance of security class for every form in my project? Isn't there a way to store this stuff globally somehow. Retrieve once from the db at the start of the app during login and just get it from this global area everytime?
View 2 Replies
Apr 18, 2012
In my VB .Net code, I am trying to create to launch MS Project Application. Dim prjApp As Microsoft.Office.Interop.MSProject.Application = New Microsoft.Office.Interop.MSProject.Application
But I am getting the exception as follows:
"Creating an instance of the COM component with CSSID {36D27C48-A1E8-11D3-BA55-00C04F72F325} from the
IClassFactory failed due to the following error: 80010001".Note: This exception happens in 64 bit Windows 7 German OS. But the same code runs successfully in 32 bit Win XP (German and English) and 64 bit Windows 7 English OS.I have even tried the following steps in German 64 bit Win 7
1. Running the application in Administrator mode
2. Setting UAC to low.
3. Re-installing MS Project in German 64 bit Win 7.
View 1 Replies
Feb 8, 2012
I am creating a Windows application using VS 2008. This has a MDI Parent form that hosts multiple MDI children forms. I have a login form that authenticates the user and creates an instance of a user class. This has information such as UserID, Name etc. I would like this instance available to other windows. How would I implement this functionality?
View 2 Replies
Aug 3, 2009
I use the following code snippet
Dim exlapp As New Microsoft.Office.Interop.Excel.Application
Dim xlWorkBook_new As Microsoft.Office.Interop.Excel.Workbook
Dim strOriginal As String
strOriginal = Server.MapPath(Request.ApplicationPath & "/Attachments/") & "abc.xls"
xlWorkBook_new = exlapp.Workbooks.Open(strOriginal)
The code hangs in the last line. It works fine in the development environment. i deployed in windows server 2000 ,where I get this issue. the browser goes half way and throws the below exception after some time
[Code]...
I have set the identity impersonate to true in web config. This should be mostly an access rights issue.I have even provided access rights for the "everyone " user in the excel file and as well for the interop component. Please post ur valuable comments.
View 3 Replies
Aug 8, 2011
my solution is make a class and public share this class as new in the class itself. it is a class to be filled with constants.
is there any programmatical objection against this solution ?
View 1 Replies
Feb 8, 2010
I wanna use the C# code file in VB.Net project Which is windows based application. But that C# class is not using in VB.NET application. How Can I perform this task.
View 4 Replies
Jun 29, 2010
If you mark your application using "Make Single Instance Application" option in the application settings tab and run your application under a GUEST account or a restricted limited/standard account the application throws UnAuthorizedAccessException or CantStartSingleInstanceException.
Take the following steps to reproduce this behavior.
1) Create Windows Form application.
2) Enable the "Make Single Instance Application" in the project properties.
3) Log onto a GUEST account and open the application twice to simulate StartUpNextInstance.
We need developers to reproduce this behavior and post any valuable input if you experience these symptoms.
When posting information please include the following:
a) The operating system version + service pack.
b) The .NET framework version used.
c) Verify this symptom is present when running under GUEST account.
To workaround this issue turn off the "Make Single Instance Application" option ad create a Local named mutex in the StartUp() event.
[Code]...
View 8 Replies
Jan 16, 2009
For some reason, the Add New Item command on the Project Menu is hanging VB on my Vista based machine.but now, it hangs. By that I mean the the little circle cursor spins and spins and spins... This happens even when all I do is start VB, start and new project. and then try to add something, eg. another form, a class, anything except "existing item".
View 1 Replies
Dec 17, 2009
I have an installer class that presents a form to the user. One of the functions of the form is to browse to a file using the open file dialog. This form functions fine when used in an application but hangs when calling OpenFileDialog.ShowDialog() during an installation on a Windows7 or Vista machine (Windows XP it works as expected). I get the same rusult when 'run as administrator' and with UAC off. I also get the same results when calling SaveFileDialog.ShowDialog() in the same context. The call doesn't throw an exception but causes the form to stop responding. Any suggestions on how to get this to work correctly?
View 6 Replies
Jul 13, 2010
I have an application the contains several excel files bundled with it. I'm not opening the files and processing them within my application. These files contain a data-connection to reload all of the pivot-tables within each excel file. I have a 'link' on my form, that when clicked, it determines which file to open and calls a sub using filename and executing Process.Start(filename) for any excel file I want to open. I have no problems opening any one of the files and then exiting excel.
The problem is when I 'close' a file, but don't exit Excel; then try to open another file(clicking link on form)... it creates a new instance of Excel.
I know from experimenting that the fileopendialog form will 'reuse' an existing Excel instance, IF it does not already have a file open.
How can I do the same thing without using the fileopendialog?
I don't want the end-user to have access to the folders where these files live. That's why I have multiple 'links' on my form, one for each xls that already exists. I just want them to be able to click on a link and the xls file opens AND if they choose to merely 'close' a file and not exit... Don't create a new instance of Excel, but re-use the existing one.
View 5 Replies
Dec 28, 2010
Its been running in production for over a year and this is the first time I saw this behaviour. The application is a VB.NET Console Application which is triggered by MQ server. This application uses a class library which is part of the same project(Say 'abc.dll'). In production around 40+ instances of this exe are running and all of them use the some of the functions from 'abc.dll'.
Last week, we noticed that all the 40 instances were shown to be running in the task manager but they were not doing any activity. There was no exception thrown or error logged in Application logs or System logs. To frantically debug the problem, I tried isolating the problem.
With all these 40+ exes hung up, I wrote a small aplication which would use a reference to this 'a.dll', create an object of one of the classes in that dll and execute a method in there. I was printing console.writelines in between to see to which point it gets to before erroring out.
To my surprise, I found that at the point where I was creating an object of a class in 'a.dll' this sample test application would also hang just like the others. No exceptions thrown. So I killed all those applications as a last resort and then when I restarted all of them, everything worked fine.
I couldn't find any explanation for this behaviour. Since it was a critical error affecting a production system(blanking out the application for 3+ hours), I have to give a very good explanation as to why this would occur. how it can be prevented in future.
(Side note: the servers running these appilcation do not have a maintenance schedule and are supposed to be up for couple of months together.
View 11 Replies
Mar 6, 2011
I am writing my first application in Visual Basic Express 2008 and the program conistently hangs (Not responding in the Task Manager) midway through execution. The operating system is Windows XP Professional SP3 running on a 1.20 GHz Intel Core Duo CPU with 2 GB of RAM.
The application has very deep layers of subroutines and functions, all of which are using lots of math routines. There are no recursive routines anywhere in the program. The program creates and destroys quite a few class elements, and I have written dispose methods for all of them using IDisposable, setting all the properties to Nothing. I also use GC.Collect() to force garbide collection, and GC.WaitForPendingFinalizers(). As a result, I don't think there are any memory leaks.
I think the depth of sub and function calls are causing a stack overflow, but I'm not certain. I have tried without success to increase the stack allocation to 2 Mb using Editbin.exe after reading some forums, but nothing changed. I then searched my machine and did not find EDITBIN.EXE.When the program hangs up, the background of the forms on the screen turn to solid white and the controls are no longer visible.It looks like a window pops up but it disappears too quickly to read anything. If I view the task manager while the application is running it hangs immediately. I have not published it, I am still developing and running it out of the VB environment.The more complexity (sub and function calls) I add, the earlier the program hangs.
View 6 Replies
Jul 15, 2011
I have a single instance VB 2010 application I know how to communicate with the next instances run through the StartupNextInstance application event. The usual way of working with this is parsing command line arguments of the new instance and continue execution of the old instance. What I would like to do is replace the running instance with the new one. Is there any way to do this other than disabling the single instance property ?
View 1 Replies
Jun 7, 2012
I want to created a nested class that can only be visible to and instantiated from the parent class.But I also want to be able to use an instance of the nested class through a public variable of the parent class.I tried making the nested class private, or making the nested class' constructor private, but it won't compile.Is it possible to do this in .NET?
[Code]...
View 3 Replies
Jan 18, 2011
my proble is the following: I have a class MyClass and another class Modifier, which has a method ModifyMyClass(ByRef mc as MyClass) that receives a MyClass instance as ByRef parameter to modify it. A smell of the code is:
[Code]...
View 4 Replies
Oct 15, 2008
Basicly I'm downloading XML files with the Webclient class for processing and caching in a local database. There are three different categories of data, each contains 1 to n numbers of XML files. To retrieve the XML file I ask the server with following parameters in the URL:
[Code]...
View 2 Replies
Jun 21, 2010
I have a weired problem. I developed a multithreaded WinForm application using VB.Net, and SQL Server 2008. The application works perfectly fine if I am using Visual Studio IDE to run the same. But, if I run the exe file created by VS the application hangs in case I lock my system and again relogin. The memory usage is same as it was before locking the system. CPU usage is also 0% or by max 2%. All threads are also exited after finishing there designated tasks.The application also uses threading but all threads are exited after there designated tasks. I confirmed this using various tools.[code]
View 5 Replies
May 5, 2011
I have created a small multithreaded application using VB.NET. There is no problem when the user manually runs this application. A problem exists when I added this application on startup. It hangs after I rebooted the system. The application is still running its thread but I can't see its GUI because its frozen. If I kill it on task manager and started again, the application works fine. What could be the possible reason/s why this application hangs when added on startup?
Imports System.Threading
Public Class USBLock
Public Event Lock()
[Code]....
or just a thought on this subject: the reason why the program hangs on startup is because the application is loaded while the .net framework service has not yet started.
View 1 Replies
Apr 21, 2011
I have win7 pro, on my win form is a traffic light icon(when it starts it is red, when finished it is green), so that I know when job is finished. But when I run application icon isn't changing and form hangs it self, can not do nothing until job is finished. Only in the end, I see that icon is quickly changes to red and then back to green.
View 1 Replies
Dec 22, 2010
I am re-posing this question because the prior post has gotten really full of side issues so I fear the main problems has been lost.I have a windows forms application written in VB.NET which scrapes information from serveral web pages? I am having problem with one particular site where partway through the page navigation my application hangs. When I press pause (or break) in the debugger, it stops on a call to System.Windows.Forms.Application.DoEvents.
View 7 Replies
Aug 19, 2009
I have a class in which some of the fields are also classes.I can put values in the "normal" properties, but in the others when o try to assign values it gives the: "Object reference not set to an instance of an object"But the code compiles fine.
dados_Defenicao = New ServiceReference1.draftClaimEntryDefinition
dados_Defenicao.arCode = "123"
dados_Defenicao.claimMarket.warrantyType = "w" - Here it gives the error
How can i fix this ?
View 6 Replies
Aug 19, 2009
I have a class in which some of the fields are also classes.
I can put values in the "normal" properties, but in the others when o try to assign values it gives the: "Object reference not set to an instance of an object"
But the code compiles fine.
dados_Defenicao = New ServiceReference1.draftClaimEntryDefinition
dados_Defenicao.arCode = "123"
dados_Defenicao.claimMarket.warrantyType = "w" - Here it gives the error
View 4 Replies
May 6, 2010
If you run this code you will see that the 500 PictureBoxes that are added ( this is easier to show than adding pixels as a pixel is only a single point ) fall mainly on the diagonal.With regard the RANDOM class, why should this be like this when the bounds of the instances are? >>
p.Location = New Point(x.Next(0, Me.Width + 1
), y.Next(0, Me.Height + 1 ))
as in this code.>>
[code].....-2138214fdeb4
View 9 Replies
May 31, 2012
I am developing windows based video application, in my application I have to make multiple video files with different duration from a single video file. To achieve this I am using thread.join method(), when I run my application it works fine but sometimes it hangs and I have got to close my application using Task manager, I can't understand why my application behave like this?.
This generally happens when number of output files are more than 40. Is there any problem with thread.join() function, when number of threads are increased. I am generating a new thread for each output file because this is the limitation of the third party dll which I am using.
View 4 Replies
May 19, 2010
Private
Sub Button1_Click(ByVal
sender As
Object,
[code]....
View 9 Replies
May 18, 2010
I've createda vb.net class library where I've defined a number of small classes... nothing complicated, just working with strings, sending emails, etc.In another project, I reference the class library and I'm seemingly able to create an instance ofone of tclasses - intellisense shows me all of the plic properties, methods, etc... all looks perfect. No compile errors at all, nothing b gumdropsand lollipops.When I run the app I'm working on that references the class library, it fails at the point where I'm creating an instance of the class and gives me a vague exception, "System.TypeLoadException".
View 2 Replies
Jan 20, 2012
Is there a way to define a class such that there can be only a single instance of that class?
View 5 Replies
May 20, 2010
I need to create a new instance of a class that needs a member of the calling class. But i can't pass a reference to the calling class through the constructor.The solution i am looking for is something like this:
Public Class ChildClass
Public Sub New(args)
_MyMember = GetMemberFromCallingClass()
[code]....
I want this to work without having to manually pass any references or variables from the calling class to the new instance of ChildClass.
View 2 Replies
