Is 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 have an excel document that has a button that i need to activate through vb.net.
View 5 RepliesI 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 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].....
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]....
i recorded the following macro in excel 2007:
[Code]...
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 am currently using a binary formatter to serialize/deserialize some data objects. Some of the properties in the classes are Strings. When the data is written you can open the file with a text editor and can see the raw String data. Is there any way to encrypt the Strings or the entire object before it is serialized? I have looked at this thread here [URL] but the code is in C# and the free converters I tried for some reason did not like the code. This is the code I am using currently.
[Code]...
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 RepliesI'm writing a macro to automate the process of attaching to the IIS worker process (w3wp.exe, Windows Server 2k8) from Visual Studio. The trouble is that I often two app pools running at any given time, one in x64 mode and one in x86 mode. This means there are two processes called w3wp.exe running at any given time, and the only way to distinguish between them is the mode they are running in. When I use the "Attach to Process" dialog, there is a "Type" column that shows that information so I know which w3wp.exe to attach to, but I can't figure out how to get that information in my macro.[code]....
View 1 RepliesI 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.
I am creating a MS Access database. The database will import a table from another Access database, query for selected data within a date range. Thus, I am having difficulty with the Macro code to import the initial table. Therefore, what's the code to import a table from another access database? The database is names InputContract.mdb.
View 2 RepliesI need to be able to forward all incoming mail to another email address. The email address I need to forward to will always be the same. I can forward any mail message manually however using the rules will not work. I therefore need another method via a macro or something.
View 3 Repliesi have a complex object that holds a WPF Canvas with many child canvases, rectangles and, lines. The object includes some home grown classes as well. The main object and the home grown classes have the <Serializable()> attribute set. I tried the general formatter.Serialize(strm, rb_x) to serialize the object to a memory stream. I then found out that WPF classes are set as serializable. So after some research I discovered the System.Runtime.Serialization and found a generic Serialization Surrogate.So after some debugging I was able to serialize the object to a memory stream then copied the stream to an array of bytes then store that array in an OLE field in an MS Access table.
When I read back the access record and copy the OLE field byte array back to a memory stream and then de-serialize it back to the object I get a SerializationException "Error binding to target method."
So question #1 - is what I am trying even possible?Question #2, (assuming #1 is yes) do I need to do something special with WPF Baml type objects.
I'm writing a macro in Excel to connect to a button on an MS Excel 2007spreadsheet. When clicked the button copies some data from the file and uses the data to create a new .txt file. Since the macro is creating the file I can control the file name and storage location. Once created I want to e-mail the text file to a standard e-mail address.
ActiveWorkbook.EnvelopeVisible = True
With ActiveSheet.MailEnvelope
.Introduction = Range("T22")
[code].....
I'm automating Visio 2003 from a VB.NET app. My code looks like this (with the uninteresting stuff removed):
Dim objApp As New Microsoft.Office.Interop.Visio.InvisibleApp
objApp.Settings.ShowFileOpenWarnings = False
Dim objDoc As Microsoft.Office.Interop.Visio.Document
objDoc = objApp.Documents.Open(VisioFilename)
I've found that the last line causes Visio to raise a hidden MessageBox saying:
Macros in this document are disabled because the security level is high, and the macros have not been digitally signed or verified as safe. To run the macros, you can either have them signed or change your security level.Since this is going to be running on computers I don't control with files I don't control neither of those options works for me. I really don't care that the macros are disabled, I'm just using Visio to convert the file from it's native format to SVG. I certainly don't want to suggest to users that they lower the security level, nor would I want to lower it for them.
As you can see from my code above, I turn off file open warnings but that doesn't seem to include the macro warning. Since I'm using Visio.InvisibleApp it turns out the warning isn't displayed to the user. Running a visible instance of Visio won't help because I'm creating a batch converter, even if the message was visible it means the user would have to click OK for each file. That would make the batch conversion feature essentially useless.
I see that the Visio class has a VBAEnabled property but it's read only. If there was a way I could just turn off VBA when opening the file it would likely solve the problem. I've looked all through the properties and through the Settings property on the class and can't find anything. I've done a bunch of Google searching and can't find anything that addresses this issue.Anyone know if that warning can be suppressed when using automation with Visio? Can I do it if I switch to Visio 2007?
I'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 RepliesI am having some major problems with the code in VBA and recording a macro didn't get me anywhere nor is the VBA help file. I have to have it so that I can input a values for the x axis rotation and the y axis rotation so that my 3d surface graph will rotate whatever values I input, the 3d surface graph will rotate those degrees. I also have to have a method for having the default rotation. I was also wondering how to put scroll bars for the x and y rotation. The only other thing I am having trouble with is having an input to check box for right angle axes. So far I have two cells for entering the x rotation value and the y rotation value. I also already have my 3d surface graph.
View 3 RepliesHow can I call a javascript function from code behind?The most popular response is "ScriptManager.RegisterStartupScript" however, that does not work in my situation. I have a vb class that is doing a database check to see if a record exists. If exists, then call a javascript function to display an alert("Record exists") So I am doing something like
Dim strMessage as string = "javascript:RecordExists('Param');"
How do I call this function from my vb.net class?
I need to call this from the code behind if there is a certain value read in from a query string variable ie
x as string = request.querysting("Var")
if x = 'Hide" then
function guestHide()
[Code].....
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 RepliesI have a function that is responsible for populating an SSRS report. The user presses a button and I go out and check to see if there is data. If no data, I provide a NO DATA message. If there is data I call the SSRS report which I would like to open in a new window.
<script type="text/javascript">
function openWindow(url) {
document.forms[0].target = "_blank";
}
</script>
I have ShowValue working. Now, on the last line I need to call the function newFunction to repopulate the dropdownlist object on the onClick event.
I am getting errors when I click the dropdownlist down arrow.
How do I get the two to hand shake with each other?
My code:
Public Sub ShowValue(ByVal sender As Object, ByVal e As System.EventArgs)
lblupdatePanel.Text = DropDownList1.SelectedValue.ToString
Dim LocationDescription2 As DropDownList =
[Code].....
I'm working in VB.Net and I'm trying to make a piece of code more generic.In fact, there's a big Select Case statement that build a ProxyServer based on a value passed in parameter (a string).
Select Case _strNteraHL7
Case Constantes.NomPRPMIN306010
strUrl = ObtenirUrl("ProviderDetailsQuery", _strVersion, _strEnvir, True, _blnSimulCAIS, _blnSimulPDS, _blnSimulPDSSIIR, _blnSimulPDSInteg)
[code]....
or something similar, so I can remove all those big switch cases, that repeat the same thing 30 times.objWsHL7 being an object or type "object" at compiling.Again, in another switch case statement,
objMsgHL7Out = _objWsHL7.ProviderDetailsQuery(_objMsgIn)
objMsgHL7Out is a System.ServiceModel.Channels.Message
_objMsgIn is a System.ServiceModel.Channels.Message
_objWsHL7 is an Object
I wants to ask about how to call the javascript function/method in .aspx file from code behind(or server code)?[code]...
View 3 RepliesI have java script in my page and i want to call it from vb.net code behind from function AND didn't want to call it (onload or onclick or any similar event) but i want to call it from function doing looping.so it will be run more one time
View 2 RepliesHow can I call the Click even of a button from somewhere else in code?
View 5 RepliesI need to call a VBA Function (accepting parameters and returning values) from a VSTO Add In Code base. The macro code base in the .xlsm file is as follows[code]...
View 7 Replieshere's what I'm trying to do:I have a Storyboard animation for an object done in Expression Blend. What I need is to be able to trigger that animation from the VB.net code
View 2 RepliesI've written the following code which works fine.I'm wondering if there is not a simpler way of writing it to achieve the same?
[Code]...
I've not found any other way than using a Timer to have the status updated and the other actions done, as as soon as I start the thread, I loose control and "GetList_Button_Click" does not wait or control the thread.
The goal of using the thread is to not freeze the application and also adding a button to cancel the search in the future.