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

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

    XP Batch File

    I'm new to batch file scripting, and I was wondering if the following would be possible: I have many routers that I manage. I want to be able automatically telnet to each one and run the same set of commands. Each one has a different IP address and password, which I can store in a text file for...
  2. Wire216

    Access - Subtracting times in VBA

    I'm trying to find the difference in minutes between two times, and store the result in an integer. For example: StartTime = 9:43:22 AM EndTime = 9:47:17 AM If I do EndTime - StartTime, I want to store the result (4) as an integer. When a user presses the "start" button on my form, I assign...
  3. Wire216

    Separating the contents of a textbox

    I have a textbox that is used to enter multiple 2-digit numbers, separated by commas. I want to assign each 2-digit number to a separate string variable (or array element). For example: If the textbox contains "22,25,29,31" I want to have variables like these: Str1 = "22" Str2 = "25" Str3...
  4. Wire216

    Finding matching rows on two worksheets

    I'm trying to compare rows on 2 worksheets. If there are matches then I want to take the rows off of the 1st worksheet and move it to a 3rd one. My 1st worksheet consists of "admin calls." Column A is the phone number, H is the date, and F is the start time. My 2nd worksheet consists of...
  5. Wire216

    Converting military times to numbers

    I have a column that contains times in military format. I want to convert the times to numbers, with no formatting. For example: Right now the columns show the following: 0:01 0:23 2:14 13:32 19:54 Their actual values are: 12:01:00 AM 12:23:00 AM 2:14:00 AM 1:32:00 PM 7:54:00 PM I want it...
  6. Wire216

    Excel - Copy cell contents to next blank row

    I use Excel to log calls at my work. On each call I fill out a small template (2 columns, 11 rows). I have a button (macro) that copies the template to a clipboard so I can paste it into a call tracking system. In the same workbook I also have an area where I record a few of the fields in...

Part and Inventory Search

Back
Top