My problem is actually how I can transfer certain words or sentences from one cell to another. Keywords that I can reference in the comment cells are: "Description: sentence goes here., Solution: Solution : Microsoft has released a set of patches for Vista, 2008, 7, and 2008 R2 : [URL]...The actual text is this:Synopsis : The remote Windows host has a denial of service vulnerability. Description :The remote host is affected by a vulnerability in the SMB service that can reportedly be abused by a remote, unauthenticated attacker to cause the host to stop responding until manually restarted.This vulnerability depends on access to a Windows file share, but might not necessarily require credentials.Solution :Microsoft has released a set of patches for Vista, 2008, 7, and 2008 R2 :
I'm very new to VB.Net and just trying to find my feet a bit and get my first programs running.url...Which should allow me to run excel from VB.Net, but I get heaps of errors - basically anything specific to Excel comes up with 'type not defined' or 'name not declared'. I've tried adding the reference several times and I'm pretty sure I've followed the tutorial to the letter so I'm stuck.Don't want to post the whole code because it's very long, but here's the beginning and end:[code]
I have a table of data in Excel 2003 of which I have managed to automate through a VB.NET application to create a Pivot Table. (Will be doing hundreds of these and therefore cannot just run a macro each time...will put the code in a for loop for each spreadsheet in a directory) My problem is that I am trying to create a pivot chart based on the pivot table.
Some code below....I need to create a pivot chart based on the pivot table below!
I have an ASP.NET web form that reads a file and writes some data to a database. I need to run this process on a scheduled basis.
Currently, I have a scheduled task that calls a batch file. The batch file then opens Internet Explorer and navigates to the URL and the process is fired. There is another scheduled batch file that closes Internet Explorer.
We have bid on a large installation and if we get it we will need to set up 300-400 router like devices very quickly. To set one up now we connect to the device with a serial cable, run Putty on the windows PC, log in to the device, and run some commands on it to load the latest firmware and change some settings. I'd like to reduce this to connect the router to the pc with the serial cable and press a button on a vb program. The program would launch Putty, login and execute the commands. Sendkeys might work but it would be best if the VB program could read the responses that were coming back to an extent so I wouldn't have to program in really long pauses to insure actions had completed before doing something else.
i am using the following code to send e-mails, I am using this cause various other methods though sucessful, were not compatible. My earlier code was compatible with Outlook 2003 and used to crash at machines with Outlook 2007. i know you can add a reference to Outloo 2007 office files. but the following code is version independent, but i am not able to pre-populate the various outlook fields such as the To: , Cc: ,BCc:, Subject and Body. and i am not able to Launch Outlook for the user to actually see the display.
Dim outlookApp As Object Dim outlookNamespace As Object Dim newMailItem As Object
My broadband provider used to have an XML data usage stream where I used to check my usage. They have now disabled this so I am planning to build my own VB application to login to the usage webpage and scrape the usage data.This is the code I am using:
I have developed a VB.Net application to automate Word and I am noticing some issues when I attempt to close a document and subsequently Word. So I have decided to do the following - - ->
I check to see if Word is running on the local PC. If it is not, then I instaniate Word, execute code, close the document and quit Word. If Word is already running I want to be able to use that instance of Word, execute code, close out the active document and NOT close Word. I have retrieved the Process ID for Word running on the local PC but am not sure how I can use Word's properties and methods on an existing instance.
Since installing Windows 7 on one of my test machines my automated uninstaller can not find the uninstall string. My script works on XP just fine. I noticed that the uninstall information is in a different location for Windows 7. it is in Wow6432NodeMicrosoft... is there a constant I can use that will allow my script find the correct uninstall location on both Windows 7 and Windows XP?
i am using vb2008 and trying to create an auto login and reboot for a secure console server "Lantronix SCS100", I can get through the first page with the code below but on the next page i need to check a checkbox "<input type="checkbox" name=OidC2.11>Server</td></tr>", then click event the "<submit>" button to reboot the server.
Public Class Form1 Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
I was wondering, lets say I have a web browser control? Can someone help me figure out how to automatically press the tab key in the web browser control & then follow it up by tapping the space bar key?
I am new to VB and I try to create my first application to automate some clicks on a facebook game. My first problem is a loop: I created a recorder function, but if i activate my loop it loops endless (should take the number of loops from textbox). If I add a messagebox it works, but if I add PlayTimer.Start() its endless.
Dim result As Integer Private Declare Function GetAsyncKeyState Lib "user32" (ByVal vKey As Long) As Short Dim curclicks = 0 Declare Sub mouse_event Lib "user32" Alias "mouse_event" (ByVal dwFlags As Integer, ByVal dx As Integer, ByVal dy As Integer, ByVal cButtons As Integer, ByVal dwExtraInfo As Integer) Private Const MOUSEEVENTF_ABSOLUTE = &H8000 ' absolute move [Code] .....
The 2nd question i got: How to handle the next function I am planning? I will try to explain it (look at the attachment picture): Because of different monitor resolutions I need a function that maybe draw a square to boarder the gameplay area, then record some coordinates that can be played by clicking on a button. (visit neighbor, reload game, visit next neighbor, ...)
I have written an application using VB 2005 Express. It's a very simple application. There are basically two listboxes, one to the left and the other one to the right of the GUI.Listbox1 contains a list of names. When you double-click each name, a code word is created and added to the listbox on the right. Now... here is what I want to do. I would like to automate the double-clicking process with the click of a button so that each name on listbox1 is double-clicked in sequence
I have some code that is supposed to automate a textbox on a webpage. The problem is, it only works half of the time. The text either displays or does not display. I added the internet controls as a reference but the HTML object library would not get added. Everytime i would go to do this, it would freeze.I also tried doing it two ways. The way that is commented out, always produced a null error. If i change the website to google.com, it works perfect everytime.[code]
I am creating a small program that can automate the input to a web browser window, Like a survey filling bot but for my personal use,All I want to know is there any way to simulate a Mouse click for a particular element in a web browser window so that It can submit the form automatically ?
I'm a systems analyst and the company I work for likes to automate as much as they can. Recently I've been getting a lot of questions like "can we automate this in any way?" and I have no idea. I've done automation for Word, Excel, adobe reader and a terminal viewer they use but that was mostly done with code already written by some one else here. If there is a program you want to automate, do you just go to the programs website and hope they have a developers section or is there a standard way to use program dlls for automation? I'd also like some good resources on COM objects if anyone has some, I believe that is how most automation is done, correct?
I am writing an windows application in VB.Net to automate the internet explorer using Visual Studio 2005.There is a website with list of orders. I need to accept the orders automatically whenever they arrive.There are 2 pages in a websiteand they will refresh at regular intervals. In the first page there is a list of elements in a grid with Accept and Decline buttons. I have to click on Accept button. Then next page loads with some text contents and a Check box and a Submit button. I need to check check box and click on the button automatically.
I have an app that i would like to launch outlook 2007 automatically from VB2005 and insert the To, CC, Subject, Message Body and add an attachment to. Everything works great except outlook ignores the attachment completely - the file exists in the correct location - what am I missing?
I need to find a way to automate the process when a user uploads a microsoft project file to a web application I already have created. The process will need to basically use the save as from project to save into a .csv file so I can use this to import the data to an SQL database (this is needed for custom reporting we already have set up using SQL). I need to automate this process because I will be receiving tons of project files, and if the process is automated the users will then be able to instantly see results.
Basically, is there any way to create or run an automated process that will save these project files as .csv files? Even if the csv files are not formatted correctly, I can find a way around that, just need to first get them into .csv files. The only way I could think of this is to follow the instructions listed below, but I would then need to automate a process to open the file and hit save so this works... [URL]
I have a VB.NET project in which it would be extremely helpful to the users if they would be able to print multiple .DWG files at the same time without manually opening each one and clicking on the print button.
Is this possible to do in VB.NET using the Autocad API's?
I am trying to run the following code (which I got from here). The code just creates a new "Output" pane in Visual Studio and writes a few lines to it.
Public Sub WriteToMyNewPane() Dim win As Window = _ dte.Windows.Item(EnvDTE.Constants.vsWindowKindOutput)
[Code]....
Instead of running it as a Macro, I want to run it as an independent console application that connects to a currently running instance of Visual Studio 2010. I'm having a hard time figuring out how to set the value of dte. I think I may need to call GetActiveObject, but I'm not sure how.
I am trying to automate the download of a .CSV file from a password protected website. This file is updated every 15 minutes, but I could get by downloading it 2-3 times a day. I would love to find a way to download this file without any user interaction.
The problem is that there is no direct URL to access the CSV file. There is a webpage with a submit button that initiates the file download. The usual File..Save As Dialog box appears, you click save and then specify the location through the second dialog box.
Looking at the source of the main webpage, I found the form containing the download button, hoping that I could simulate the POST using the HTTPRequest/Response objects, but I couldn't get them to work. The form contains three hidden variables, one of which is called "Key" with a 20 character hexadecimal string. Im assuming this key is regenerated regularly, so this may explain the constant errors I received saying "...press the back button and resubmit the previous page".
Then I decided to try the WebBrowser control. I was able to figure out how to pass the authentication through the URL and the download page appears in the browser control window. Clicking on the download button brings up the same Save As dialog as the main browser window.how to automate this process. I just need to get this csv file (which, by the way is approx 25MB) downloaded so that my scripts can use it to update our site database.
I am automating a javascript web form submission process using webbrowser. I would like to use something without a UI but don't think httpresponse etc would do all that is needed. My code works but I think is not designed correctly. I think I should be breaking each step into its own sub or function. In its current state I think every time a page is refreshed/redrawn all the code is running which makes causes endless looping of clicking a link which is on its own destination page. What that means is click the link and the page refreshes with new information but does not navigate to a new page. So the code looks for the link and selects it over and over and over .... This I think needs to be subbed or done as a function instead.
Here's the code. Public Class Form1 Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load 'Part 1: Load elogging login page in Form_Load event WebBrowser1.Navigate("[URL]") [Code] .....
I am in the process of upgrading hardware for a significant number of users. When we upgrade them to new hardware we often upgrade a lot of their software. Once the base load of the OS is on their new machine I run a vb script that copies their profile from the old machine to the new machine and sets up a lot of the software on the new machine that we use. I am trying to migrate this application to VB.Net for a variety of reasons (speed and UI being among the biggest). There are two separate issues that I am having.
One issue is that I can't seem to find a good .Net way to query what printers and ports they have on the old machine and set those up on the new machine. I am still using script (called from VB.Net) to do this. Another issue is with CopyProfile. We have several users that have directory structures that use names longer than this utility seems to allow. Is there a better way to copy a profile from one PC to another than this utility? Is there any documentation on exactly what this utility does so I could determine if I wanted to code it myself?
The program I am trying to make is to automatically create a World of Warcraft Trial account to make the proccess a little bit quicker.The first problem I am having is getting the captcha to show up in the form.(The captcha will only show up on the site if you make one account and then try to make another one)?
For my job I have to manually tick up to 50 boxes on a website and then click expire to remove the records from the site. Is it possible to automate this by having a small application which on the right hand side has a browser control and on the left a button which says expire all records. When this is clicked the tool knows to tick all the records and then click on the expire button? If so what sort of control should i look at using or VB code?
I want to progress this at a later date aswell so that the tool would then be able to click on each record individually to enter the record and then click re-publish? How do I get my program to loop round and then stop when it has finished expiring all the records? Also sometimes there are more than 1 page of results, so it would need to be able to tick all results, then click on the expire button, but then be able to click on the next page button and then repeat the process so it expires the records on this page?
