So I have this project for my internship at this company that is just screaming to be done with a script, but I don't know how to. I was given about 5,000 files to deal with. They are TRC files but can be opened in notepad to appear as follows:
[Code]...
In VB 2008, I am trying to create an app that will copy a range of cells from one worksheet ("xlWS1") in the first workbook ("xlWB1") to another worksheet ("2") in a second workbook ("xlWB2"), starting in cell A1. I would like this to be activated by a button.Then, another button will copy the same cells from "xlWS1" to "xlWB2", worksheet "3", and so on for each subsequent button.
xlWB1/xlWS1 contains data in the cells that is updated from our data acquisition system once per second. (we perform jet engine testing). "xlWB2" sheets (6 of them) will contain the saved data from the "live" screen (xlWS1, came cell range) in the first WB. There are several different versions (filenames) of the second workbook, one for each engine model.Both workbooks should already be open, but I would also like the app to open them if they are not open already.
We have been using VBA macros to do this, but run into problems when someone saves the second (destination) workbook under a different filename. For some reason, if the filename of the Wb that is already open isn't the same as what's in the macro for that button, the macro's defined workbook is renamed in the macro. I am trying to get away from using the macros to keep this from happening, and to make an app that's "foolproof" so it is more reliable.
I already have an app that will open the proper workbooks. I may combine the two apps in the future. I can't find a solution for this. The VBA code is quite different and simple as far as opening, activating, copying, etc. Basically, I can't seem to find any self-explanatory "activate/copy/paste, etc." namespace in Vb 2008 like I used in the VBA macros.
I'm sure the solution is simple, but I just can't seem to find it in the MSDN library or the VS 2008 book I have. Everything in the book talks about accessing databases, which we don't use (yet). There's nothing concerning this issue with Excel 2003 workbooks/worksheets.
i am making a quick program that will test the anti-virus on any computer. i am using the EICAR test that was developed by European Institute of Computer Anti-virus Research. so in order for this test to work i need a code
(X5O!P%@AP[4PZX54(P^)7CC)7}$EICAR-STANDARD-ANTIVIRUS-TEST-FILE!$H+H*
) to be pasted into a new text file and saved as myfile.com.
so I need to know how to create a new text file and past the code in and save it as [URL]
I have a form that I am creating to document information about computers that I build. I have created the basic layout, what I have is a group box that has many different controls in it (text boxes, combo boxes, additional group boxes etc) What I want to be able to do is have a button that will copy the group box (computer information) and all of its contents and then paste it below the first group box with all of the fields blank or in their default setting; and keep doing this for as many computers as I want to add. Each project I do has a different amount of computers on it so I want this form to be able to handle any amount of computers.
I can't seem to find much on what I want to do, any pointers, direction or idea's
I was able to do this with an excel spreadsheet but all I had to do was reference and select a cell range, scroll down and paste the new section in. This is my code from excell, just as an example of what I did then. But with VB I'm stumped on how to approach this.
Range("U3:AB11").Select
Range("U11").Activate
Application.CutCopyMode = False
[code]....
how do i prohibit a user from copying from and pasting to a textbox
View 5 RepliesI am trying to copy text from a standard rich text box on a button click. However, I only want the first 3575 characters to be copied to my second rich text box, and after the 3575 I want a further 8482 characters to be copied to my third.
View 2 RepliesI'm writing a new app and copying/pasting some lines from another one. In the new app, I get error when I use variables defined as public.
[Code]....
Is there a way to protect the text from selecting (CRTL+A) and Copying? I've disabled the context menu. But is there other way without javascript within the page I'm viewing?I know it isn't possible to hide something that is shown on the screen, but I need fool protection (I'm not talking about PrintScreen and OCR)
View 6 RepliesI have a text box that I will paste into a byte array, for example:
02 01 05 BF DD 03
All I need to do is when I click on a button, for the program to take the length of the array and store it in RCVDMSG_Length() and then take the contents of the text box and put it into a byte array RCVDMSG(). From there I think I can figure out how to manipulate the array... but it's this first step that I'm stuck on....
So far I have this in my Form:
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Dim RCVDMSG() As Byte
Dim RCVDMSG_Length() As Integer
RCVDMSG_Length = Len(TextBox1.Text)
a user copies multiple lines of text (say, from an email) into the clipboard. Based on my observations, when one tries to paste the text into a single-line textbox, only the first line is actually pasted in. (I am aware that the "obvious" solution would be to set the Multiline property to True, but there are reasons I am looking to avoid this and to put multi-line data into a single line.)
In the TextChanged event handler, I wrote code that parses the clipboard data to successfully convert it to a single-line, comma-delimited format.
Private Sub txtMassTrackingNo_TextChanged(ByVal sender As Object, ByVal e As System.EventArgs) _
Handles txtMassTrackingNo.TextChanged
[Code].....
I want to write a program that can copy a selected text in a active program (like word, excel,...) then paste it in my program to do some editting. Is it feasable, can anyone give me a clue how can I do it?
View 6 RepliesI am trying to figure out how to make my program copy text from another applications screen. For example if I wanted to copy the text from an AIM chatbox I imagine it would be simple but cannot find anything on this, interacting with other applications is a next concept for me
View 1 RepliesI am trying to take the amount entered in a text box and save that to a sql database in decimal format. The field in the table is set as decimal 7,2
The amount a user inputs is save to the table. However it rounds the decimal amount. eg. 10.55 saved as 11.00 & 10.45 saved as 10.00 I'm using visual studio 2010 and vb.net
myCommand.Parameters.AddWithValue("customer_contribution", Convert.ToDecimal(CType(Me.FormView1.FindControl("CustomerContributionTextbox"), TextBox).Text))
I've also tried it without the Decimal conversion and end up with the same results.
myCommand.Parameters.AddWithValue("customer_contribution", customer_contribution)
How to copy the text in a RichTextBox along with its formatting to a wordpad or webbrowser?
View 1 RepliesI am creating a Pizza Order program as part of my coursework college. why something isn't working.
Quote:
lblTotal.Text = Val(Form2.lblPizzaTotal.Text) + Val(Form3.lblDrinksTotal.Text)
The code above is what I am using to add the Value of Label 1 (Pizza Total) and Label 2 (Drinks Total), however it seems that in the final total it doesn't appear to add the value of Label 2.
I have 2 text files that are formatted in standard XML One of them contains some lines that need to be copied to the other. What i am trying to do is search through the first file until i see the string "<Segment" then copy all lines into a rich text box up until the string "<segment/>" I Then want to look through the other file until i find the string "<Jointfree/>" then copy the contents of the rich text box to underneath the Jointfree String I Also need to search the second file until i find the string "<Markers/>" and then paste some text into the line above the markers tag.
View 4 RepliesI'm using VB (visual studio) 2008. I'm trying to search a microsoft word file and select/copy text from itWhat i want to doa. Search for a string/word in a text document(i.e "question)b. When its found copy of text from that point to a point further down the document defined by a certain string ("a.")c. after this is done it will continue to look for the next time the same string occurs (i.e. "question"") and continue as aboveThis is to search a question paper and separate the questions out and save it separately .
View 1 RepliesI have created a resume parser which as it stands now, opens word documents and parses the content for specific tokens. It also converts the doc into html format but my problem involves natural language processing. I was told to use the SharpNLP in order to recognize specific phrases, these are typically of the type:
[Code]...
i have 2 form and 1 dialog... the problem is when i select form2 as startup form i'm not able to copy text from combobox1 on dialog1 to textbox1 which is on form1 ... if i select form1 as startup form its working fine... i have placed code with form design as following ...
Public Class Form2
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
[Code]....
I'm trying to copy a Range from Excel and Paste the information in powerpoint in either the HTML or the default format, however, I am having some difficulties. I am able to get the code to work for pasting the Range as an OLE Object but nothing else. The problem with doing this is that having the embedded excel documents in the powerpoint makes the file extremely large and unstable. I just need to be able to paste the information without the embedded information where it is editable (so, not as a bitmap or picture).
With ppt2Slide
Sheets(index2).Activate
Range("CP12:CT" & RangeIndex2).Copy
[code]....
I'm trying to make a program that can export my schedule into a CSV file to upload on to google calender.I need to extract some text within a textbox control. I'll show you an example.This is the text in the textbox:
Quote:
Monday, 10 January, 2011
09:45 - 18:00
Phone Work09:45 - 12:15
[code]....
I need to get just the date and times from this list, and put them in variables. so that I'll end up with:
1) A string with a value as a date, which would be "10 January, 2011" for example: strDate1 would have the value of "10 January, 2011"
2) A start time, for example: strStartTime1 would have the value of 9:45
3) An end time, for example strEndTime1 would have the value of 18:00
I am trying to copy the contents of a word document which is basically in a letter format.I am trying to copy it onto a rich text box editor...but when i copy it..i am losing all the formatting of the word document.This is the code i was using
Dim aDoc As Word.Document = WordApp.Documents.Open(outfile, missing, [readOnly], missing, missing, missing, missing, missing, missing, missing, missing, isVisible)
aDoc.ActiveWindow.Selection.WholeStory()[code]......
I have one combobox, two buttons (Add and View) and listbox. When I click button Add text from combobox is added to text file. This is code for Add button:
[Code]...
I am still messing around with Cntrl/Copy and Paste from a menustrip. Paste is working fine. The copy is working to a certain extent. It will copy the complete text field from one control to another. how do I determine what is the selected text only. My code below:
Private Sub CopyToolStripMenuItem_Click(ByVal sender As Object, ByVal e As EventArgs) Handles CopyToolStripMenuItem.Click
Dim activeChild As Form = Me.ActiveMdiChild ' Determine the active child form.
Dim activeControl As Control = activeChild.ActiveControl
[code]....
A] Is there any way of stopping a user from entering text or changing text in a textbox without disabling it or
B] Is there a way of changing the texboxes back and fore color whilst it is disabled?
I cant seem to find any link or topic regarding my problem. I have 2 forms in a project, form one has labels and adjacent combobox while the other form (form 2)has textboxes with adjacent combobox. I am supposed to change the text property of the labels using textbox entry from form 2 and add/delete/change combobox contents in fom 1 using entries combobox at form 2.
View 13 Repliesi am working on read line by line . At each line that my app read , i added a event . How do i read a text file till the end and Stop it? there is how it work :
[Code]...
how to permanently save to text files then re-open all of the information again using SFD and OFD. Now my teacher has come back at me and said that i need to be able to save the information from multiple text boxes and have the text in certain labels to also be saved into the one text file (the labels need to be done because it is a database and these labels are like the fields and the right text box needs to match the right label)
View 39 RepliesI have column with bit datatype in sql server table(2008).while returing to text box its returning true in text box instead of 1.i tried converting it from true to 1 using txtboolvalue.text=Math.abs(CINT(ReturnList.Item(34)).tostring. But it doesnt convert true to 1
Secondly: im checking for columns in datatable if there are any nulls. its checking for nulls in the sqlserver table but its returning true if there is a null.i just want it to return NULL is there is null i textbox..
CODE:
Then
CODE:
So i watched this video here. [URL]
And i want to do this for like 40+ text boxes, how can i do it?