I have created a project using VB.Net(VS2008) and created the exe file. I have another project in VBA (Excel 2003). The project basically IC-Testing based. So according to the device type the Excel workbook name varies. For example I have AAAA.xls, BBBB.xls, CCCC.xls. When I open AAAA.xls, I want to call the .exe (which is developed in VB.Net) with the variable "AAAA". i.e when the exe program runs, it knows which Excel is opened or from which Excel the .exe is called. now I am using Shell retval=Shell("d:Monitor.exe",1). Using this the exe is called and running fine. But the Monitor.exe doesn't know which Excel called it, whether it is AAAA.xls, BBBB.xls or CCCC.xls.
I am trying to use the value of one variable to call another variable of the same name.I have 2 variable one called VAR1 and VAR2.
The variable VAR1 has a value of "VAR2" The variable VAR2 has a value of "HELP"
I want to be able to get the value VAR2 from the variable VAR1 I have defined the value of VAR2 early in the code and now I want to call that value by using the value of VAR1.The reason I am doing it this way as I have a list of 50 variables that are pulled from one system. Each of these variables have the same name as the columns of a spreadsheet. The total number of Variable stay the same but the total column headers may vary each time. I need to loop through each of the column headers match them with the variable names and add the data to the spreadsheet.
VAR1 = "VAR2" VAR2 = "HELP" i =1
[code]....
This is the tricky bit...if the value of the cell(1,i) = "VAR2" How do I get it to display the value of the variable of the same name In this case how will I get it to display "HELP" when I only have from the VAR1 value "VAR2" I know my code will bring back the value as a string but I want it to bring back that string as a variable and display the value of that variable?
Im new to VB and have written an application which copies data around a network. Im trying to simplify the code that does the copying so i can get it to run as a module.[code]...
I have searched, but am not exactly sure what to call this process, so it's difficult to know what to search for. I have a set of functions that are almost Identical, so I want to call them, for example, function1(), function2(), function3(), etc. I want to be able to define and call them with a bit of code that says something like.
I'm attempting to set a variable from a variable i've searched high and low and looked in many books but still to no avail. I guess i'm using the wrong keyword.I have many public variables like this:
So I am having an issue where I want to call a variable without addressing it directly and I get an error for it:
Conversion from string "player1BuzzLock" to type 'Boolean' is not valid.
This is technically correct but why would it fail?
Dim player1BuzzLock As Boolean = False Dim PlayerNum as Integer = 1 '... Dim playerBuzzLock As Boolean = CType("player" & PlayerNum.ToString & "BuzzLock", Boolean)
This is probably a dumb question but I have to call one of 30 or so global variables by constructing the variable name to be called from another information. However when i do that it treats it as a string. Any ideas on how to make this work?eg something like this:
Public gsNewYork As String public sub Getinfo dim lslocation as string
I have this public class Public Class commonSettings Dim etcString As String = "some string" End Class How can I call etc String and use it entirely on my code?
i would like to call a funtion whos name is in a vairable.
Dim Car_service As String Private Sub ComboBox_Spray_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles ComboBox_Spray.SelectedIndexChanged Car_service = ("Spray_" & Me.ComboBox_Spray.Text) end sub
Call spray_Standard 'this is what i need to change standard is what comes from the combobox 'but i would like to call the funtion depending on what the combobox.text was eg,' if combobox.text was Parkingsensors i would like to call the function call spray_parkingSensors
Private Sub Spray_Standard() Price_Subtotal = 0 Price_Subtotal = (Damagecount * 65) Car_Price_Subtotal.Value = Price_Subtotal End Sub
I have 2 question, hope somebody give me an explanation: 1. Should a local variable call dispose method and set to nothing? 2. If some method have an arguments which it is a ByVal argument, it means a method create a new object? But If it is a ByRef argument, it means a method don't create a new object?
Is there a way to call a procedure in Visual Basic (.net) with a variable name? For example, the variable strColour can be one of 10 pre-defined values, green blue black white red pink orange yellow indigo purple. How to handle each one is in it's own Sub Routine, colgreen, colblue, colblack and so on.
I can use a bunch of if..then..else and select case, but what I'd like to have is something like VBA Excel's Run "col" & strColour
I am getting the error:"Range variable 'sender' hides a variable in an enclosing block or a range variable previously defined in the query expression."for this
Imports System.Data.SqlClient Imports System.Linq Public Class Form1
[code]....
I can select any other item from the table without the error. "sender" has the same properties as "receiver" in the SQL table.
So I'm trying to write a MasterMind game, but I have a problem I have 40 pictureboxes set up in 10 different rows, and I want to have one code handle all 10 rows, rather than copying and pasting the code and changing the names of the pictureboxes. I've been trying to use a variable to achieve this, but if it's possible, then I don't know the correct way to do it.This is what I have right now:
i need to call mdi form toolstripmenuitem name using the string variable. for ex, mdi form is Form1. toolstripmenuitem is customer master if i do like that "Form1.customer master.Enabled=True" its working
but my issue is i stored customer master in a string variable like mystring="customer master" i need to enabled using the string variable like Form1.mystring.enabled=True
I have a subroutine that passes several variables to the called subroutine.I want one of the variables to be updated by the called subroutine and then check for the change in the calling subroutine. My code works fine except that the variable I am checking
calling Sub routine Code: Public Sub ProjectName_Exit(Cancel As Integer)
In my project I am using a LINQ to SQL class that contains a stored procedure which includes a string value as an output parameter.So to capture that, I created a string variable as follows in the procedure:Dim spOutput As String? However, when I do this I get the following message "Type 'String' must be a value type or a type argument constrained to 'Structure' in order to be used with 'Nullable' or nullable modifier '?'"
I connected to the Informix server using RazorSQL, created a stored procedure and tested it, getting the expected answer, so the procedure exists in the database in some form.
I then run the following code:
If ConnectToInformix() Then Dim cmd As New IfxCommand("dc_routeHasOutstandingQuantity", conn) cmd.CommandType = CommandType.StoredProcedure
[Code]....
This error does not occur when calling the stored procedure from a live SQL connection.
Is it possible to use a variable in a variable name? More specifically, I want to dynamically create labels on tab pages that are also created dynamically. I won't know how many labels to create when I'm writing the code, however. What I was thinking of doing was declaring variables that increased every time for each label like this:
I want to create an ExpressionTree where a Func(of Vector, Vector, Vector, Vector, Double, Double, Vektor) should be called. So I use
Expression.Call(Forces(0).Function.Method, {Vec1, Vec2, Vec3, Vec4, Double1, Double2})(Vec1-4, Double1-2 are declared as ParameterExpression and Forces(0).Function as Func(of Vector, Vector, Vector, Vector, Double, Double, Vector). But I get an AgrumentException, because Forces(0).Function.Method has seven Arguments. (System.Runtime.CompilerServices.Closure as seventh argument at Index 0).
I have created a small exe that receives some arguments, then creates and start a process (runs ghostscript) to create a png image of a pdf.The whole system works fine except when the exe is called more than once at the same time. My understanding is that i thought it would create a new instance each time it is called, but this doesnt seem to be happening.Is there a way i can 'queue' the requestes to exe so that the previous request completes then the next one begins and so on.[code]
