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 Rhinorhino 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: Zappd
  • Order by date
  1. Zappd

    Unscramble word using data from spreadsheet.

    Excellent and thank you.
  2. Zappd

    Unscramble word using data from spreadsheet.

    Looks like some screenshots were removed so will try to explain without them to reference. Micron Post 28 Nov 21 17:44 had an example of a search that was removed that met the criteria. On Sheet1 there are five columns containing words that will be searched, A to E. A=3 letter words, B=4 letter...
  3. Zappd

    Unscramble word using data from spreadsheet.

    Micron, 28 Nov 21 17:44 The search results added on date is exactly I'm trying to get. Get a compile error sub or function not defined on regex_test when trying to run. I get this message when trying to use regex 29 Nov 21 17:52 Added code to sort to Sub lbSort and get Compile error: Expected...
  4. Zappd

    Unscramble word using data from spreadsheet.

    Hope this helps and not hinder. Here is the code I'm using. The search is from strongm post from 18 Nov 21 11:12. ThisWorkbook frmSearch.Show vbModeless End Sub Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range) Call condFormat End Sub Module1 Option...
  5. Zappd

    Unscramble word using data from spreadsheet.

    >>If you search for 'aabb', do you get only words where you have 2 a's and 2 b's (abba, baba, xabybaz) or do you accept words with just 1 a and 1 b? There are five columns containing words that will be searched/found. A=3 letter words, B=4 letter words and so on until E which contains 7 letter...
  6. Zappd

    Unscramble word using data from spreadsheet.

    Strongm, That was what I was trying to get. I will work on filtering out the matches longer than the search word and try to get it to sort by smallest to largest. Doing some searches on that so sure I will get there eventually but you helped with what I was having an issue with. Thanks again...
  7. Zappd

    Unscramble word using data from spreadsheet.

    No problem. Thought I was providing the required information. How about this. I have a searchable spreadsheet with words in columns A to E. The words are from 3 to 7 letters in length. Column A is 3 letter words, B is four letter words and so on until E which is 7 letter words. I want to be able...
  8. Zappd

    Unscramble word using data from spreadsheet.

    Andy, Thanks for your patience. Rules: Search columns A to E for any word that matches the letters entered into the seach box. Requirement: Word size will be from 3 to 7 letters in length. Specifications: List found words in listbox. I'm creating this to help my wife with a word game that she...
  9. Zappd

    Unscramble word using data from spreadsheet.

    Andy, Apologize for the bad explanation. It would search columns A to E to find any word that contains the letters provided in the search text box. In this example four would be the maximum word length because that is the number of letters that was entered in the textbox and searched. The...
  10. Zappd

    Unscramble word using data from spreadsheet.

    Hello, How do I unscramble a word using data from the spreadsheet for words that match? I only want to search the words on the spreadsheet, not an entire dictionary. The columns are A to E and each has a header. Word length will be 3 to 7 letters. As an example if seu was searched it would...
  11. Zappd

    Pass credentials from a smartcard

    Here is the code I put together that may help someone else. # Disables smartcard reader, launches IE, and re-enables smartcard reader after four minutes. #####Prompts for admin credentials $myWindowsID=[System.Security.Principal.WindowsIdentity]::GetCurrent() $myWindowsPrincipal=new-object...
  12. Zappd

    Pass credentials from a smartcard

    Here is the same code with less. ##get admin credentials from smartcard $creds = Get-Credential ##Broadcom smartcard reader ##capture smartcard reader using hardware ID $d = Get-PnpDevice | where {$_.HardwareID -like "USB\VID_0A5C&PID_5832&REV_0101&MI_01"} ##disable smartcard reader using...
  13. Zappd

    Pass credentials from a smartcard

    Here's what I'm trying to do and not sure if it's possible. Disable a smartcard reader. Launch IE. When IE process complete re-enable smartcard reader. Issue: It requires admin credentials from smartcard to disable/enable device. IE cannot run under admin credentials so running .ps1 as admin...
  14. Zappd

    Autofill Printer add script

    Here is the final product(for now). Option Explicit Dim ServerName, Computer, PrintQueue, Input, found, SelectedPrinter Dim AddPrinter, SetDefault, PrinterName, MSG, Style, Title Dim Response, WshNetwork Title = "Y" ServerName = "PRINTSERVER" AddPrinter = False SetDefault = False 'Create...
  15. Zappd

    Autofill Printer add script

    Yes, and wanted to know if you saw any issues with pulling the name alone like that. Was planning on using SelectedPrinter as the variable to build the printer.
  16. Zappd

    Autofill Printer add script

    Great work. I'm trying to learn... Do you see any issue with me using this to get the printer name? SelectedPrinter = Right(PrintQueue.PrinterName, 15) Once again thanks so much for all of your help with this.
  17. Zappd

    Autofill Printer add script

    I have tried both codes and still not working. Like I said this is my first post so sorry if I'm not providing you with the correct information. combo, Do I need to Dim foundtext? I'm guessing that should be the output when it works? guitarzan, when I run this all that comes up is "Printer...
  18. Zappd

    Autofill Printer add script

    Thanks for the input. I have been searching for a few days trying to figure this out. Here is what I finally came up with: On Error Resume Next Dim ServerName, Computer, PrintQueue ServerName = "PRINTSERVER" Set Computer = GetObject("WinNT://" & ServerName & ",Computer") Computer.Filter =...
  19. Zappd

    Autofill Printer add script

    Here is what I was trying to test: Dim ServerName, Computer, PrintQueue ServerName = "Printserver" Set Computer = GetObject("WinNT://" & ServerName & ",Computer") Computer.Filter = Array("PrintQueue") For Each PrintQueue In Computer rem WScript.Echo PrintQueue.PrinterName Next found =...
  20. Zappd

    Autofill Printer add script

    guitarzan, That lets me put the \\servername\printername into an array. How do I search the array and pull the printername? I have tried using code like the following but am not able to get it to work. found = false for i = 0 to ubound(iArray) if iArray(i) = value then found...

Part and Inventory Search

Back
Top