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 Chriss Miller 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. HarleyQuinn

    Searching files for a string with VBscript

    It was worth a try! Biting on comments like that helped me learn a fair bit over the years! [smile] Weirdly, I've just had to do this very task (and display the found files). Only really to see if I could write a faster solution than my boss did using LINQ. My Python solution served me pretty...
  2. HarleyQuinn

    Searching files for a string with VBscript

    Not a single bite there Mr Strong...[lol] Andy --------------------------------- Zebracorn: 50% Zebra, 50% Unicorn = 100% Real. http://lessthandot.com
  3. HarleyQuinn

    get the word after backslash

    Yep, that's a nicer way of doing what my last post did [smile] Andy --------------------------------- Zebracorn: 50% Zebra, 50% Unicorn = 100% Real. http://lessthandot.com
  4. HarleyQuinn

    get the word after backslash

    There are more elegant ways, but to make it work that way with my suggestion, try something like:Split(yourString, "\")(UBound(Split(yourString, "\")))Hope this helps Andy --------------------------------- Zebracorn: 50% Zebra, 50% Unicorn = 100% Real. http://lessthandot.com
  5. HarleyQuinn

    get the word after backslash

    Did you try my suggestion? Andy --------------------------------- Zebracorn: 50% Zebra, 50% Unicorn = 100% Real. http://lessthandot.com
  6. HarleyQuinn

    get the word after backslash

    That's no problem, if you change the (1) to (3) in my code that should sort it for you. Hope this helps Andy --------------------------------- Zebracorn: 50% Zebra, 50% Unicorn = 100% Real. http://lessthandot.com
  7. HarleyQuinn

    get the word after backslash

    Another way:yourString = "D123\UNIX" outputString = Split(yourString, "\")(1)Hope this helps Andy --------------------------------- Zebracorn: 50% Zebra, 50% Unicorn = 100% Real. http://lessthandot.com
  8. HarleyQuinn

    DateTimePicker for 24 hour format

    Hmm, mine defaults to 24 hour clock from the get go when I select time... If yours doesn't, then change then Format property to Custom and change the CustomFormat property to HH:mm:ss Hope this helps Andy --------------------------------- Zebracorn: 50% Zebra, 50% Unicorn = 100% Real...
  9. HarleyQuinn

    Extracting numbers from alphanumeric strings

    Taking the above ideas and sticking them in a regex solution... Public Function TheNumber(s As String, LookFor As String, Optional length As Long = 6) As String Dim m As Variant With CreateObject("VBScript.Regexp") .MultiLine = False .Global = False .IgnoreCase = True .Pattern...
  10. HarleyQuinn

    Need help with simple find and copy macro for Word

    Ooops! Sorry, hadn't seen you'd posted again in this thread before I replied [blush] Andy --------------------------------- Zebracorn: 50% Zebra, 50% Unicorn = 100% Real. http://lessthandot.com
  11. HarleyQuinn

    Need help with simple find and copy macro for Word

    You could use something like this:Public Sub GetWebDetails() Dim sSrcUrl as String sSrcUrl = yourURL Dim MyString as String MyString = GetHTML(sSrcUrl) GetRegexDetails(MyString) End Sub Function GetHTML(sURL) As String ' Create an xmlhttp object: With CreateObject("Microsoft.XMLHTTP")...
  12. HarleyQuinn

    regex help

    If you want to do this in the application rather than on the database side, then you don't need regex. A standard replace would do the job just as well. But I'd be tempted to do this when you retrieve your data from the DB rather than in your UI layer. Hope this helps Andy...
  13. HarleyQuinn

    Ajax Error when accessing site through SSL VPN

    I meant to type we're using IIS 6.0, no idea why I typed 4... Andy --------------------------------- Zebracorn: 50% Zebra, 50% Unicorn = 100% Real. http://lessthandot.com
  14. HarleyQuinn

    Ajax Error when accessing site through SSL VPN

    Hi, I've got an issue with an internal company website that when run while connected to our company network directly is running as expected. Superb. We have several users that aren't able to access the network directly, so they connect through an SSL VPN and that works fine for all of the...
  15. HarleyQuinn

    I'm using office excel 2007... Is

    Yep, I get the idea [smile] Pseudo code looks something like this: Select your range (or cell in your range). Call the dialog (Application.Dialogs(xlDialogPatterns).Show), this will change the interior colour of the selected range/cell. Ccode should then be set to the Interior.ColorIndex of...
  16. HarleyQuinn

    I'm using office excel 2007... Is

    It most certainly is... I'd have a look into using Application.Dialogs(). What have you got so far? Hope this helps Andy --------------------------------- Zebracorn: 50% Zebra, 50% Unicorn = 100% Real. http://lessthandot.com
  17. HarleyQuinn

    Access VBA OOP Implements method not executing

    Basic idea of what's wrong is that you're not making a reference to the class that implements clsSimple at all. You're instantiating the clsSimple class and assigning it values directly. Have a go with:Set objSim = New aFormStep through it and see the properties being set in the class...
  18. HarleyQuinn

    Advice Please

    If you are holding anywhere above 1 - 1.5gb of data then I'd say move to SQLServer and have a look into using ADO rather than DAO. Hope this helps Andy --------------------------------- Zebracorn: 50% Zebra, 50% Unicorn = 100% Real. http://lessthandot.com
  19. HarleyQuinn

    Connection string not working when deployed...

    What error does it give you? Andy --------------------------------- Zebracorn: 50% Zebra, 50% Unicorn = 100% Real. http://lessthandot.com
  20. HarleyQuinn

    DAO.recordset filter won't work with preceding wildcard?

    Glad you got it working [smile] I'm guessing that your second example was indeed an example then, not meant to illustrate the code you were using? Andy --------------------------------- Zebracorn: 50% Zebra, 50% Unicorn = 100% Real. http://lessthandot.com

Part and Inventory Search

Back
Top