COM Server Code Way Slower Than Excel VBA Code?
Sep 1, 2009
I have a client who needs Excel VBA code that produces formula values moved to VB.NET. He is in the business of providing financial analytics, in this case delivered as an Excel add-in. I have translated the VBA into VB.NET code that runs in a separate DLL. The DLL is compiled as a COM Server because, well, Excel-callable .NET UDFs have to be. So far, so good: Excel cells have "=foo(Range1, Range2, ...)", the VB.NET Com Server's UDF is called, and the cell obtains a value that matches the VBA code's value.
View 7 Replies
ADVERTISEMENT
Feb 29, 2012
I have spent years writing VBA code that has got increasingly complicated. For the first time, I came across the error in VBA "Out Of String Space" when dealing with a 200MB CSV file.To overcome this I copied and pasted all the code over to VB.NET, compiled changed a few errors and ran the new code. The VB.Net takes 15mins, when VBA took 3 mins.For instance,Previously, to read the contents of the CSV file in VBA I used the code,Dim whole_str As String
Open file_path for Input As #1
whole_str = Input$(LOF(1),1)
Close #1
[code].....
View 1 Replies
Nov 9, 2010
I can do this using VBA, but I want to be able to create the code using a compiled VB programme, which can then be opened in Excel.
View 1 Replies
Sep 9, 2011
this code was not done by me originally and there are some thigns here i dont quite understand i have altered it a bit from my coworkers code to suit my data and it works. but too slow. and when i have 4000+kb excel files it might freeze altogether. ( I have checked tho that when and after this transposer runs it will still be within the excel row limit, i had done calculations before and made a macro to automatically split excel files based on number of columns and rows to make sure this is so ). This code seems to start out fast then goes slower the longer it runs. at least this is what it seems liek to me.
[Code]....
View 2 Replies
May 26, 2010
i recorded the following macro in excel 2007:
[Code]...
View 3 Replies
Sep 18, 2010
I have a code in VB that looks like this:'Server.Transfer(txtUser.Text + "_page.aspx")which is taking a forms authenticated user to their page. For example if John logs in, it will take him to john_page.aspx.How will I be able to integrate this in a PHP login script?I'm trying something like:header("location: $member ._page.php");but I don't think I'm doing this correctly.
View 1 Replies
Jul 26, 2011
I have the following code, my employer wants me to reduce the lines of code to do the job.
Private Function getClientSheetNames(Optional ByVal type As String = "all") As List(Of String)
If type = "extra" Then
Return clientExtraSheetNames
End If
[code].....
I am not able to make out how can I cut the lines and have the same functionality !Are there any vb.net construct that can reduce the loc by better implementation ?Can I have a new function to be called from getClientSheetNames and getDevSheetNames that will can implement code resue ?Can I introduce polymorphism in a possible new function ?
View 1 Replies
May 5, 2011
VB2010: All, I am using a picturebox to show the constellation of GPS satellites, that starts out OK. I have to redraw every now and then, because if a dialog box gets drawn on top of it, the data doesn't refresh after the dialog box is closed. Same with moving the Frame around the screen, I have to redraw the picturebox. (not sure why, but I can live with that) When I first start the program and received data from the receivers and plot the Constellation the refresh/redraw is very quick, (just a flicker) then after about 30 mins or so the refresh seems to redraw the picturebox slower and slower. I can see the individual satellites (fillellipse) redraw.
Also, I have moved the picturebox into a TAB-frame. Even when I switch from on Tab to another, the picturebox will not refresh automatically. I have to do a clear and then replot the information.
View 10 Replies
Dec 8, 2011
I have some code to execute code at runtime...
Here is the main
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Try
If TextBox1.Text.Trim <> "" Then
If TextBox2.Text.Trim <> "" Then
[code]....
When the button is pressed, it all works and the following files are created: yahoo.dll and yahoo.pdb My question is this: What is the code to load the already compiled yahoo files to execute the code again, without having to recompile the code?
View 1 Replies
Aug 16, 2010
I am exporting data from vb.net to excel and it is dropping the leading zero when its displayed on excel. How can I avoid the dropping of leading zero? I read the solution of adding a single quote but it makes my excel sheet column ugly. Also users will complain if they see a single quote on zip code field.vb.net code
Response.AddHeader("content-disposition", attachment)
Response.ContentType = "application/vnd.ms-excel"
Response.Charset = ""
the stored procedure outputs XML and it is transformed by XSLT before it is displayed on EXCEL
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<xsl:template match="/">
<HTML>
[code]....
adding a single quote or manipulating excel sheet with column formatter (general/numbers ) etc. I don't want user to make any changes on excel to get the display properly when the excel is displayed from web page it should be all set with proper formatting. also we have no control over client excel software?
View 4 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
Sep 7, 2010
I have one excel sheet which has ontime event of 5 mins to run some code.This code works fine when in debugging mode. But if I lock my PC or minimize excel windows and start working something else, this code just pauses at beginning and as soon as I activate excel window, this code runs.this code involves opening and closing of one userform and i think userform is culprit.
View 2 Replies
Feb 7, 2012
I am uploading an excel file to my app and want to read it. Do I need to have excel loaded to read this?I am getting an error of Object reference not set to an instance of an object.
Public Function GetExcelData(ByVal ExcelFilePath As String) As DataTable
Try
Dim OledbConnectionString As String = String.Empty
[code]....
View 2 Replies
Aug 24, 2011
I have a situation where I need to create a session in a Windows server using a specific Username and Password.
View 1 Replies
Jul 19, 2011
This code was posted in Chit Chat and everyone is saying how great it is. I just have Visual Studio 2010 and no familiarity with VB6 so I thought it would be good to convert the code to Visual Basic 2010.
[Code]...
View 39 Replies
Apr 19, 2010
I open an Excel workbook from VB.Net and then want an event in the workbook (such as pressing a button) to activate code in VB.Net. How do I accomplish this type of callback?
View 1 Replies
May 7, 2011
My boss has used VBA in excel to create an application and we have had problems deploying the application to various PCs. Errors occur during the execution and we have to address dll inconsistancies between PCs to make it run.
I have heard that it is possible to compile the VBA code with VB.net.
View 4 Replies
May 27, 2009
First off let me just say i have imports for the excel and office applications. I am using office 2007. I am hoping someone can show me what I am doing wrong here.
I have been searching and researching for a few days now on formatting excell cells within the VB code. It works for most objects such as bold, font size, where i want to place the data and what I want contained in the cells.
I have been using the VBA within excel (macros) to determine the code i should use to format the cells, however, The underline feature doesnt work correctly as with any justification of the cells. or merging. I can't seem to make many of the format options work and am wondering if they are slightly different or if i need a few more code lines so that when i declare something like this...
CODE:
I get an error, xlcenter is not declared. I cant declare it as a string i just recieve a com error starting it couldnt be done.. I am stuck on how to get by these so called "undeclared" command strings that i need to format the cells properly.
View 13 Replies
May 29, 2009
Add some code to a web server? I have this code here[code]...
View 1 Replies
Nov 29, 2010
I have the following macro that copies a set of rows and using the "Insert Copied Cell", replicates those rows.
[Code]...
View 2 Replies
Sep 24, 2010
Does anybody can give me tutorial link how to convert excel data and move it to txt file?
View 2 Replies
Feb 15, 2012
Export data to excel according to code? [code]...
View 4 Replies
Dec 30, 2009
I have been changing my existing code over the past week and have not successfully been able to export to excel in the format that the users are request. I am new to this job, learning vb through training videos, and have been given the task to update problematic old code and interfaces.The users cannot export large amounts of data. They receive a runtime error. The users do not want the export to html.The users do not want the controls to be exported.
[code]...
View 3 Replies
Jul 25, 2011
I have a little program that I wrote to translate an Excel spreadsheet into a text file and pass it to another application. We found out Friday that if you give it a spreadsheet ina bad format, theprogram just hangs up: no errors and no more processing.It hangs and never finishes processing. If the format is correct, no problems.I wanted to add error logic to catch this condition.So after the try to open the spreadsheet, the first thing I do is check this one cell and if it is not right, it creates and error message, sets an indicator for the error,and closes the workbook.It hangs up on the close of the workbook.A spreadsheet with the expected format closes just fine. I even copied the close statement up to follow the detection of the error, but it hangs just like it did at a different point in the program.
I have been trying to copy the code here, but the question ends up either blank or doesn't get posted at all.The workbook is defined by oWB=oXL.Workbooks.Open("Excel.Application"). oWB.Close() is what hangs. That same code does not hang if the format is correct. How can the contents of the file affect the closing of it?
View 1 Replies
May 15, 2007
How to Rename one Worksheet in an excel file through code?Example Sheet1 to MyWorksheet using a code in VB.Net
View 2 Replies
Sep 24, 2010
I have a range in excel and I want to be able to sort it by one column programmatically.
There is range.sort, but it has a ridiculous about of parameters and I cannot get it to work.
Surely there must be something to be able say I want this data to be sorted by this column?
View 1 Replies
Jan 26, 2010
Is there any way to print a message to the console from an Excel vba macro? I have a small VB .NET console application that calls an excel macro, and I'd like the error messages from the macro code to print to the console.
View 5 Replies
Jun 21, 2010
I'm trying to manage an FTP server with code that requires authentication.So I need to log in, get a list of directories and files within a sub-directory, Create directory, Delete directory and Delete File. (I know how to download and upload) I can't find any documentation on how to do this...though I would think it a fairly simple question to answer I seek not answers, but understanding, that I may not solve, but learn. What good is a fish without the skill to catch it?
View 1 Replies
Feb 15, 2012
I often find scripts over internet to perform different functions with SQL Server but I donot know how to use them in vb.net.For example I want to run the following code through my vb.net application, but donot know how to do so.
ALTER LOGIN sa ENABLE ;
GO
ALTER LOGIN sa WITH PASSWORD = '' ;
GO
View 1 Replies
Oct 29, 2009
I'm a small developer in VB6 and VB.net, and use for bugtracking a simple Excel. Seemed to me that I didnt need anything more.I've wanted to add links to the code. Then:How can I do it for vb6 and for vs.net?Is this reasonable? Should I change to a (free) bugtracking tool? Do they have this functionality?
View 1 Replies
