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 derfloh 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: jackeroo75
  • Content: Threads
  • Order by date
  1. jackeroo75

    How to search sub folders

    This code works but I want to also check all sub folders in C and get the owmer information from the file. Sub Test() Dim Sh As Object Dim ShFolder As Object Dim ShFile As Object Set Sh = CreateObject("Shell.Application") Set ShFolder = Sh.Namespace("C:\") 'CHANGE...
  2. jackeroo75

    How do I access table option?

    http://blue.kingcounty.gov/Courts/Detention/JILS/default.aspx <select name="tableResults_length" aria-controls="tableResults" class=""> <option value="10">10</option><option value="25">25</option><option value="50">50</option><option value="100">100</option></select> Above is the WEBPAGE...
  3. jackeroo75

    macro for excel addin (pdf maker) to send via OUTLOOK

    I have a adobe PDFMAKER icon for office 2003. I open a excel document in EXCEL 2003 then I use the adobe PDF (an icon placed in excel or add-in) to covert the excel document and then send as attachment to outlook 2003. I can do this manually, but would like to automate using a macro in EXCEL...
  4. jackeroo75

    Optimize my code

    I know I can do this better but I'm not sure how to optimize my code. Const sWorkRel1 As String = "1-*" Const sWorkRel2 As String = "3-*" Const sWorkRel3 As String = "4-*" Const sWorkRel4 As String = "49*" Const sFloora As String = "11*" Const sFloorb As String = "10*" Const sFloorc As String =...
  5. jackeroo75

    Anbody knows a more efficient way of doing this search?

    I query the data from our database and copied it to Excel. I compare the sheet and if it matches then copies it to another column. It takes forever to do this. Is there a better way of programming this? Should I store it an array?? help.. For k = (g_startRow + 1) To (endofRow - 1) 'Get...
  6. jackeroo75

    Any improvement in this code

    Const Dest$= "T" Const Lstr$ = "L" Dim i As Integer i = 1 J11flr$ ="4N11,4E11," J10flr$ ="4N10,4S10,4E10," J09flr$ ="4N09,4S09,4E09," J8Yflr$ ="4N07,4E08U,4E08LB,4E08LC,4S08U,4S07LD," '7NORTH & 7S (Y floor) J08flr$ ="4E08LA,4S07," 'Medical 8th floor...
  7. jackeroo75

    Make all checked boxes as default?

    Hi, How do I make it so all checked boxes in the dialog box are checked as default? I checked the help to no avail.
  8. jackeroo75

    Tree view in Dialog Box

    Can I create a treeview in a dialog box?? Jackeroo75
  9. jackeroo75

    How to automate webpage in IE

    I know how to get to the website, but how do I choose from the 3 radio buttons. Then choose from a listbox and click go. Then refresh the page. Here is the website. http://www.metrokc.gov/dad/inmatelookup/ I want to 1. Click on View Jail Register. 2. Choose the second radio button which...
  10. jackeroo75

    Extra Object.Paste: HOw do I assign it to a variable

    Scenario: I tried MyNumber$= Sess0.Session.Paste and when I debug it it shows "" or "Empty". But when I use Sess0.Session.Paste it paste the 9 digit number to my active screen. Why can't I assign this? I created a macro that copy a 9-digit number in active session in Extra by using BaNumber$...

Part and Inventory Search

Back
Top