Automation Of Internet Forms
Dec 7, 2009
I want to write an app which would automatically fill an internet form with different inputs, depending on its own input.The thing is, I have no idea how the VB-Web interface works. I have seen the inet controller, but the only use of it I've seen is retrieval of the data on the web page. What I actually need is:
a. VB to open a certain web page.
b. VB to choose an option from a drop-down list.
c. The page will change to another page (depending on the choice in b).
d. VB to fill a form consisting of drop-down lists, text boxes etc. After each of the fields is filled, the page refreshes itself.
e. After all fields are filled, VB should click on a link which would open a different part of the form.Follow steps d+e a couple more times, and then submit the form by clicking a certain button.
View 1 Replies
ADVERTISEMENT
Mar 26, 2009
I have a simple program made in VB .NET 2003 with a few functions. I want to call these function from another application with automation.How can i do this?
View 3 Replies
May 19, 2010
recently I've been going through some website login automation and ended up with creating a simple my own browser quite happily, to open websites and login straight away.
But I found out that I can't automate some of the websites I was going for, because the html code of the login forms is not shared and cannot be seen in the source.So I'll give you guys a couple of websites I can't deal with and please advice if it is possible to do stuff with them:[URL]...
View 6 Replies
Jan 27, 2011
I am trying to an Internet Cafe Management program, I have created a form with a start button for users to click, it starts the timers, and then a Finish button which clears the timers and brings the start button back up. That is as far as I have gotten.
What I am stuck on, is I want the timers and finish button to be constantly visible on their screen (Never behind any other windows they have open) and I also need to create the server application which when the finish button is pressed it sends the time to the server application and also calculates the price to charge the customer.
I preferably dont want to be given some source code to download and use that, I am wanting to make this as a learning experience for me.
View 6 Replies
Sep 28, 2011
I am trying to programmatically post to a textbox on a web form in IE - I have tried sendkeys - but I dont find them reliable or consistent - The code below is perfect - but only seems to work in a webbrowser control. How do I (click a button/select a radiobutton) send 'hello world' to a textbox on a webform in IE? By the way I would be happy to use the webbrowser control (so the code below would work) - but the webpage (which is not the one in the code below) runs locally on my machine (I dont have any control over it) and does not seem to work within a webbrowser control. PS go easy on me - I'm a Newbie/Thick Public Class Form1 Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
[Code]...
View 1 Replies
Mar 12, 2010
This part of visual basic is new to me. How can i make multiple forms that each operate on different computers but can interact with each other and influence each other over the internet?
View 2 Replies
May 27, 2010
I am developing a application where a url is supposed to be passed to Internet Explorer using a search button. But if more than one url passes it should open in same instance. I dont want new instance to be opened every time. I am using SHDocVw.dll for the same. I have coded for opening a new IE instance and URL is getting passed successfully. But meanwhile if I close that open IE then I get exception and my program dont work.
View 1 Replies
Aug 31, 2010
When I make an application using an HTTPWebRequest to connect to the internet, the GUI freezes whenever it's doing something. When I run the WebRequest on another thread, it still freezes a bit. Is there a way to completely stop the freezing?
View 3 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
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
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
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
Jan 31, 2011
I've been looking for a way to do this for like two days now, and no luck.
What I want to do is get into the temporary internet files, find a certain file....
(^^^ I can do that just fine (using specialfolders, etc) ^^^)
and get the internet address associated with it.
See the attachment if you don't get my meaning.
View 1 Replies
Oct 15, 2011
we have our system running but our system needs to be modified because we did something wrong...we are doing an "Internet monitoring System" in our school library where the user can only access the internet 1hr a day, and he/she cannot use the internet within that day if he couldn't buy a time on a serve...every students should only have 20hrs time usage per semester...our problem is every day their 20hrs is being reduced in 1hr.. the rule is the time per semester which is 20hrs that is given to the students was reduced 1hr only if he uses the internet..but our system is reducing their 1hr every day.
View 1 Replies
Oct 30, 2009
Trying 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 Replies
May 28, 2009
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 Replies
Feb 14, 2009
It 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
Jul 17, 2009
I have a program in VB.NET 2005. At some point I have to open an Access2003-Application for getting data in it. I do that by pretending my program is a human user and let it do all the work in Access as a human user would do. Filling Fields, pressing buttons etc. I use the Primary Interop Assemblies for that. So far so good. That code is in use for over half a year now. In the last week I got Office 2007 installed on my machine. Of course I tested the installed version of my program if everthing still works. Every test was succesfull. But if I do the same tests in Visual Studio it always crashes.
All I get is this Errormessage: {"Das COM-Objekt des Typs "Microsoft.Office.Interop.Access.FormClass" kann nicht in den Schnittstellentyp "Microsoft.Office.Interop.Access._Form3" umgewandelt werden. Dieser Vorgang konnte nicht durchgefhrt werden, da der QueryInterface-Aufruf an die COM-Komponente fr die Schnittstelle mit der IID "{66B22FB4-F70E-4F03-A00A-F76E9ADBBF10}" aufgrund des folgenden Fehlers nicht durchgefhrt werden konnte: Schnittstelle nicht untersttzt (Ausnahme von HRESULT: 0x80004002 (E_NOINTERFACE))."}
For all who can't read german:
"Microsoft.Office.Interop.Access.FormClass" can't be converted in to "Microsoft.Office.Interop.Access._Form3" ... Interface is not supported.
Code I use:
Dim access As Microsoft.Office.Interop.Access.Application = Nothing
.
.
.
access = New Microsoft.Office.Interop.Access.Application()
[CODE]...
The Error occurs when I try to access any property of "access.Forms("frmTest")"
View 5 Replies
Apr 15, 2009
I'm working on a vb.net console app that opens a number of spreadsheets one by one, reads in a couple cells and closes the file. Some of the spreadsheets have formulas that Excel recalculates when I open the file, and I'm getting a dialog box asking me if I want to save changes to the spreadsheet when I close it. Message: "Do you want to save the changes to myfile.xls? Microsoft Office Excel recalculates formulas when opening files last saved by an earlier version of Excel".
How do I automatically decline that dialog box?
Dim newCBD As New CBD
Dim xlApp As Excel.Application
Dim xlWorkBook As Excel.Workbook
Dim xlWorkSheet As Excel.Worksheet
[Code] .....
View 2 Replies
Jun 6, 2011
I am developing an application using visual basic 2010. I need my program to link to an existing MS Access 2003 database to execute a pre-defined query etc. I have read article Q317113 - How to automate microsoft access from visual basic .net. However the examples etc to not work in vb2010.
View 9 Replies
Jun 13, 2012
I've been researching a problem and am so overloaded I'm really lost now. I have to produce an insane amount of reports at work, different day, times.. You get the point. What I'd like to do is create an application where I can:
The windows application would be running all the time .At specific days and times, the application would sent an MS Excell file in Outlook as an attachment
All automatically. If I can get this working, I plan on adding a GUI to the application allowing many reports, at times and days I can set on the screen.
I'm not even sure if this is even possiable.If my application is too hard for a 5th grader to run, I've made too complicated"
View 3 Replies
Mar 11, 2010
I'm using the WIA Aut. Library [URL] trying to capture photos from 5 digital cameras (Nikon D90) USB-connected to my pc. Now, I partially achieved my goal, what I do is:
- loop through the attached devices, connecting to every camera;
- fotocamera.ExecuteCommand (WIA.CommandID.wiaCommandTakePicture) ;
- other image processing operations...
Everything works fine but... the workflow is camera1 -> connect -> grab pic. => camera 2 -> connect -> grab pic. => camera 3.....What I'd like is to make them shoot all at the same moment (...why? well, D90 waits around 1 sec. after a shoot... 1sec * 12 cameras * 500 photo sessions.. :'( )I told myself... what's the problem? You can create "shooting-threads" while looping through the device then launch 'em all.Done.It's still in a 'serial' way... :-(((Why? is executeCommand() a synchronized method? If I madly-fast click on two 'grab pictures' button of windows XP WIA dialog it works.. Is there something about .NET multithreading I don't know?
View 5 Replies
Aug 13, 2009
I am trying figure out something new, I can add a schema to a word 2007 doc and place the elements at diff locations. In my VB project with automation can I fill the elements. I can fill fields/content controls/story ranges just fine, but how does XML fit it to this? Or have I got it all mixed up??? Not asking for code just yet, just seeing if this is a correct approach.
View 3 Replies