Search results for query: *

  1. awooster

    ComboBox Multiple Listings?

    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?
  2. awooster

    Question Loop to test if cell has anything in it?

    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...
  3. awooster

    Question Loop to test if cell has anything in it?

    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?
  4. awooster

    Question Loop to test if cell has anything in it?

    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...
  5. awooster

    Question Loop to test if cell has anything in it?

    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...
  6. awooster

    Question Loop to test if cell has anything in it?

    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.
  7. awooster

    Question Loop to test if cell has anything in it?

    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...
  8. awooster

    Question Loop to test if cell has anything in it?

    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...
  9. awooster

    Question Loop to test if cell has anything in it?

    Thanks, however I have never used Data Grids, so when I put the code from above, it says DataGridView1 is not declared.
  10. awooster

    Question Loop to test if cell has anything in it?

    I forgot to mention, that the rows and columns are coming from an Excel spreadsheet
  11. awooster

    Question Loop to test if cell has anything in it?

    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...
Back
Top