I have a combobox with three items in it, however, when I debug and run the app., it lists the three items twice? How do I get it to only list them once each?
I have to input this data into two different excel files and a website, just trying to make it so I only have to enter the information once and have it populate all three. But even just putting the info into this vb app and having it populate the two excel files will definitely help out. so...
I want all of the data saved to the first excel file, and then I am going to have only some of the data saved to the other excel file, also, would it be possible to populate a web page form that requires all of the data as well?
This is what I have done so far, I used two buttons, it seems to work, the only funny thing is that when I click the Submit1 button, it asks if I want to replace the text.xlsx file
Imports Microsoft.Office.Interop
Public Class Form1
Dim xlApp As Excel.Application
Dim xlApp1 As...
That works great, now I just have one more question, I would like this to send the info to two different excel spreadsheets, is it possible to open 2 excel apps and have the one button send the info to two different spreadsheets? Or do I need to have another button to send the info to the other...
There is an excel file with 5 columns of values in each row, I want this to find the last row of data, go beneath it by one row and enter the data I have saved in the array. There should not be blank rows in the middle, after the data is transferred I want to save the excel file.
Do While endLoop = False
If DataGridView1.Rows(intRow).Cells(intCol).Value = Nothing Then
For i = 0 To 4
DataGridView1.Rows(intRow).Cells(intCol).Value = myValues(i)
Next
endLoop = True
Else...
Imports Microsoft.Office.Interop
Imports System.Data
Public Class Form1
Dim objApp = New Excel.Application()
Dim objBooks = objApp.Workbooks
Dim objBook = objBooks.Add
Dim objSheets = objBook.Worksheets
Dim objSheet = objSheets(1)
Dim range As Excel.Range
Dim...
I want to use a loop to check to see if there is any data in the first column of a row, if there is data I want it to go to the next row and check again, once it finds an empty row, I want it to right data from an array I have created. I understand the concepts of loops and incrementing to make...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.