Webpage Form Input Automation?
Oct 5, 2011
I have a list of data which needs to be inputted into many different fields on a webpage. usually about 1000 or so and i am trying to automate this using vb.net but i couldn't find a better solution than using appactivate and sendkeys. this solution definitely isn't very accurate and reliable.
is there another, better way of accomplishing this?is there a way to find certain input fields on a webpage, set focus to it and input data in a more reliable way? the way i have it written at the moment is appactivate and tab to certain fields and input data using sendkeys.
View 5 Replies
ADVERTISEMENT
Jan 8, 2009
I would like from a certain url, to launch an excel file, have the user fill some cells and then return the value to a database by aspx perhaps.
View 3 Replies
Apr 21, 2009
I am trying to get ALL these input values and only these values in a checkedlistbox.....
<input type="hidden" value="20904198" class="userid">
<input type="hidden" value="tj... " class="firstName">
</td></tr><tr>
View 7 Replies
Feb 21, 2012
I have a web page that reads xml files to display server statistics. Ideally i want the users to be able to setup and save multiple connections to different servers. They would then be able to choose which server they wish to view through a asp.net web page.
View 2 Replies
Mar 3, 2011
I have a web page that reads xml files to display server statistics. Ideally i want the users to be able to setup and save multiple connections to different servers. They would then be able to choose which server they wish to view through a asp.net web page
View 7 Replies
May 17, 2010
I know the code to find the input boxes in question.. basically the html is like so HTML <input type="text" name="username" class="inputbox"> i know enough to use WebBrowser1.Document.Forms.GetElementsByName("username") to find the text box...but I need to know how to send the contents of say TextBox1.text to the form on the web page...i can't figure it out for crap...I just assume give up and use sendkeys to tab to the textbox even thought its 80% unreliable....
View 2 Replies
Jul 1, 2010
Using ASP.Net & C#. I want to run my web page in the internet explorer or firefox. When I run the webpage, it was working in VS, but when i run the webpage in the i.e., it showing error as:
The XML page cannot be displayed. Cannot view XML input using XSL style sheet. Please correct the error and then click the Refresh button, or try again later.
A name was started with an invalid character. Error processing resource 'file:///C:/Inetpub/wwwroot/Name/IIS/Detail
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="view.aspx.cs" Inherits="Default2" %>
-^
I configured the IIS, then I run the *.html file it is displaying without any error but *.aspx file is not displaying.
*.html file is running in ie & firefox, but *.aspx file is not running in ie & firefox,
How to run my *.aspx webpages in internet explore or firefox...
View 4 Replies
Jul 5, 2011
I have some code that broadly looks like the following ...
WebBrowser1.Document.All("btn_submit").InvokeMember("click")
WebBrowser1.Document.GetElementsByTagName("select").Item("id_pickupdate").SetAttribute("value", "2011-07-07")
I cannot seem to get it to work in one code routine. I end up having to have a separate button to set the date after the page has loaded. I have tried all the blog posts using isbusy, timer etc but it does not seem to work. The code breaks and the error prompt says that id_pickupdate does not exist.
View 3 Replies
Sep 25, 2010
I have a problem with the code, I have input the valid username and password in the form textbox to input the strings in php, but it keep displaying the messagebox that says login failed.
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
MessageBox.Show("Please enter your username")
ElseIf Textbox2.Text = Nothing Then
MessageBox.Show("Please enter your password")
Else
[CODE]...
I don't really know why it keep displaying the messagebox that says it failed when I have input the valid strings in the first place.
View 1 Replies
Mar 16, 2009
how to input a data/value to excel through vb input form and get the data/value from excel back to the input form?? (For example: put a number into exel A1 from input form and get another number from ecel B1 bact to the input form)
View 1 Replies
Jan 22, 2010
i 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 Replies
Sep 3, 2009
experience on how to create an engine using C# (VB.NET is okay too) that is generic enough to handle most cases of MS Word text fields I need to fill with data I'm getting from a database? In short, I'm about to embark on this little Office automation excursion and I'm hoping a little bit of feedback here.
View 2 Replies
Jan 25, 2011
I 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)?
View 12 Replies
Apr 20, 2010
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.
View 19 Replies
Jun 17, 2009
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 Replies
Apr 16, 2010
I 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]...
View 1 Replies
Jan 21, 2012
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 Replies
Jul 1, 2010
Given vba's fairly lamentable image manipulation abilities, I'm considering going down the VB.NET form route. My hope would be to allow some degree of interactive manipulation and then either pass the image back to vba or save it and load it in vba.I'm happy to investigate the latter part of it at length under my own steam - however, I'm not versed enough in VB.NET forms to know if calling them from (in this case) Access VBA is a practical or doable - and whether it's possible to pass data back and forth.
View 9 Replies
Dec 2, 2009
I have a VB 2008 Forms application which does Powerpoint automation.I am opening Powerpoint in a minimized window from within my app and am trying to periodically put update messages in a textbox on my main form while the automation is running (it takes a few minutes to complete), but my form window does not want to show these messages until the powerpoint operations are finished.It seems as if I need to force a window refresh or something on my windows form, but I'm unclear how to do that. Below is some code that I'm using that illustrates what I'm trying to do.When I run it, "Step One / Step Two / Step Three" do not show up on my textbox until after the Powerpoint automations are over.[code]
View 1 Replies
Dec 17, 2010
I have been pulling my hair out trying to fix this.
[Code]....
View 1 Replies
Jun 1, 2010
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.
View 3 Replies
Jul 24, 2011
The problem with the following code is that the object oWB is visible and initialized in Form2, but when I show SaveDialog1, the object gives a NullReferenceException. I already know, because I checked in the debugger, that oWB has a valid reference when I leave Form2 and also when I come back from Form2. So I am sure the problem is that the reference simply is not visible in SaveDialog1 for some reason. So please don't tell me that the initialization of oWB returned a Nothing reference because I know it did not.
I get a NullReferenceException on the following line:
Form2.oWB.Save()
I researched this for a whole day and came up with a Microsoft article that explains that it is necessary to run each form of a .NET COM application on its own thread. It gave some code to accomplish this. I incorporated this code into my program. But I still have the NullReferenceException.
Simplified version of Code with most processing deleted below:
Public Class Form2
'Define Microsoft Excel Objects
Dim oXL As Excel.Application
[Code].....
View 14 Replies
Oct 29, 2011
I've created a shared add-in for Office that adds a button to Office application.
If I am using the button to show a message, it works good:
Code:
Sub settingsPressed(ByVal control As Office.IRibbonControl)
MessageBox.Show("Hello")
End Sub
But I am not able to use it for opening Windows form:
Code:
Sub settingsPressed(ByVal control As Office.IRibbonControl)
frmSettings.Show()
End Sub
The .Show() command is not available and is not proposed by intellisense.
Of course I've added a reference to System.Windows.Forms
View 2 Replies
Aug 17, 2011
i made an application in VB2010 where the application should be always on top above one specific window. Anyway i set the property of the main form to "topmost = true". The application is also writing some data to excel which is not a problem but the excel workbook is behind the main form which is on top. Is there any way to put the excel window on top above the main form?
View 1 Replies
Apr 5, 2010
Need to show visio diagram on .net FORM, and need to be able to click on the shapes. Thats it. no creation, no stencils, no editing. Basicly just catch the click event from axDrawingControl.I'm having a "very" hard time to dig trough the visio DOM, disabling all of the functions, tool bars, menus..I basically will ever need a view-only diagram. So, to all the interop gurus out there, point me in the right direction please..I have the SDK, its (crap) not very useful in my case. Seems like a lot of resources wasted and lots of hustle for view only.
View 3 Replies
Sep 25, 2009
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
View 2 Replies
Aug 13, 2011
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?
View 2 Replies
Oct 20, 2011
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 Replies
Mar 23, 2011
In VB.NET I've got two forms, on first one I have button, on second - two textboxes and "OK" button. I want to run procedure (Sub) on first form, then stop in the middle of it and wait for input on the second form. After that i want to process the data received from second form.
It looks something like this:
Public Class Form1
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
'Open form2 for input
[CODE]...
The question is how to call the Form2 so that procedure is stoped till the second form is closed?
View 3 Replies
Mar 10, 2010
i have an aspx page with vb.net back end. in that page i get names and url's from the database depending on different conditions. My requirement is that when i get the url, the code should then use that url and have that webpage in a small preview form on my existing aspx page. so basically i have a table as follows -
[Code]...
View 1 Replies
