CreateObject("Excel.Application") Running Very Slow?
Nov 24, 2009
In my vb.net applications, I do a lot of reading/writing to excel files.This is one of the simpler bits of code I use:
Dim objApp As Object, objBook As Object, objSheet As Object
objApp = CreateObject("Excel.Application")
objBook = objApp.Workbooks.Open("C:maid2cleanM2CPrinters.xls")
objSheet = objBook.Worksheets.Item(1)
[code]....
It's never been fast but in the last few weeks it seems to take forever.The "createobject" line is taking 4 seconds to run. is there any way I can find out why it's slowed down?
I'm using a background worker to in an Excel VSTO application to throw up a progress dialog box with a status bar and a cancel button to escape from long running calculations. It's working really well, except for one issue. I'd like to use a Modal Dialog, so that the UI behind the dialog gets locked up, instead of a Modeless Dialog. If I use .ShowDialog() instead of .Show(), everything is great until you hit the Cancel button on the form. Following things in the debugger, the cancellation happens, it just takes somewhere in range of 30 seconds. If I use .Show() on my form, then the cancellation occurs immediately as it should.
I have a program that uses Excel files as a datasource. When I import data I start the Excel interfaces and after the whole thing is complete I close and empty the Excel references...But, the Excel program will still be running in the backround.(When I check the Task Manager it shows at least one EXCEL running...)Also, one of my excel-files always prompts for "Do you want to save the changes" option when I import the file into my program. Even though it has not been running at all... ?
If fdlg.ShowDialog() = DialogResult.OK Then Polku = fdlg.FileName Dim XL_App As New Excel.Application Dim XL_WB As Excel.Workbook = XL_App.Workbooks.Open(Polku)
All of a sudden all vb programs running very slow in XP...... nothing has changed.I took the vb2008 complete out, and reinstalled...... and no difference. other programs like excel run as before, just all my vb2008 programs are really slow.....
1. load gridview from an uploaded excel file (this would probably be about 300 records or so)
2. compare manufacturer, model and serial No to my MS SQL database (about 20K records) to see if there is a match.[code]is there a better way to find a match between the two?
I think it's because I have a background image. For example when I maximize the program it lags. I mean big software companies have programs that have more pixel images and are much more colorful then my program is but never lag why. AVG has nice look but the program never lag. But the code runs fine so that is a good thing. How can I stop the lag with background image?
My HP dv6 - 1030US notebook has 4 gb of ram, and a Fujitsu MHZ2320BH G2 hard rive with 166 GB. free. running vista 64 SP2 and all current kb's installed. My problem is trying to test Vb 10 express with this unit. I am an ex vb 6.0 guy(beginner level) and still put small # of apps together for my remodeling company.
I have a program that is able to print selected drawings to a printer near the person who requested the drawing. recently we updated from autocad 2008 and inventor 2008 to autocad 2010 en inventor 2010. With opening of inventor 2010 I don't have any problems. I'm usung visual studio 2005 I open autocad with the following text:
I have to generate about 800 excel files from an access database.
For the first 10-15 of them it's working nice, a few seconds/excel file but it's constantly taking longer, at the 150th excel file it's taking 10 minutes.
Here is my code:
It's doing this for each nrliste in the access table (about 800 of them)
Dim lista = From ls In Liste _ Where ls!Concatenare = nrliste(i) _ Select ls
am converting some excel macro to vb.net, and it's almost done, but when i am looping throught +- 3000 rows and checking with 2 sheets it takes about 3 hours !
Dim Site1 As String Dim Site2 As String Dim Group1 As String
We have an automatic process that opens a template excel file, writes rows of data, and returns the file to the user. This process is usually fast, however I was recently asked to add a summary page with some Excel formulas to one of the templates, and now the process takes forever.
It successfully runs with about 5 records after a few minutes, however this week's record set is almost 400 rows and the longest I've let it run is about half an hour before cancelling it. Without the formulas, it only takes a few seconds to run.
Is there any known issues with writing rows to an Excel file that contains formulas? Or is there a way to tell Excel not to evaluate formulas until the file is opened by a user?
The formulas on the summary Sheet are these:
' Returns count of cells in column where data = Y =COUNTIF(Sheet1!J15:Sheet1!J10000, "Y") =COUNTIF(Sheet1!F15:Sheet1!F10000, "Y")
I have designed an application just like it is an Excel table. By changing each textbox the application runs a huge amount of vb code and it takes time.
E.g. you want to enter a three digits number it takes from two to four and sometimes more seconds for ech digit to enter. That`s really embarrassing.
I have been developing an application using Visual Studio/VB and access 07 for my db. On the system I am developing my app. the db is local and the speed of the application is very good when I debug it. As I publish my application the db goes on a network server and the application is installed/used by 5-6 pc. The speed of the program drops alot as time passes and as is used, speed goes even more down. My problem is that I do not know what is making this change. Is it the server fault, the other pc, the many users, the lack of garbage collector ( other than the one vb does alone ), the existense of the db on the server? Based on the information I give does anyone has a tip on how to increase speed. I dont know how to begun to start fixing it as I do not know where the problem resides. One example of poor performance is the search I do on the program. For the first search I do they are ok then the more I make the slower they get.
I am converting several VBA projects to Windows form applications. The only problem I have is that some of the functionality of Excel is essential to the application, such as R1C1 formulas. I do not want to instantiate the Excel application or access saved worksheets. All of the data is retrieved by querying Oracle databases. 2-Dimensional arrays are not an option because the columns contain differing datatypes, and DataGridViews are too slow to work with.
I thought simply dimming a Microsoft.Office.Interop.Excel.Worksheet object would be enough, but the program kept failing and upon inspecting the object's elements in debug mode, I found that every value says this:
{"Unable to cast COM object of type 'Microsoft.Office.Interop.Excel.WorksheetClass' to interface type 'Microsoft.Office.Interop.Excel._Worksheet'. This operation failed because the QueryInterface call on the COM component for the interface with IID '{000208D8-0000-0000-C000-000000000046}' failed due to the following error: No such interface supported (Exception from HRESULT: 0x80004002 (E_NOINTERFACE))."}
I had done one application using api which send the message to given number. The working of software is very fine without any error working on windows XP SP2. I heard that vista already contain the .net frame work so didnt installed .net frame work in machine. I checked in vista it shows .net frame work is in machine. But when same code i tried to run on Vista it gives the error. Error is as follows
See the end of this message for details on invoking
just-in-time (JIT) debugging instead of this dialog box.
************** Exception Text ************** System.AccessViolationException: Attempted to read or write protected memory. This is often an indication that other memory is corrupt. at SmsSendingApplication.frmSingleMessage.InternetOpenUrl(Int64 hInternetSession, String& lpszUrl, String& lpszHeaders, Int64 dwHeadersLength, Int64 dwFlags, Int64
I have a Vb.Net 2010 solution with two projects and a total of around 500 forms. Until last week compilation of these projects occured in about 30 seconds. Starting a few days ago (without any noticiable change) compilation now takes around 15 minutes! The «culprit» seems to be ResGen.exe: looking at Task Manager this program is using 25% of CPU time while devenv.exe stays idle - no other programs are active. Target CPU is x86 and target Framework is 3.5. The development machine runs Windows 7 Professional and is updated with all regular updates and SPs.
I've read around that playing WAV files from resources using My.Computer.Audio.Play causes horrid distortion when playing the sound, and I've experienced this myself. I cannot,however, use WaitToComplete, because the sounds are associated with a timer that cannot stop for anything, as it is an official competition timer.Also, I'm having an issue with the application being extremely slow when loading data from an Excel file. Essentially, the program has a grid of labels with transparent backgrounds (which seems to make the speed issue worse). The program uses the MS Office library to pull data from a spreadsheet, then output cells to one label at a time. This unfortunately, causes the application to nearly freeze, which also stops the timer, which as I said above, cannot happen
I am moving a lot of data to MS Excel from my application. I use a conditional statement to choose which Excel page the data is transferred into. Then a For Next statement to divide the data into various areas on the Excel sheet.The first sheet will always work correctly, but on the next conditional statement to chose the next Excel sheet no data transfers when running the program. If I step the program by hand all data all code works fine. I believe I need to pause between the conditional statements but I have been unable to get one to work.In the following code I have been trying to get a pause between to conditional statement to no avail.
I'm asking this question here, in this forum, as I couldn't find MSDN Managed forum for Crystal Reports. And the previously asked questions are unanswered. I've developed an application using VB.NET and Crystal Reports in VS2008. The report generated gets printed correctly on modern laser or inkjet printers. However, the entire formatting gets affected when I print these reports on dot matrix printer. Apart from that. the print speed is very slow. I tried exporting the report to PDF, XLS, DOC and other formats - but no solution. There was Export to Text function, which is not working in Crystal Reports now.
I found some code online for a vb paint application and I modified it for my use, which is a signature application. It uses a tablet connected to the pc to write the signature on the screen and then save it as a bitmap for later retrieval.The only issue i am having right now is that if you write on the tablet too fast, the signature gets broken up alot, any way to quicken the paint process in the code so that I can get a smoother signature?
Here is my code: Imports System Imports System.Collections Imports System.Data Imports System.IO Imports System.Xml.Serialization [Code] .....
I noticed that my application is running a bit slow. This is a Windows Service built using VB2010 with SQL Server as a back end. Its main function is to poll a folder looking for a text file. If found it reads the text file and imports the data into SQL Server.
While the slowness could be caused by a number of reasons, I am looking at my code to determine if it could be more efficient. Below I've pasted snippets of code where I initialize the DB connection and execute SQL statements. I've also included a snippet that illustrates how I am processing the text file.
I'd appreciate if the group could have a look at these and let me know if the method that I am using is the most efficient possible. At this time I am also focusing on other probable issues, but I can't rule out the possibility that the code that is in place might be a contributing factor.
I have an application that consists of about 4 screens. Screens can be changed by clicking on buttons or via menu item. I use about 16 to 17 tables in all for all 4 screens. I've publised the application and it works fine except that it takes about 1 1/2 to 2 minutes to launch the application using the setup file that I save onto my PC. If I get lucky, a little over a minute is already fast for me. What can I do to help speed up the launch time?
Which is the best way to store application and user settings of an application running with multiple instances?My problem is that using the vb's "Application Settings" one instance would overwrite the other one.I want to identify each instance with a number passed via command line argument. I could use this number to identify the appropriate settings of the running instance, but I see in a local INI o XML file a better way to handle that.
Let's say 10 desktop shortcuts, all with different names/icons, point to and can start the same exe application from the same directory. Is there any means for the application to know the distinct name of the shortcut that was doubled_clicked. Also is there any means for a running application to know if it was started by command line, by a double_click on the exe, by a double_click on a shortcut that points to it, or by another process' call?
