Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by ImSimple

  1. ImSimple

    Loop through multiselect listboxes for selected items

    This gets me no errors but the items don't go to the sheet either. This is weird. Thanks for trying. Jacque
  2. ImSimple

    Loop through multiselect listboxes for selected items

    I have a form with many multiselect listboxes on it. I want to loop through each list box and get the selected items to copy to excel. I am getting a casting error "must be less than infinity" For Each box As Object In Me.Controls '****INFINITY ERROR***** If TypeOf...
  3. ImSimple

    Windows Form Data to Excel Workbook

    That also fixed the Excel not clearing problem since it is getting to those lines now. Jacque
  4. ImSimple

    Windows Form Data to Excel Workbook

    Got the Headings fixed. Moved sheet.Range("E31").Select() above the For Each Statement Duh. One down :) Jacque
  5. ImSimple

    Windows Form Data to Excel Workbook

    I'm having multiple problems with this. Everytime I think I'm making progress I take 7 steps back. I'm running in circles. ANY help is greatly appreciated. Here's the whole thing with comments on the problems. Imports Microsoft.Office.Interop Public Class ScopeSheetBuilder Dim excel As...
  6. ImSimple

    Loop not chatching all values

    It's pulling the 1st heading for each sheet but not the second. later there will be anywhere from 3-10 on a sheet. Jacque
  7. ImSimple

    Loop not chatching all values

    They're not in a container. I don't know what could be wrong. Thanks for trying. Jacque
  8. ImSimple

    Loop not chatching all values

    :( it didn't work. Jacque
  9. ImSimple

    Loop not chatching all values

    You got it perfectly. There is a character between head and sheet.name i didn't think it would matter since i was using contains instead of equals. i'll give it a try. Fingers Crossed! Thanks! Jacque
  10. ImSimple

    Loop not chatching all values

    What am I doing wrong here? When I put in manual text after the line return it fill in but as is it doesn't pick up all the checkboxes under HEADINGS. It does create all the sheets under SHEETS. 'SHEETS For Each ctrl As Control In Me.Controls If (TypeOf ctrl Is CheckBox AndAlso...
  11. ImSimple

    copy existing worksheet to end of workbook & name ctrl.text

    Thanks Dave. :) Jacque
  12. ImSimple

    copy existing worksheet to end of workbook & name ctrl.text

    I have a windows app with check boxes & a button. I want a copy of the existing sheet in the excel workbook to be made and named for every check box that is checked. I am getting an error that I need a new instance but i'm not sure where to put it. Please help Dim excel As...
  13. ImSimple

    copy existing worksheet to end of workbook & name ctrl.text

    thanks Jacque
  14. ImSimple

    copy existing worksheet to end of workbook & name ctrl.text

    I have a windows app with check boxes & a button. I want a copy of the existing sheet in the excel workbook to be made and named for every check box that is checked. I am getting an error that I need a new instance but i'm not sure where to put it. Please help Dim excel As...
  15. ImSimple

    Invalid Cast Exception

    I thought the "After" and "Name" parameters would be fine since I added the Microsoft Excel Object Library to the project references. Jacque
See more

Part and Inventory Search

Back
Top