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!

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

Search results for query: *

  1. RHemmings

    Pagebreak problems

    Skip, Thank you. You led me in the right direction. One of my problems was that the first record was a "initial Balance" record and the code was set up so that a pagebreak was the first thing that was requested. It couldn't do it because it was already at a page break (I think). At...
  2. RHemmings

    Pagebreak problems

    With the code below, the only way can get the pagebreaks to work is to include the Rows("16:16").Select line. However, I need to have the pagebreak be variable. If I comment out the Rows line and depend on the Cells(z, 1).Select line, I get an error "Runtime error '1004'...
  3. RHemmings

    Pagebreaks not working correctly

    With the code below, the only way can get the pagebreaks to work is to include the Rows("16:16").Select line. I need to have the pagebreak be variable. However, if I comment out the Rows line and depend on the Cells(z, 1).Select line, I get an error "Runtime error '1004'...
  4. RHemmings

    Combibing to Excel files using VB

    I am trying to combine two excel files into one using the code below. When I execute the code only the FIST cell of the second file gets appended. Can anyone tell me what I am doing wrong? Thanks, Bob Sub CombineFiles(x) Workbooks.Open Filename:="U:\docs\PO IN.xls" ' Count...
  5. RHemmings

    Add a second file to current file in excel

    I am a new user of VB and need to be able to combine two similar files into one. So far I have opened both files and been able to "copy" the second file. I also have been able to count the number of rows in the first file. The question is: How do I set set up the Range with the row...
  6. RHemmings

    VBS Sorting

    Being new to Visual Basic I am wondering if anyone knows how to sort an array when the number of columns are set, but the number of rows vary. Thanks for any help you can give, Bob

Part and Inventory Search

Back
Top