I have an application that used Macro.In this macro I would like to call an external executable like this:
SYSTEM( "C:ProgrammeTransform.exe" ,
"C:ProgrammeVectors.txt" ,
"C:ProgrammeVectors_Compensate.txt",
[code].....
I'm looking to create an inline function (method) inside my NVelocity template. The solution to this appears to be to use Velocimacros. So, I mocked up the following template to test:
#macro( getOutput $one $two $three )
<td>$one</td>
<td>$two.Item2</td>
<td>$three</td>
#end
[Code] .....
When I run the template, the problem I'm having is that the output from the macro parameter $three is literally "$item.Item3" instead of evaluating to #3/3/2003#. (BTW - this happens with any of the 3 items in the tuple if they are passed with the .Item call, so it isn't about the data type). I can make a variable and pass it just fine ($one1). I can pass the tuple itself and call the .Item property inside the macro ($item.Item2), but for some reason I cannot call the .Item property when passing the argument to the macro.
I'm Trying to Call the Stored Procedure which has one input Parameter and one output parameter . VB.net code is below
[Code].....
i need to run a dos command with parameter and write out on text file from my win form , i am not using shell command and the code is -
[Code]...
I have an excel document that has a button that i need to activate through vb.net.
View 5 RepliesIs it possible to call the VB code formatter from within a macro? I wrote a macro that automatically adds a call to the logger in side an function or sub when it is created. But when I change the TextEditor.Enter command to my macro, no code formating takes place. Is there a way to call the original command Edit.BreakLine(Enter(TextEditor)) ??
View 2 RepliesI'm looking to call an excel macro (excel version 07) within a separate visual studio application (visual studio express 2010). Basically, a user clicks a browse dialog button to select a xls or xlsm file which is then added to a listbox. Next, I would like the macro to run when another button is clicked. The macro looks at the first column in excel and moves the listed .tif images from one folder to another. I referenced the excel libraries, but seem to be getting hung up on a few code statements (''''ERROR see code below). I would like to run the macro within visual studio for any selected excel file or add the macro somehow to the selected excel file and run it.
'Here is the button click procedure
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
filenames = lstFiles.SelectedItem
[Code].....
I have a vbscript that runs under asp page. I need convert the code to VB.NET
SET objCommand = Server.CreateObject("ADODB.Command")
objCommand.ActiveConnection = Application(DB)
With objCommand
[code]....
What is the VB.Net that will do exactly the vbscript does? I like paramer(0) and 1 and 2 etc since I don't need to define the parameter(0) as integer or varchar etc. I remembered I have discuss this before and it is possible to do in VB.NET?
As you read this, though I have pretty good experience in C++ and Java, eep in mind that I am a complete beginner when it comes to VB. :)Here is one idea of what I want to do:
Option Strict Off
Option Explicit Off
Imports System
[code]......
I want to launch a java executable (let's call it MyApp.jar) from .Net using System.Diagnostics.Process.Start. What's the syntax in VB.Net? The command line syntax is this (if I recall it correctly - because i tried it a few days ago and it worked).
java.exe -jar MyApp.jar pathToSourceFile pathToDestFile
How do I run this command in VB.Net, using System.Diagnostics.Process.Start, assuming I have the following three string variables in VB.Net
pathToJavaExe
pathToSourceFile
pathToDestFile
I build two programs, 1 - bootstrap and 1 - mainprogram
now, mainprogram has 2 constructors, the default and the one which i defined and it accepts an integer the default constructor checks the variable named iscalled a type of integer to have a value of 1 or zero, if its zero then it should shows a message saying "Improper initialization" then exits..
What I mean here is, mainprogram should only run if its called by the bootstrap program.
I have had some trouble on what to put inside the parameter named CallFWT as without it i would get a value of 0[code]...
View 2 RepliesI wrote vba function in excel and I want to call this function in vb.net with parameter passing.
View 2 RepliesI'm have a program (GUI) that interfaces with excel to execute macros. We're using Microsoft.Office.Interop.Excel to call/run the macros and this works great.What I can't figure out is a good way to cancel the macros from the GUI.One idea we had was to use the excel.application variable that runs the macros to write a "stop" value to a specific cell in the workbook, and in the macros (they are all mostly loops), check for the "stop" value in that cell. This crashes my GUI with this The program '[2188] BVLReports.vshost.exe: Managed' has exited with code -336589910 (0xebf00baa).And excel gets tied up, and won't respond. I know how to Exit Sub from within the macro if the "stop" value exists, so I don't need answers on how to check/cancel from inside the macro. Any ideas on a better way to write this "stop" value or a better way to cancel the macros externally?
View 2 Repliesin my SQL 2005 database I have defined this stored procedure:
CREATE PROCEDURE [dbo].[CheckOrders] (
@PK_Customer uniqueidentifier,
@Amount bigint OUTPUT)
[code]....
When I check the value of nAmount it stil contains the original value -1 the output value didn't return from the stored procedure although the number of records updated is 0 or more. The procedure was checked, it works and there are records updated and the value of @Amount is SET to a value 0 or more. I just don't get the values back. eventough the parameter @Amount is defined as OUTPUT. I also tried with outParam.Direction = Data.ParameterDirection.InputOutput instead of outParam.Direction = Data.ParameterDirection.Output . Same result. How do I get the value back from the stored procedure?
I have a SSRS report that contains a parameter called @playerID
what coding I need to add so the report can be run using the parameter?[code]...
how to call a stored function in oracle through vb.net.From vb.net should i able to pass the values to arguments of that function without knowing the parameter names?Example: I have a function,Create or Repalce Function Func_Name(param1 Varchar2,param2 varchar2)
Inorder to call this function through vb.net, we need to give
parameterargs.paramtername="param1"
Is there anyway so that i cannot use the parameter name and call the function
I have a program that outputs a file. I want the user to be able to just double-click the output file and launch the program, just like Word and Excel. In Word for instance, one doesn't necessarily have to open WORD then click on File--> Open and locate another Word doc. He can just go to the folder and open the Word doc. I want to implement the exact scenario in my program.
So far I have tried creating TextFile and added it to the Resources. On FormLoading, I simply I stream-read the Resouce file, but I can't write to the Resource on FormClosing, since the Resource is ReadOnly. Also, the Resource is built & compiled so I suppose you can't add anything to it at run time.How you lunch an output file without launching the Executable program that created it?
I have an executable that I was able to get working on all XP machines by registering all the .dll's associated with it.On Vista, however, I go through the exact same registration process but right when I open the executable it goes to a "WindowsApplication1 has stopped working" dialog. I registered the DLLs in the SysWOW64 folder. I also ran Dependency Walker which came up with IEFrame.dll as flagged, don't know if that is relevant though.
View 6 RepliesI am creating a function and want to have IntelliSense pop down the list of valid options for a certain parameter in the same way that the MsgBox function behaves when you are typing your argument for which buttons you wish to include (such as MsgBoxStyle.OkCancel). I have done my best to search the internet but haven't found a thing which comes close to what I'm seeking. My monkeying around hasn't produced a satisfactory solution, yet, either.
A related additional thing, which I can live without but that would be nice to have, is the description of the current parameter, which appears below the function description as shown highlighted below MsgBox (Prompt As Object, [Buttons as Microsoft.Visual Basic.MsgBoxStyle = MsgBoxStyle .DefaultButton1], [Title as Object = Nothing]) AsMicrosoft.VisualBasic.MsgBoxResult
Buttons: Optional. Numeric expression that is the sum of values specifying the number and type of buttons to display, the icon style to user, the identity of the default button, and the modality of the message box. If you omit Buttons, the default is zero. This is my first post. I'm relatively new to VB .Net.
I'm attempting to communicate via USB to a hardware device. So far I can use CreateFile, ReadFile and WriteFile to communicate with the device efficiently, but occasionally the WriteFile call will hang because there is no device located at the port where it was installed. I have the WriteFile and ReadFile calls in a managed thread that I use the Join() method on to return control to the parent thread.
View 17 RepliesI have a DLL , written in VB.Net. This DLL has a below Function: Public Shared Function CreateApplication(ByVal aobj As Object) As Object When i Try to call this function by exe application with below routin i get "Parameters count mismach" Error. Public Function loadDllAndRunMethod(ByVal dllFilePath As String, ByVal className As String, ByVal methodName As String) As Object
[Code]....
I Actually want to provide a new service which requires creating executables on the fly from executables generated in vb.net. For example lets say I have a form with a textbox and in that textbox we pass an argument which is for example the serial of the product, then we have a button which once clicked will generate an executable on the fly which has also a textbox requiring that serial to run? That was only an example but the main thing is how to generate that exe on the fly.
View 4 RepliesFollowing code doesnt work and raise error "A parameter is missing. [ Parameter ordinal = 1 ]".What s wrong with it?I am developing pocket pc application in vs 2008 and sqlce 3.5 sp1.
[code]....
I want to have a "template" function that can receive different parameter and a type parameter, like:[code]But Vb told me that tupeList is not defined... is there a way I can do that?
View 2 RepliesIs it possible to make a procedure have a single parameter but the values for that parameter are more than one? I have this procedure:
Public Sub autoComplete(ByVal cboCombo As ComboBox)
With cboCombo
.AutoCompleteMode = AutoCompleteMode.Append[code]....
Now I was wondering if there is a way to use it like this:
autoComplete(myCombobox1, myCombobox2, myCombobox3)
Or can I use a procedure like this with 'With...End With'?
I have a method which requires a parameter to be passed in. I would like to use the Addhandler to call the method through a dynamically created button control's click event.
When I include () in the AddressOf, VS complains: 'AddressOf' operand must be the name of a method (without parentheses).
When I exclude the brackets, VS complains: Method '...' does not have a signature compatible with delegate...
My code:
CODE:
One of the things that I think is really cool about VB.NET is how built-in functions and subs have extra help text in their ToolTips like "Expression: String expression to search for replace string." as well as the usual "Replace(...parameters...) as string" text. So are the pop up boxes with things like "CompareMethod.Binary" or "CompareMethod.Text." And finally I like how some functions and subs have different sets of parameters for the same routine. For example, New FileStream() starts with either a path (string) parameter or handle parameter, but none of the 15 sets of parameters contain both path and handle parameters. Is there a way that I can set up the classes and functions I write to use these things or do they only work with built in classes and functions? If there is a way, what are the proper names for them so I can look them up in the VS/VB documentation? I would be happy enough if someone would give me an example of them, but it would be nicer if I could go through the documentation and find out if there are other cool things that are related or near by.
View 3 Replieshave an idea on what i am doing wrong here:
Compiler Error Message: BC30455: Argument not specified for parameter 'dteRDate' of 'Public Sub New(strOName As String, strOAdd As String, intOPhone As Integer, strVer As String, dteRDate As Date, dteWDate As Date, strONote As String, strOrName As
[code].....
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.