Recent content by sweit

  1. S

    Question Import data from an excel file

    So I should do this? pressure = CInt(xlWorkSheet1.Range("J4").Value)
  2. S

    Question Import data from an excel file

    Here is my code to save the data into the spreadsheet. Private Sub btnCalCert_Click(sender As System.Object, e As System.EventArgs) Handles btnCalCert.Click, SaveToolStripMenuItem.Click ' Load data into the MAC125 Calibration excel spread sheet. 'Path and excelFile variables...
  3. S

    Question Import data from an excel file

    XLS file. I'm saving variable values into cells on a spreadsheet. I would like to be able to load the values from those cells back into the variables at a later date when a user needs to load a specific data set.
  4. S

    Question Import data from an excel file

    Hello, I'm writing a program that will save data from a few variable into cells of an excel file. I also would like to load the data from a saved excel file into the variables. I have a working sub that exports the data to an excel file. I'm not sure how to load the data from an excel file back...
  5. S

    re-enable the Timer

    I used a system.timer instead of the form timer control and everything works as expected.
  6. S

    re-enable the Timer

    Hello, I have a timer on my form. When I press a button the on the form the timer starts. In the Timer.tick event handler I disable the timer (Timer.Enable = False). I'm trying to re-enable the timer in my code. I know the program gets to the timer.enabled = true statement but the Timer.Tick...
  7. S

    Data does not transfer to excel correctly

    The string does not have a "%" in it.
  8. S

    Data does not transfer to excel correctly

    What you are saying makes sense but why does a value of 20.00 for lblPercent2.Text get stored in a cell, also formatted to display percent, as 20.00% instead of 2000.00%? The label text is transferring the way I would like but the textbox text is not. Any idea why? Thank you, Steve.
  9. S

    Data does not transfer to excel correctly

    Hello, I have a windows form with a text box to be filled in by the user with a number. The number is then written to the cell of an excel spread sheet. The cell on the spread sheet is formatted to display percent. The format is not transferring correctly. If the users types 1.75 into the...
Top Bottom