Pass An Array Of Objects As A Result But Excel Is Complaining?
May 6, 2012
I have created a COM Object via VB .NET and exposed some functions that I wish to call in Excel using VBA. I am currently trying to pass an array of objects as a result to VBA but Excel is complaining the following:
'Function or interface marked as restricted, or the function uses an automation type not supported in Visual Basic.'
I have looked around on the internet and have seen similar issues but not to one I am trying to do.My VB .NET function, which I wish to call in Excel is declared as follows:
Public Function CallArray(ByVal serviceName As String, _
ByVal effectiveDate As String,
ByVal serviceParams() As System.Object,
ByRef ArrayRes() As System.Object) As System.Boolean
VBA is complaining about the System.Objects my question is how the heck are you supposed to pass and return arrays from .NET to VBA. Also the data that will be in the ArrayRes() is mixed type, its not just strings etc, its an array of arrays that can contain strings, integers doubles etc.I chose VB .NET because I assumed it would be possible to map to VBA easier.if System. Object and Arrays in VB .NET is not the way, ie maybe theres another way via collections or lists, then Im open to that. I just need to get this data into VBA.Also I could move over to C# if needs be.
I am encountering the following issue So i have a device that sends stuff at the serial port, i then parse it and put it into an array of bytes like that:
Dim HCI_Command_Rcvd_Byte() As Byte All good till here What i wanna do is make an array and put this result every time the serial port gives me a new result, for example:
[Code]...
Basically what i wanna do is let the port parse the messages, fill in the array with the result at an empty spot in this array and then i will have a separate thread that will look in into this array in each non empty space and after it looks into the non empty space it will use or discard the info and also mark this space as empty (after it checked)
I have a 2d array of data that I have performed the sum of the individual column of the 2d array. I want to send the results to a datagridview and also will like to have the result as a 1d or 2d array.
Below is sample of my code
Dim Array1(,) as double Array1(0, 0) = 5 Array1(0, 1) = 7
One of my unit tests seems to randomly pass or fail when I run it. The only thing that makes sense to me for why this is happening is if the data in the database is getting into a different state each time the test is ran, but I use transactions to rollback the database in each test - unless it's not working right. Here's my base unit test class and the unit test class that's having the problem. Can you see anything I might be missing or what else I should look for?
This happens with TestDriven.Net and the Visual Studio Unit Test Framework.
With vb.net I would like to select 4 cells in Excel and then pass those cell values along with 1 button tag to a formula in Excel.I press a button with a month, say "May" as text. I want to grab a cell in Excel labeled "May1t" the value of which is the number of hours until may. This is the code I'm using.
xlsWB.Worksheets(2).Range(Month1 & "1t").Value I am able to set a variable with this as the value but,
I want to pass this cell (which will be updating as the time counts down) and 3 other similarly specified cells along with the button tag to an Excel formula.I have something like this:
Private Sub F_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles F.Click xlsWB.Worksheets(4).Range("B2").Formula = "=MyFunction()" xlsWB.Worksheets(1).Range(Month1 & "1t").Select() End Sub
The formula takes the parameters in the order: MyFunction(Cell,Tag,Cell,Cell,Cell).
I'm trying to pass a list of objects to my WCF service, but it doesn't seem I can pass an object list from my console test application. I have an error that states:
Value of type 'System.Collections.Generic.List(Of ConsoleTestingApp.ServiceReference1.LetterVariables)'
I have an object of type Dictionary(Of Int16, Polygon) and which contains sometimes up to 15 or so Polygons that i am creating bitmap files with the Polygon. This can take like 20 seconds sometimes so i was trying to pass the full Dictionary to background worker as an argument but i get an issue when trying to access each individual Polygon inside of the Dictionary because the Polygons still belong to the UI thread. How can I access the Polygons inside the Dictionary with the backgroundworker?
Dim worker As New BackgroundWorker AddHandler worker.DoWork, AddressOf MeasurePolygons AddHandler worker.RunWorkerCompleted, AddressOf WorkerCompleted worker.RunWorkerAsync(PolygonCollection)
that is how im calling the thread. PolygonCollection is the Dictionary(Of Int16, Polygon) that contains all the polygons that i will be creating a bitmap file out of.
I am finding that this may not be possible, but am trying to see if anybody has a solution.
I have four classes, two are core classes and two are those core classes extended[code]...
This fails because es is of type, extSecurity and the base class expects a type of coreSecurity. I've not found anyway to cast this to allow for me to override this base class in C#. In VB it works just fine.
I've got a .NET solution that I've just upgraded from VS2008 to VS2010. It contains three web projects and two straight VB projects. The web projects all depend on (and have a reference to) one of the VB projects called BusinessLogic.All projects are targeted at .NET 2.0, but VS2010 is raising the following build warning:
The following assembly has dependencies on a version of the .NET Framework that is higher than the target and might not load correctly during runtime causing a failure: BusinessLogic, Version=1.0.4419.22315, Culture=neutral, PublicKeyToken=null. The dependencies are: Microsoft.VisualBasic, Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a. You should either ensure that the dependent assembly is correct for the target framework, or ensure that the target framework you are addressing is that of the dependent assembly.
I'm redesigning an old VB6 application into VB.net and there is one thing I'm not sure on the best way to do. In the VB6 application whenever we created a new instance of a component, we would pass in the user details (user name and the like) so we new who was performing the tasks. However, no that I'm redesigning I've created some nice class designs, but I'm having to add in user details into every class and it just looks wrong.
Is there a VB.net way of doing this so my classes can just have class specific details? Some way so that if my classes need to know who is performing a task, they can get the information themselves, rather than having it passed in whenever the objects are created?
I've come up with the following and it's partly working.
Public serial1, serial2, serial3, serial4, serial5 As SerialPort Public serialports() As Object = New Object() {serial1, serial2, serial3, serial4, serial5} dComPort = "COM4"[code]....
The above code works fine! But im having trouble trying to now retreive whats stored in the array.In the above example, an entry will be stored in serialports(4), all other array elements will be blank.If I do this it works.
MsgBox(serialports(4).PortName) ' this retuns the value COM4
But I'd like to loop though all array elements and print out ALL the PortNames, The below code doesnt work, I get an error Object variable or With block variable not set.
For i = 0 To serialports.Length - 1 MsgBox(serialports(i).portname) Next
What is the best way to pass objects between threads? I would like to create a new thread that creates a new object : Dim myobject as newobject = new newoject Then in my main thread, I would like to use myobject. Ideally I would like to just assign to a global variable but I don't think that is possible. I think I may have to use some form of delegate function (but I think the child thread would need to complete to use a callback). The new thread will not actually end before I need the object reference in the main thread. How should I go about this?
I have a nested class, let's call it class1 and it has class2 inside it; VB.Net eg:[code]
1) How can I define X number of Class2 objects[let's call it: Node(x) array]** with NEW() subroutine called?' this raises error: dim cls2(n) as new class2 end sub.
2) How can I return actual number of Node() array? [code]Outside my class in main project I define cls1 object:[code]Now an array of class2 is created inside cls1.
3) Now,How can I access All of them[node(x) array which is created inside cls1] with all properties and methods available?
I remember I wrote a ProcessManager class with this functionality in .net 2003, nearly 4 years age, I don't have the code now.
I am writing an OPC Client in VB.NET (2008) and I am using an OPC wrapper from Graybox. I am having some problems with the data types. I have an Array of String that contains all of the OPC Items that I wish to read from the OPC Server. When I attempt to use the Array of String, Option Strict causes the following compile error message:Error 5 Option Strict On disallows narrowing from type 'System.Array' to type '1-dimensional array of String' in copying the value of 'ByRef' parameter 'ItemIDs' back to the matching argument. How do I pass the Item ID's (all strings) in an array?
I'm running Visual Studio 2010 on a terminal server, and have been, with relatively few problems, for some time. This morning I fired up my PC and over the UK's long weekend, the following issue seems to have developed.I've got a bunch of projects (but not all of my projects, and not all of the projects in a given solution) complaining that a particular file (which does not exist on the computer) cannot be opened, and so those projects will not compile anymore. Here's the error:
Error 31 Unable to open module file'C:Users[username]AppDataLocalTemp2.NETFramework,Version=v4.0.AssemblyAttributes.vb': System Error &H80070003&
I could simply copy the file into that directory and be done with it, I'm pretty sure that will work,EDIT: Okay, now things have gotten to a whole new level of weird. I've rebooted the server, I get the same error message, only now the file it is asking for exists and can be opened in Visual Studio with no problems. another part of the IDE still insists that it's unable to open the module file.
EDIT 2: Can't delete the file because it claims to be open in another program, but I've logged off and logged on again, and there shouldn't be anything accessing it.
EDIT 3: Because there's a wall of comments below his answer, I'll mention here that Jared's suggestion to delete the SUO file for the solutions having the problem (not files specifically to do with any of the problem projects, strangely) was what solved this, eventually.
I have an object called Result<T> that has a constructor which accepts an argument of IEnumerable<T>. I'd like to be able to pass in a datatable if possible.
I tried datatable.AsEnumerable(), but where I bind to the data it was complaining that 'MyProperty' is not a field or property on type 'DataRow' - which makes sense since 'MyProperty' isn't a property on 'DataRow', but it was a column in my datatable.Is there a way to convert a datatable to something that I can pass into the Result object and still have it bind to, say, a gridview?
how do i read excel file at VB.net & display the result in a label or something..e.g i know cell A2 is a string of text - e.g Hello this is the P/L for the month i want grab that and put in a label etc.
I am trying to search an array and then say whether the result was found or not.
So far i have:
Option Explicit On Module Module1 Const MaxAnimals = 20
[Code]....
Now i have looked online and all of them seem to give you like ready made things on VB but i have not used them yet and i know there is an easy way of doing it as my friend managed to do it before but i can't get hold of him.
Basically it is a program (There is more of it but this is not necessary for this) which puts the names of animals into an array then you can either add another animal, or in the sub i am doing at the moment view all the animals in the array but i can't work out how!
I'm a police officer and trying to write a program which will print the officers name, start and end dates and select a random road from an array that he/she will be responsible for during the time period. Right now I only have 6 entered to try and get the hang of this. It has a drop down list of persons names, a start date picker and an end date picker. The program will then display the name, start and end date and select a random road from the array. [code]...
I am currently using Gembox to pass text to excel and I have a problem. I have imported the required resources but when I try to pass an item in a list box it comes to an error..here's my code
'checkrow is a number loaded from that same excel Dim ef As ExcelFile = New ExcelFile ef.LoadXls("C:\Users\DF\Desktop\registro_prestamos.xls")
I am interested in developing a multi-language program that will have a main .NET GUI but will perform calculations by calling procedures from a Fortran95 dynamic link library file. Right now I am just playing around with a very simple project in order to get the interoperability between the .NET framework and a Fortran95 (*.dll) file working correctly. So far, I've been able to pass the Fortran95 (*.dll) file an array from VB, sum all the elements of the array using an intrinsic Fortran function, and pass the scalar result back to the .NET framework with no problem. However, if I try passing Fortran the exact same array, construct the transpose of that array using another intrinsic Fortran function, and try passing the transposed array back to the .NET framework I keep throwing an exception. I am not a programming wiz, but it appears that when Fortran stores an array in memory, the .NET framework doesn't know how to read that. I am looking for some guidance on how to pass an array from the Fortran95 (*.dll) file back to the .NET framework.
I have the following code below in which I have a class with some class level Excel objects defined.When I call excelModule.Test from another class all these Excel objects are getting created and I can see an Excel instance in Task manager.
Do we have unload event for class to release these objects? Module excelModule Public myRange As Excel.Range
Anyone know of some code out there that does this already? I have a bunch of pages with data grids on them in an admin website they want to export them to Excel, was hoping someone had this written already
As it is right now I have a bit of code that kind of looks like this (a little paraphrased but Im sure you get the idea)[code]I thought for sure the above would work but it still seems that I am missing something, when I open the excel sheet nothing was printed. This would cut down the lines of code that I have in half easily, so I would love to find a solution for this [code]But the excel sheets still do not update with the new information.
