I am writing a Macro for an Excel spreadsheet that copies cells out of a separate file and pastes them into the open workbook. Some of these cells contain the error #DIV/0. I need an if statement to replace all copied cells that have the error #DIV/0 with the value 0.
View 1 RepliesI currently have a very long column (5,000+) of which a lot of cells start with a range of zeros which I want to get rid of (the zero's that is). After importing the data from a txt file, I have a loop going through each row in turn getting data from different cells. So I could amend when teh data is being imported or during the loop reading the data.
[Code]...
I have a DataTable and want to connect the cells of one of its columns to cells in some other DataTables.
For example:
DataTable1.Rows(0).Item(2) is connected to DataTable2.Rows(4).Item(6)
DataTable1.Rows(1).Item(2) is connected to DataTable4.Rows(2).Item(3)
DataTable1.Rows(2).Item(2) is connected to DataTable3.Rows(11).Item(4)
...
How can I do this?
I'm currently in a "course" (mostly self taught with some guidance) and I'm hitting a wall in one of the tests.
The idea is to read out a text file, loop trough the list and replace the content if the item from the text file is found in the list. I've got it fixed up until the replace part:
Dim SplitFirstCase(3), SplitSecondCase(3) As String
Try
FileOpen(1, "orders.txt", OpenMode.Input)
[Code]....
The loop works, but it seems that splitting the selected object isn't allowed. Value 0 is the article number, and based on wether the value returns or not the selected object needs to be replaced.
I have a file that is constantly altered, and if an error happends, I want to have a backup. I was wondering if there's a way to make a script that will copy all the files in the selected folder, and post/overwrite them every 20 minutes in a back-up folder or something, and I say overwrite so it doesnt take up 298347234 gigs of data.
View 2 RepliesI'll explain the scenario. I have a list containing character list and it's corresponding unicode characters(copied from CharMap and pasted in VB editor).
For example:
Text = Unicode --> Unicode character
---------------------------------------
K = U+004A --> J
[code].....
This is an example of the text I want to modify:
0110
0001
0001
1000
[Code]....
Here, I want to replace two-line digits in bold(0110 0001) with a different sequence as the program scans the text line by line. But two things complicate the task:
1. the comma lines should be ignored, but
2. they also should stay intact after changing the digits.
My main goal is to have an excel spreadsheet that automatically plots the overall success of my stock portfolio over time (% change over time). I've been able to incorporate stock data into my spreadsheet by linking it to the web, but the trouble is the spreadsheet will keep no history of what the previous stock values were, so I can't graph how things change over time. This sounds like it might be too complicated to be built in to excel, so I was wondering if anyone knew how to program this in Visual Basic. Maybe something like this.... If refresh then new cell plus new time stamp. Another possibility would be to have a whole bunch of cells that refresh only once but at longer and longer intervals, e.g.,
[Code]...
I am wondering if there is a easy way of comparing data in two datatables available in following format:
datatable1
Quote:
ID Length Width Height Qty Rate
ID1 1.50 3.50 1.15 10 55
ID2 2.50 3.50 1.25 20 65
ID3 3.50 3.50 1.35 30 75
[Code]....
ID column of both the tables are unique ID's and can be used for comparing both the databtables.
I am wondering based on these ID's, both the datatables can be compared.
For example, if datatable 1 is used as reference table, data in ID2 and ID5 of datatable2 are different when compared in datatable 1
I am trying to format the data entered in a cell of a datagridview using the cellleave event. Please see code below but it is not working. the data is centered in the cell but it is not getting formatted.
[Code]...
vb.net
Dim xlApp As Excel.Application
Dim xlWorkBook As Excel.Workbook
Dim xlWorkSheet As Excel.Worksheet
[code]....
It loads the data, but there are no headers. I didn't make the code, just copied it using various sources as no one source was able to give me what I wanted.How would I go about adding a header row and making the font bold and increasing the width of each column?
I want to retrieve the value from example Cell C4 and dim it as String and then retrieve Cell D8 and dim as string etc.
View 2 RepliesMy Visual Basic .Net 2010 application reads data from an EXCEL spreadsheet which will be generated by my "customers". The responses to Alkis last year (23 July 2011) has been a big help and got me over a hump in my application. Now I am down to the last issue - how do I detect a blank cell? Valid data is numeric, starts at a fixed cell (A5 to be specific), and will be continuous until it ends with blank cells. While blank cells appear to print a "zero", when I try to use zero as an end criteria I get a 'System.InvalidCastException'. When I put in a specific end value (-1) in the last cell all works fine but that, of course, is an invitation to a user error.What is the difference between "Value" and "Value2" and where might I find documentation that explains the difference? [code]
View 1 Repliestxt1 = help and txt2 = me! txt3 = not here, when i enter the other box i want the okay to drop sign to come up, after drop txt1=me! and txt2 = help.if i drag to txt3 display the can't drop sign.Iv'e tried everything all i can do is replace one way.also,i want the can't drop and can drop simbols to show.so far
Public
Class Form1
Private
Sub tbMouseDown(ByVal
[code]....
I have an issue here, lets say I have this string: "Lets create a database called 'farfromwest' and then host it" And I want to change the substring that is inside the ' ' with "nearwest", how can I do it? "Lets create a database called 'nearwest' and then host it" Remember, I want to change what is inside ' ', this means it could be any word, not just the one of the example!
[Code]...
I am in desperate need of code that will allow me to search through a text file (.txt) and change the word "POLAR" to a string with a particular value, for examples sake lets say the string = "SUN"
View 1 RepliesI have a code snippet that cleans a string of various characters. [Code]. Is there a better way to do it than this?
View 3 RepliesWhile my user is typing text into a textbox i want the characters " to be replaced with ' '. The thing is, when i put ' ' in the replace code, it thinks it is a comment so i cannot run the code without producing an error.Also in my multitext box, everytime i write text and hit ENTER, save and then load it back again, the last line ends with a comma, so:
Line 1
Line 2,
When the text is written to the file i read from, it will show like this:
"Line 1Line 2",
So i need a way of trimming ", when the apostrophe " and the comma , are together. My code already trims "".
I have dates like the following (note trailing 'T')
2011-11-07T15:24:28
2011-11-07T
With regex i need to extract just the date part so both will look like this
20111107
20111107
.net Have a webservice that is returning a date like 2011-11-07T15:24:28, but on some occasions it returns date with no time but still with the trailing T. This causes .net's cdate function to bail out.
In c programming language,
I can do
printf("%d
", value);
But in c#, how can I do it? For example string is "Good %s everybody"
I want to replace %s with the variable. Are there any solution except str.Replace("%s","good morning");
I have a datagridview which gets it's info from a datatable. Everytime I add a new record to the datatable, the datagridview replaces the first record with the new one, instead of adding the new row under the old row.
(Datatable is already declared.)
Private Sub btnWebSave_Click(sender As System.Object, e As System.EventArgs) Handles btnWebSave.Click
'first make sure all text boxes are full of data.
Dim ds As New DataSet
dt = New DataTable
[Code] .....
I have file paths such as:
' Any number of folders before and after the Project name
C:acdProject1efgsomefile.someextension'
How would I:Extract only the path before the project name?
C:acd
Extract the path after the project name?
efgsomefile.someextension
Note: Of course given the filename.Would Split be better or some complicated regex?
i have 2 groups of text in my text file
Bottom
11.0 28 Red (2 13.10 04.0) [1 16.71 33.3] 130611 2948 229111 28275
6.5 28 Blue (2 03.00 03.0) [1 05.36 58.3] 132111 -67725 191611 -51225
2.0 28 Blue (1 05.36 45.3) [1 05.36 58.3] 211111 51225 210454 34691
[Code].....
Items:
1 listbox
2 textboxes (1 textbox input, 1 textbox edit)
4 buttons (1 button add,1 button remove, 1 button edit, 1 button change)
Private Sub add_Click(sender As System.Object, e As System.EventArgs) Handles add.Click
ListBox1.Items.Clear()'clears the listbox1 before puting the input in
ListBox1.Items.Add(textbox1.text)'This adds what's in the textbox1
End sub
[code]....
this workes but if you test this, you will notice that if you edit the selected item and put it back in it's all the way down again and not at the position as it was.For example:
first item: apples
second item:flowers
third item: orange
so if you edit flowers to pears for example then, will appear below orange.i know i know that this is the issue:
ListBox1.Items.Remove(ListBox1.SelectedItem) 'Removes the item first
ListBox1.SelectedItem = ListBox1.Items.Add(TextBox2.Text)' Add the text thats in textbox2
How can I upload an image 1.png into the program and then once the program is opened, that image gets saved here:LibrariesDocumentsand if there is already a file called 1.png in that directory.
View 5 RepliesI am using the .Replace function of a string. My string is a module I have added for a resource which looks like this: My.Computer.Network.DownloadFile("This String Will Go Away/details.txt", "details.txt") And then in my application I have:
[Code]...
Is it possible to replace string characters using the delimiter and limit of a split function?
For example you have this string "1,1,1,1,1"
I wish to replace sentence number 2 into the string "2" between the "," character so that will be limit number 1.
So the result would be "1,2,1,1,1".
I am loading a dataset with a csv file.I remove the quotes around each field in the csv file and I am splitting each field wherever there is a comma:Dim fields() As String = lines(i).Split(","c) The problem is that some of the fields have a comma in the csv file (surrounded by double quotes).How do I replace those commas with a space to avoid problems when loading the dataset?
View 18 Repliesim trying to replace data from listbox1.selecteditem to listbox2.selecteditem i have a temp.txt text file that loads in to listbox1 (rlines) this is the methord i use to load each file in to a list box...
Try
Dim file_name As String = tempdata()
Dim stream_reader As New IO.StreamReader(file_name)
Dim line As String
[code]....
it dose what it says and replaces that line of text from the data loading in to listbox2 with the data i selected in listboz1(rlines) but what im looking for is to have the data load in to listbox2 and then have a button so i can select a line in listbox1 and in listbox 2 and it will replace the line from listbox1 in to listbox2 now i can add a line in to listbox2 from listbox1 with
listbox2.iteams.add(listbox1.selecteditem)
but cant find a replace for it
i have data (CSV) that goes into an array. I then update the data but when it updates, it keeps blank elements of the array. Each time i update, the array doesnt replace my old data with the new data, it just seems to create a new element of the array. Then i get the incorrect count of entries.
Reads XML
For Each node As XmlNode In xnames
nvalues = node.InnerXml.Trim
Next
[code].....