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 wOOdy-Soft 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: *

  • Users: lucrahouse
  • Content: Threads
  • Order by date
  1. lucrahouse

    Automating access to a linux web server

    I would like to automate access to a linux web server to download excel spreadsheets. Another department places results in a spreadsheet and places the spreadsheets on a web server. They granted me permission with a logon and password, and through internet explorer, go to the web server click on...
  2. lucrahouse

    how to use Class Modules

    I'm trying something new. I want to learn how to use class modules, because I think it will take less time to process. Previously, I would read the data into table arrays and spit out the results in a results table. Here is an example of what I'm trying to accomplish. Here is my Data. 1 AIG...
  3. lucrahouse

    Creating a user defined class

    I was trying to learn something new. I wanted to take an example from my book, "Teach Yourself Excel in 21 Days", on page 457, was an example of a user defined class called electric heater. I want to be able to create multiple heaters and name each one something different. Here is an example of...
  4. lucrahouse

    using advanced filter to find unique values

    I was trying to use the advanced filter under data/filter and my criteria was just one character such as the letter "T" but unfortunately it also gave other values which began with the letter "T" such as "TGT" or "TRP". I double checked and made sure I was filtering for only unique values, but...
  5. lucrahouse

    For Loop

    I'm trying to loop through shapes on a worksheet. These Shapes happen to be check boxes. I can call them by name as in this example. ActiveSheet.Shapes("CB20_DTS").Select But what I wanted to do is use the FOR LOOP but I can't seem to find the right wording. This example doesn't...

Part and Inventory Search

Back
Top