VS 02/03 Friend ExcelGlobal_definst As New Excel.Global Doesn't Work?
Aug 17, 2009
I have an application that I originally wrote in MS Basic. It has since migrated to VB6 and then to VB Net. It works, but recently I have been unable to rebuild the project and an attempt to convert from VB6 has produced an error on converting and MSMaskEdBox as an array.
The most recent problem arises from the line of
Friend ExcelGlobal_definst As New Excel.Global
This enables me to pass data to an Excel spreadsheet from my project. If I leave a blank after New, VB Net presents me with a drop-down list, which includes I have recently tried to convert the project on my laptop and the above line of code produces an error. When I try to add a property(?) after New, Excel is not in the list of those available.
I have a problem with a global variable in VB.Net.In one sub (triggered by a button) I create objects and store them into a global variable (an array). After that I create a table (DataGrid).With a second button another sub is triggered and tries to use the array from the global variable, but it seems to be empty.Here is the code:
<script runat="server"> Dim array_datensatz(12) As Datensatz Sub submit1_click(ByVal Sender As Object, ByVal E As EventArgs)[code].....
I have an application that requires data be entered, and after entering, a button is clicked to process that data. Clicking the button works just as it should--the data is processed properly. In constructing a test module, I provide a set of data values, followed by:
btnWhatever.PerformClick()
Nothing happens. I have used this syntax for years, and it has always worked flawlessly. I have triple checked everything else and isolated the problem to the failure of the PerformClick(). The PerformClick() is in a test subroutine that does nothing but fill textboxes and labels with default data, then calls the PerformClick() on the button to begin processing. Again, the button works fine, the data is entered as it should be, but the PerformClick() does not fire the click event.
I need to access the current instance of MS Excel. To do that, I wrote the following code:
Imports Excel = Microsoft.Office.Interop.Excel Imports System.Diagnostics Private _ExcelApp As Excel.Application
[Code].....
The code runs nice, but it has a problem: After the user close the Excel application (click button X - note: no other instance of Excel exists), if you open the Windows's task manager, its possible to see the process Excel.exe.
If I open and close the Excel application, there is no process Excel.exe, but if I run my code with the Excel application openned, after the user close the Excel application, the process Excel.exe isn't finished.
I've been reading about access modifiers in VB.Net lately, and there is something that I can't really understand: How do elements in a Class (or Module) inherit the modifiers of their enclosing block?For example, suppose you have a Friend class Bla in an assembly, with a public method Foo:
Friend Class Bla Public Sub Foo (...) End Class
Does it behave differently than when Foo is set to Friend?
Possible Duplicate: Datagridview doesnt work! I have written code to show records in a datagridview but it shows nothing. I have tried to debug & when it step into GetData function following codes
Catch ex As Exception returnData = Nothing If connection.State = ConnectionState.Open Then connection.Close() End If
become gray & it shows error sign. When I take my mouse pointer on it it shows message. It says "Cannot open database SUIMT requested by the login. The login failed. Login failed for user 'MY-PCJames'".
Imports System.Data.SqlClient Public Class Form34 Private Const ConnectionString As String = "Server=.SQLEXPRESS;" & _ "Database=SUIMT;Trusted_Connection=True"
So I have 2 data files, single dimension, that I'm trying to populate two rtb. If I comment one streamreader out the other will print. This also works in the vise versa situation. Does anybody see where I'm going wrong with this? They won't run together.
Dim Alpha As New System.IO.StreamReader("alpha.dat") Dim Beta As New System.IO.StreamReader("beta.dat") Dim strLine As String
i'm working on a MDI application and need to view a ".PDF" files in a MDI child form, but when using the AxAcroPDF control it doesent work, note that it works fine when viewing the form separately from the MDI application.
Private Sub BackgroundWorker1_DoWork(ByVal sender As System.Object, ByVal e As System.ComponentModel.DoWorkEventArgs) Handles BackgroundWorker1.DoWork For i = 0 To 1000
Has anyone succeeded in creating a class library solution/project in VB.net VS2010 4.0 Net Framework for COM to run on WindowsXP Excel 2003. I created a dll which changed specific data in an excel worksheet. The dll worked just fine on the development computer but wont work on any other. I downloaded .NET 4 framework onto the target PCs and used RegAsm.exe to register both the .dll and .tlb files in the registry. That worked OK and the dll is visible as a reference in excel and can be ticked. The error message I get is RunTime Error -2147024894(80070002): Automation Error The System cannot find the file specified.
I also tried creating a Setup and Deploy project in the original development solution but this created just a vbproj setup file which the target PC cannot read (no VS installed), I hoped the project would create an EXE file I could use. Does anyone know any links that describe how to do this type of stuff as most links I have tried are either for Windows Forms projects are are way above my knowledge. Maybe someone out there has already succeeded with this sort of activity?
I have Visual Studio 2010 Express Edition. I'm using it to evaluate functionality before purchasing the real thing, but I'm having trouble. I want to build a DLL that can be used on PCs other than my development PC, that I can call from VBScript.
I follow the hundreds of examples out on the intranet and things still don't work.I have built a simple HelloWorld DLL with a function that returns "Hello World".I've been through all the stuff about making the assembly COM visible, and the threads about Register for COM Interop checkbox missing. One person suggested editing the .vbproj file and adding a tag to turn on Regiser for COM Interop (which was not needed because it was already there).
Anyway, if I build my project and run my VBScript:
Set testdll = CreateObject("HelloWorld.Class1")
wscript.echo testdll.HelloWorld()
Everything works great. But....if I copy the DLL to another PC and register it with RegAsm, the VBScript fails with a "File not found" error on the CreateObject line of the VBScript.
In fact, if I unregister the DLL on my development PC and then register it with RegAsm, the VBScript now fails on my development PC. RegAsm said everything was okay and if I look in the registery using RegEdit, things look good, but it still doesn't work. The only way to get it to work again is to rebuild the DLL (which in turn, registers the DLL).
I'd like to be able to build a DLL which I can be registered and used on other PCs (without requiring those PCs to have Visual Studio 2010 EE and without requiring them to have the source and build the DLL).
I am getting a datarow from my dataset and some columns can be NULL.So I am trying to check for this using the IsDBNull function, but it just won't work. I have tried almost every possible combination. Can someone please explain to me how to use this properly?ser is a datarow and GUID is a column with data type: unique indentifier (so a Sytem.Guid)
user.GUID.Equals(DBNull.Value) Then .GUID = System.Guid.NewGuid I tried using above, IsDBNull(GUID), guid = dbnull.value, guid is dbnull.value etc etc I am just getting this error: The specified Cast is not valid.
The form is an About Us form so has nothing on it only a text box and a OK button.
[Code]...
Why won't the button close the form? I'm puzzled, I tried another button just in case with the same result. UPDATE: I set a break point on Me.Close() and it isn't reaching it when I click the button, I created a new button and the same thing happened.
Its my understanding that by adding the ScaffoldColumn(false) annotation to an property in a class, that property will not added to the view when doing Add View. However even though i have added scaffoldcolumn false to properties i dont want added to a Create form, they are still rendered inthe create view. Is ScaffoldColumn broken? On page 552 in Pro ASP.NET MVC 3 Framework by Freeman and Sanderson, it states "If we want to exclude a property from the generated HTML, we can use ScaffoldColumn attribute. When the scaffolding helpers see the ScaffoldColumn attribute, they skip over the property entirely; no hidden input elements will be generated and no details of this property will be included in the generated HTML.
" Also the MVC Music Store PDF on p 77 indicates that the attrtibute will do the same -"Allows hiding fields from editor forms".They add it to the AlbumId property and then when the app is run AlbumId field is not shown in the browser. Is this attr broken?If i change a html helper to DisplayFor it does not appear in the form regardless of whether scaffoldcolumn is present. For example i dont have scaffoldcolumn false on Property PostTitle but if i change @Html.EditorFor(Function(model) model.PostTitle) to displayfor then it does not render regardless of the scaffoldcolumn attr. Also my Create view is strongly typed to @ModelType RiderDesignMvcBlog.Core.Entities.Post?
I have an issue with my .NET application and it can only be reproduced sometimes and only on client's location, which makes it extremely difficult to resolve. In the application the forms authentication is used. There is a login page to which every anonymous user is redirected. After user enters username and password, it redirects to DefaultURL or some predefined page. The problem is that sometimes when user enters correct username and password, it doesn't login, instead it just refreshes the login page without any error messages. After several tries of inputing username and password, user is able to login to the system.
See my login page Submit_Click code below:
Dim userName As String = tbUsername.Text Dim password As String = tbPassword.Text Dim returnUrl As String = Request("returnUrl")
I have creating timekeeping application, I was used drag and drop for my datagridview. During build I can add, edit and delete records. But when I published and run there was an error saying (see below).
I have consume for almost 2 days to fix this problem but no luck.
I've developed a small windows form application in Visual Studio 2005. I have tested the application on a completely fresh install of Vista 32-bit as well as Vista 64-bit and it works fine... But when I copy the application onto an XP machine the following problems occur:The application no longer has its icon, just the default .exe console box icon Whenever I try to open the application, absolutely nothing happens
I've almost finished a binary clock, but I have one problem. The user should choose between two different backgrounds, named binary.jpg and binary 1600.jpg
Dim Bild1 As New Bitmap(Application.StartupPath & "/Bilder/binary1600.jpg") Picturebox1.Image=Bild1
i've got a problem here whereby my ctype doesn't work.firstly, to replicate my case briefly, i've created an extension of control class
[code]...
father.getheight 'compiler writes: Panel class doesn't support getheight, but I've already converted it to a Control with CType!end sub of course if i dim father as Control it works perfectly, but in my case father may be other objects as well that aren't controls so I had to dim father as a general object, is there a fix so i could properly convert father into a Control object?
