I have an array which holds number of elements. Now I need to create an xls file and need to write all the members of array into xls file, like one member for each cell.[code]Now I need to create examle.xls file and write above input() elements into example.xls
View 1 RepliesI'm close to getting this to work, but currently can't get any output to display in the listbox. I had it working, but needed to move some things around to get the join function to work.In my program, a user enters input into a textbox and an array is displayed in a listbox based on what they type in. For example, if they type in "a", all foods (in the textfile that is connected to the program) that start with "a" will be displayed.
When there is output, I need to find a way to name this array (which is created based on what the user inputs) and join all of the items in the listbox (example: foods stacked on top of each other in the listbox will be shown at the bottom as a string).I am posting the code that I have thus far; all of the errors that I'm getting (and potentially my logic errors) are just in the first public class until the end of the first if-next statement:
Public Class frmFoods
Dim foods() As String = IO.File.ReadAllLines("foods.txt")
Private Sub btnDisplay_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnDisplay.Click
[code]....
I've come up with the following and it's partly working.
Public serial1, serial2, serial3, serial4, serial5 As SerialPort
Public serialports() As Object = New Object() {serial1, serial2, serial3, serial4, serial5}
dComPort = "COM4"[code]....
The above code works fine! But im having trouble trying to now retreive whats stored in the array.In the above example, an entry will be stored in serialports(4), all other array elements will be blank.If I do this it works.
MsgBox(serialports(4).PortName) ' this retuns the value COM4
But I'd like to loop though all array elements and print out ALL the PortNames, The below code doesnt work, I get an error Object variable or With block variable not set.
For i = 0 To serialports.Length - 1
MsgBox(serialports(i).portname)
Next
Assume I have an array myArray1 = { A, B, C, D, E, F, ., T}I have another that contains a subset of the elements of myArray1 but where the order may vary
View 3 RepliesHow do I read a raw byte array from any file, and write that byte array back into a new file?
View 3 RepliesI feel quite silly asking this, but I couldn't find a definite answer anywhere. in vb.net, how are the array elements defined (if they are defined) for, for example:
Dim myarray(5) as int
does, at this point in time, myarray(3) for example have a defined value? If so, what is it?
i have a structure of;
name
age
gender
location
then i need to read in a file into an array on the structure above, and pretend this is the file which has 3 people
george
45
m
usa
[code]....
so basically i dont get how to read in a file then put it in the array in that structure then make it into a csv file?and whats the difference between streamreader and streamwriter?
VB 21010 How to load an array from a txt file and write to it also?
View 4 Repliescheck if array consist of only elements from another array
View 3 RepliesI have a one-dimensional array that has one number per element. I also have a variable number, var. I need to take the number of elements from the first array that equals the var and put it into a second array with commas between the numbers. I would also like to have a title element in the second array. [Code]
View 4 RepliesI'm looking for some code to write /read an array to a text file in vb6.i have an array of a fixed size, and i need to write that into a text file, then later in another program i need to access that text file and write every element to a new array of the same size.the elements will be integer values, but "Long" datatypes. there will be no strings or anything else, just whole numbers.
View 2 RepliesI have an integer and a button.After clicking on the button, the integer value would be for example 10.Then how could I store that value 10 into the memory, and when I click the button again, the new integer value now is 5. I'd like to add up the old and new value together and write it to a text file.
View 2 RepliesHow can i write and read a array of a structure to a file? I have the following structure
[Code]...
IM trying to write data from an array to a text file. what has confused me is how to write data from an array which has a structure.
View 2 RepliesI have an array of structure like this:
Structure Planner
Dim Type As String
Dim Circuit As String
Dim Socket As String
Dim StepCMDText As String
End Structure
how do i write it into a file? (also read it later
This code get the data into the file, but no back out.Where am I going wrong?
Code: Function test() As Boolean sFileName = "Carrier.dat" iFileNumber = FreeFile() FileSystem.FileOpen(iFileNumber, sFileName, OpenMode.Binary, OpenAccess.ReadWrite)
If FileSystem.FileLen(sFileName) = 0 Then ReDim tMyStructure(7) tMyStructure(1).name =
[code]....
I have a bar cash register and have buttons for the drinks and number pad. In the program I have it working and it is reading the File and storing it in a Array. the problem i have is writing back to the part of the textfile. Here is 2 of the drinks buttons, all the rest of the drinks are the same.
[Code]...
How can I write and read a string array to a text file?
View 2 RepliesI need to declare a directory, create a file in the form_load event. I need to write the value from an array in the file when during Button_click event Is there any way to use the object declared in the form_load to be used in the Button_click event????
[Code]....
The gist of the program is to:
- Read a CSV file into an array
- Get this visible in a list box, so the values can be:
- Sorted
- Edited
- Deleted
- Added
- Finally save these manipulated values back to the text file
Would love some suggestions and code as to how to get this going, hopefully I'll get the hang of it and come back and fourth for help
I am trying to add the values in my array.. and this is my code
dim totals(6) as decimal
public function AddIBNRTotal(byval Amt as decimal,srvcdesc as string) as decimal
if srvcdesc = "ZZ_TOTAL" then
[Code]....
I know the addIBNRfunction works fine cause it is displaying the correct amounts in my textbox
but when i call the Sumnumber() i am getting 70000 dollars short...
So is this the right way to add values or elements to a array...
How would you code this so that it adds up the first column, and then the second column?
Dim intSales(,) As Integer = {{100000, 150000}, _
{90000, 120000}, _
{75000, 210000}, _
[Code].....
I am trying to create a array and then add elements to it based on some conditions and then add the elements in the array and display it...
but i am getting a larger number that expected..
this is my code
Dim IBNRTotal as decimal
dim element as integer
dim totals(6) as decimal -- create a array3
[Code]....
i know the amt value correct cause in return amt.. i am seeing the right value but somehow when it goes to the array and when i add the whole thing it doesnt seems right...
I am just starting VB at 60 years old and with no programming experience and nobody to ask for help...except here, of course. So needless to say I am hitting brickwalls. I am using "Murach's Visual Basic 2008" and it seems to be a good book. This is what I am up to I have to declare an array with 5 elements with an index. I think that part is OK. Then add code that adds each element to the next one every time a user clicks a button. I have had many tries but the best I can get is just the grand total of the elements. Here is the code I came up with:-
[Code]...
Is anyone able to show me how the button click would reveal a progressive total of the elements each time a user clicked on it? It would be good if the book came with answers or had a forum for their readers.
way to assign value to elements of an Array. For an example,
Assign each Cheque1 to Cheque50 to the array (named as "Cheques()" ) elements.>>
Cheques(1) = Cheque1
Cheques(2) = Cheque2
Cheques(3) = Cheque3
[Code]....
Now I'm VERY new at the reading in a text file and storing into arrays thing and tried for hours last night to figure this out, googling and every possible way of writing the code. However, I don't know what to try next and I'm getting more confused by the minute. I have a text file which I load into my program. This data is stored into 6 arrays, each of which has data that comes from either a combobox, date or text field. What I'm trying to do is to find the count of items in each index of the array.
[Code]...
In this case I'm trying to create a number analysis app. I'm required to declare an array and get the data for the array using ten text boxes. Why, because my instructor said so.
My problem is my event is returning zero. Therefore I believe my code is somehow flawed.
My approach is to create functions that calculate the required metrics. I have only tried to code one function to date. If I can get help making one function work, I will be able to do the others .
Public Class Form1
Dim decScore0, decScore1, decScore2, decScore3, decScore4 As Decimal
Dim decScore5, decScore6, decScore7, decScore8, decScore9 As Decimal
[Code].....
I have a class I am working on for a program I am writing while I am stuck at hospital 3x a week and was wondering. If my class has a Reset function that sets the count variable to 0, can I then say that the Data array is equal to "nothing" and wipe all the data that was in it?
Below is the class structure so far:
Private Count As Integer = 0
Private Data() As Integer
Public Sub Add(ByVal value As Integer)
Count = Count + 1
[Code] .....
For example, I have an integer array called sec1() that has 71 elements.
I tried:
vb sec1(1 - 71) += 1 But when I run the program, it gives me an error. Not a red-underline error, some other error that doesn't stop the program from compiling but stops it from running. Is there a way for me to modify all of the element of my array at once? just out of curiosity will the same method work for string arrays?
I am trying to teach myself programming and I am on the subject of arrays. I want to create a simple program that asks the user to input 5 numbers and then outputs those numbers to the user. The program is a console application and I'm using Visual Basic 2005. My code is as follows:
[Code]...