I'd like Visual Basic .net (2008) to control another program using OLE automation but I read somewhere in the net (link below) that it's not available in VB .net. How to use VB .net to control that program? The company that own the program stated that it can only be controlled using OLE automation and they made available some functions to do that.
View 7 RepliesI am creating an application for my own use in Vb.net to auto fill forms and submit the form (log in) to various websites....(bank sites, credit cards etc..the require a login)
I am using the webbrowser control on my windows form and I can sucessfully populate the controls on the form (userid, password etc), by setting the value property of the HTML Form Element using... HtmlDocument.GetElementsByTagName("Input").
My problem is that I cannot click the login button via code, sometimes it's an image and sometimes it's an actual button depending on the site that I'm auto logging in to, in both cqases the end result should me submitting the form.
I have 2 devices
An old IPAQ Pocket PC that runs Windows Mobile 4.2
A Mini-ITX PC Running XP
My IPAQ connects to my network via wireless. My Mini-ITX PC is going to have an IR-Blaster setup which is going to control all my devices. What I would like to do is create a small controller program that runs on my IPAQ and a back end program on my Mini-ITX PC, so that when a particular control is selected on my IPAQ it sends the signal to my program on the Mini-ITX PC which inturns sends the correct IR signal to the device in question.
here is what is going on. I am trying to make an automation program. I need to launch some other applications. I would like to run this program from a CD or a thumb drive, where the path name may not be the same every time the program is run. I know that App.Path is not used in .NET. Here is a clip of code.
Public Class frmStart Dim AppPath As String Private Sub frmStart_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
[Code]...
I need to use the WebBrowser control to set an item in a dropdown list. Given the HTML snippet below how to I pick a specifcate option to be submited using HtmlElement techniques? (VB, VS2005) I'm able to send texboxes, just can't figure out how to deal with dropdowns.
<SELECT NAME="certCompanyList">
<OPTION VALUE="105336">
105336</OPTION>
[Code].....
I am trying to automate a program using Visual BAsic.NET. The idea is to invoke my "Program" at the click of a button, pass inputs to the program and save the results it would generate.For now I can invoke my program using VisualBasic.NET(comands: shell, appactivate), I can pass in data to the program( My.Computer.Keyboard.SendKeys("a")),( just that it is broken).
the main problem is that the data to be input goes into a form with multiple tabs and I am not able to figure out the best way to select the correct tab so that I can throw my data in there and get to the results Also is this program has a dll( obviously I am new to windows application programming), is there any way i can directly pass data to the dll and get results?
I try to develop a automation-add-in for Excel which can get some data from our SQL DB. So i call my add from an Excel-cell.. like "=getThisFromDb()"... This works totally fine! But what if i want to write to another cell then just give a return value? I managed to get the running instance of excel. I can read from it. I can open a new document in it and write to it. ->> But can't write to the Worksheet that called me!!
View 2 Repliestrying to execute an .exe (another program) from excel, where shall i start?
View 1 RepliesI am trying to write a program using the API for SolidWorks in .NET. My first problem is setting 'set swApp = Application.sldworks', the last line of code.It is my understanding that this is simply defined as an installed application on my system (which it is), and does not even use the SolidWorks API to accomplish. Though this syntax is used in many VB6 options, i am getting a syntax error.I have tried it without the 'Set' in front, no help there.
Option Strict Off
Option Explicit On
Imports System
Imports System.Windows.Forms
[code]....
Migrating my VB code to VB.net for Visio Automation. I am getting error in Page.GetResults
"Specified array was not of the expected type".
I have a spreadsheet control on a windows form that I would like to populate with data from an existing worksheet (myworkbook.xls, sheet1).
View 4 Repliesi am developing one automate application for tht i hav done some coding i dont know how to proceed further can any one guide me if possible? [code] I am using SHDocVw for IE. Now i need to know how to do. [code]
View 4 RepliesI have written an automation addin in Excel with C# (addin.dll). To use the addin, I need to 1. register it using "regasm /codebase c:...addin.dll"2. select in ExcelOptionsAddInsExcel AddinsAutomation the respective addin from the list
I would like to automatize 1) and 2), so that the user just needs to run an exe-file in order to use the addin. 1) should be no problem, but how can one automatize 2)?
Ok basically what I need to do is the following:Read FirstExcelDoc (attached)For every row in that: Retrieve data from sql server db based on info in the Orange columns of FirstExcelDoc Let's say I retrieved data elements A, B, C, D, and E from sql server. Then I need to enter those same data elements A, B, and C in another excel spreadsheet (which has formulas etc) After inputing A, B, and C in that spreadsheet, read a couple of calculated fields and compare those results to data elements D and E retrieved originally from SQL Server DB. Finally, output the results in the Blue columns of the FirstExcelDoc spreadsheet for that row.Loop through and do the same thing for row 2 of the FirstExcelDoc and keep on until you see "END TEST" in the FirstExcelDoc.
I'm looking for a method of doing this efficiently. I have read several articles over the past few days as well as those from Mike R. but just need some direction to get started on this.To start of I'm looking for whether to read the entire FirstExcelDoc spreadsheet or just read the info for first policy number(2nd row) and process it and write out the blue column info for that row and then loop through and come back and read the second policy number (3rd row) etc... Please attach a code snippet for either way of reading the data.
I'm using excel via interop in application.Sometimes users kill application that created excel instance and that results in excel instance sitting in memory without any chance of disposing it.First I tried to tackle this using ROT(running object table) looks like not all instances of excel are registered there.Than I tried to somehow mark excel process after it is started via interop.[code]This works as long as excel is visible but in my case excel window is invisible.All I need is to somehow mark process that started via automation with the parent PID, so that later I can kill it if parent does not exist.
View 19 RepliesI have successfully automated a PowerPoint Metrics presentation with VB.Net. However, since there were many complicated calculations, it took quite some time to make the 120+ slide presentation - so I recently tried to revamp the application to be multi-threaded.
[Code]...
I've got VS2008 and Office2010, but I don't have Office2007. Therefore, I have the Word14 Object Library but not the Word12 Object Library. Will the code that I create for Office2010 automation also work where clients only have Office2007 or will they have to upgrade their office suites?
View 1 RepliesI have a program that at one point will open word and export some info. That works perfect, however I have just noticed each day I have a number of winwords open (can only see them in task manager so they are hidden). It appears that everytime I start the program it opens a hidden winword session. It has nothing to do with the code I have on the form, it opens before any code I have written is executed.
View 3 RepliesI have been pulling my hair out trying to fix this.
[Code]....
We have a vb program which is run on our server by scheduled task every day. The program opens about 30 excel files, refreshes the data connections, pivot tables and then saves the document in another location.
This may run fine for a couple days but sooner or later the process starts crashing, usually with this error: RPC_E_SERVERFAULT.
My question is, Is it expected that continually opening/closing/refreshing workbooks will inevitably cause the Excel object to crash at some point.
I'm having an issue where my excel.exe process doesn't close until I close my .net application. I'd like to avoid using Process.Kill() if at all possible.
Code:
Private Sub WriteRowsToXls(ByVal rows As DataRowCollection, ByVal xlsPath As String, ByVal showStatus As Boolean, Optional ByVal AddTotals As Boolean = True)
Dim xlsApp As New Microsoft.Office.Interop.Excel.Application
[CODE]............
This method references a couple of other methods I use for repeated formatting tasks, I'll include those methods below. (I added the FinalReleaseComObject into the other methods after reading Mike's thread but the issue persists)
Code:
Private Sub SetRangeValidation(ByVal rng As Range)
With rng.Validation
.Delete()
[CODE]..............
Method SetRangeAllBorders does about the same as these other methods but my post is too long to add it. The only other things not shown in these code snippets are a few string variable that are defined in the class, studentWS, studentsWSPW, paymentsWS and paymentsWSPW My App creates an instance of the class, loads some data, runs the method above, and then sets the class to nothing. I'm using .NET 3.5 automating Excel 10
I wrote a simple Automation Addin using VB.NET and .NET 4 and want to distribute it's dll to a
computer with xp sp2 and Office 2007 (Excel 2007) without I install .net on that computer, is it
possible?
This might seem a ridiculous question but I just want to make 100% sure before I start committing any funds to software purchases. Can I use VB2008to develop automation routines to control Office2010 applications or must I absolutely use VB2010 to do so?I ask this because I installed an Office 2010 pro on my station which already has VB2008 and I do not have any Word14 reference in the COM section of the list of references...
View 1 RepliesI am writing a program that loops through all of the sheets in an Excel workbook and saves each sheet as its own workbook. It turned out to be a bit trickier than I expected, since the Sheet.Copy method creates a strange object (see here for the MSDN discussion that I believe is relevant: [URL]. Anyway, I found a Stack Overflow post [URL] that got me to where I am, which is essentially complete, outside of one hanging EXCEL.EXE process that is left after the program completes, which I believe is a result of the sheet.copy method creating a new workbook (potentially a new application as well?). The other thing I run into, which I believe is related to this, is that even though I have my application set to visibility off, when I run the program, excel still opens up and is visible going through the steps.
Here is my code:
Code:
Imports System.Data
Imports System.IO
Imports Microsoft.Office.Interop
[CODE]...
Now I think the problem comes from the end of the loop, where I try to close the export file and the new worksheet it creates:
Code:
'close excel and release com objects
System.Runtime.InteropServices.Marshal.ReleaseComObject(exportsheet)
exportsheet = Nothing
xlApp1.Workbooks(fileNames(counter - 1)).Close(False)
I can't figure out what to do to release the `ComObject` for the new worksheet that is created. I have been trying all sorts of things, but it always throws a COM error when I do it and if I try to define it as nothing (like I do with exportsheet) is says that it is read only by default, so I can't do it. It seems like it should be something as simple as: System.Runtime.InteropServices.Marshal.ReleaseComObject(xlApp1.Workboo ks(fileNames(counter - 1))) But that is not the case. I have tried a few variants of this and I am thinking it has to do with the MSDN link above, but I can't quite sort out what to do. So the code works for my purposes, outside of leaving one EXCEL.EXE after it is done. As far as a test file, I am just using an Excel file with 3 sheets and I put some information on each and change the sheet name, so it is easy to see if it is working or not.
I am in the process of designing a computer control program to control a HF communications receiver (radio), and have found a problem with the Serial port. I am using VB Express Edition 2008. This module of the program is supposed to take an input string from another part of the program, format it, break it into 4 bytes, and send it to the radio in hex form via COM port 1. The problem comes in when you try to enter a frequency with an 8 or a 9 in it. The 8 or 9 is usually replaced by 45, ex.-input 9900, receiver tune 4545. The exact same thing happens with 8's, input 8800 and receiver tune 4545. All other numbers other than 8 or 9 work fine. The strange part of it is that sometimes the 8's and 9's work, and work correctly. For instance, 900, 1900, 2900, 3900, 4900, 5900, 6900, and 7900 all work correctly. This led me to believe that is may only be when the 8 or 9 is in the first position, but that is not the case, it also shows up in other positions as well. All other frequencies that do not have 8 or 9 in them also work. I ran into this same problem with VB Express 2005, and worked on it for weeks before giving up and going back to VB6.0. This same module (with exception of the port open command) runs flawlessly under VB6. I have even tried importing the MSCOMM control from VB6, but it gives the same results. In de-bugging mode, all of the inputs, decimal and hex seem to be correct, so the problem must come in after you click the command button, but before it leaves the COM port.
[Code]...
I need to manipulate an external edit control from with in my program. (IE: Get new text whenver it's being enter into edit control and parse the infomation in my program).So, is it possible to create an edit control in my program that base on the handle of an existing application using win32 api or something
View 4 RepliesTrying to Automate the VBA code from C#, the existing VBA code is a legacy code which has hundreds of nested calls within.Automate these VBA routines from C# and during the Automation there could be some COM objects which needs to transacted between VBA and C#.COM Objects currently have a Interoperability wrappers to C# and they are being developed in VB and C++?
View 2 RepliesI recently found an awesome tool called "Freemind" that is called a 'mind mapping' program. It's similar to MS Visio but way cooler and more automated.I reeeallly would like to integrate this into a VB.net Form, but how?
Has anyone seen or heard of mind mapping inside VB.net before? Are there programs out there already that work with VB.net or anyone have an example they have seen / built that works?
I am developing an application using excel automation.The worst thing is the client's side doesn't have excel installed.What is the solution for this case?
View 17 RepliesIt appears that when one creates an instance of Excel, using CreateObject, (Late binding), the suggested Excel closing function (with GC.collect etc) does not work. I have tried several suggestions, and the only one that works is process.kill method. Do you see any problem in using this? BTW: the reason we are using late binding is that we cannot use Office PIAs....not sure which version of Office would be installed on the client site. We work with O2003, but the client might still be at 2000 or 2002.
View 7 Replies