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. VulcanJedi

    PowerShell save as xlsx without excel

    come on another separate post in the vbscript forum? for example a family tree related csv Import-csv yourfile.csv|select person, surname, given, gender|sort gender, surname,given|export-csv newfile.csv open the csv in xl or rename it to xls..etc
  2. VulcanJedi

    Need help with Escll 2007 and VBS script

    CSVs are just text files. If you need this in xls/xlsx format, and can't do this via the web application, and dont have XL installed. Yes I think Powershell is the best approach for this. Import the CSV in PoSh, or get content, sort-object by said column headers, export csv or out file or...
  3. VulcanJedi

    How can I do copying to files including variables from inside the vbscript

    where are your errors? I'm pretty sure *.txt makes no sense here. FSO.CopyFile &Folder &"\" &FileName &"*.txt", &Folder &"\" &FileName &".txt" You have to enumerate those yourself. That command literally just copies files, it doesn't have context to what files are in the folder you are in.
  4. VulcanJedi

    Reading KML with VBScript

    [Link
  5. VulcanJedi

    add domain group to local admin group

    Did you update this script for the post? I'm not familiar with KACE and been quite a while since I played in vbscript, but you may want to check LDAP approaches as well. Or this the real code? Cause GetObject("WinNT://./Administrators") the . needs to be parse for differnt names, where '.' is...
  6. VulcanJedi

    Powershell script - Directory name as argument

    $DIR\temp\sc.exe You can see this from the console: $dir=pwd Should be $DIR + "\temp\sc.exe" or "$dir+\temp\sc.exe" or "$dir\temp\sc.exe"
  7. VulcanJedi

    Excel - convert "1 hour, 20 minutes" to 1.33

    IF you need to 'functionalize' it => Link
  8. VulcanJedi

    Excel - convert "1 hour, 20 minutes" to 1.33

    Sub timefraction() theColumnwiththeNumbers = 1 For x = 1 To Application.ActiveSheet.UsedRange.Rows.Count - 1 theValue = Application.ActiveSheet.Cells(x, theColumnwiththeNumbers) theSplit = Split(theValue, Chr(32), , vbTextCompare) theH = theSplit(0) theM = theSplit(2)...
  9. VulcanJedi

    "No Disk" error when checking network drives

    drvMAP also is preset to FALSE outside the loop. if it ever trips TRUE it will stay TRUE throughout the loop.
  10. VulcanJedi

    "No Disk" error when checking network drives

    turn on error resume next off to see where errors occur.
  11. VulcanJedi

    HTA: Wait for event before continuing script

    This seems to not make sense, or barking up wrong tree. If you already want them to hit submit, just add to the submit box code.
  12. VulcanJedi

    Chr(13) = Carriage Return not working in email

    does the vb constant vbCrLF work?
  13. VulcanJedi

    Need help with a simple script

    Check out Link There is frankly a bunch of weird things in your example. You can't use .run the way you are to call a function. findFolder(strDir, strFlag1) & "\strflag2" How does strflag2 come into play at all?
  14. VulcanJedi

    Excel 2010 - convert <1 to 0 and >xxx to numeric value

    http://office.microsoft.com/en-us/excel-help/creating-custom-functions-HA001111701.aspx Public Function ConvertForGraph(theValue) If InStr(1, theValue, "<1", vbBinaryCompare) > 0 Then ConvertForGraph = 0 ElseIf InStr(1, theValue, "TNTC", vbBinaryCompare) > 0 Then ConvertForGraph =...
  15. VulcanJedi

    How to limit changes to filename syntax to first 9 files only

    There a ton of other free renaming tools that will accomplish what you are trying to do much faster/easier and more robustly. Where you can create rules/macros..etc than a custom script. You can not rewrite the name of the file object in this manner. You would need to 'move' this file from a.txt...
  16. VulcanJedi

    Write current network drive mappings to event log -Help please!

    As I suggested: Link
  17. VulcanJedi

    enter pound or hash from numpad

    From Lync 2010, one could via keyboard numpad press the ENTER key for a # (hash) key. On 2013 this doesnt seem to work? Anyone w/ insights?
  18. VulcanJedi

    Change description in shortcut name

    Jeepix how are you doing this vbscripting? Are you using any IDE at all? I think you could save yourself a lot of this heartache I'd suggests VBSedit, just to get a base, with some samples loaded and an object broswer. It has a trial version.
  19. VulcanJedi

    Change description in shortcut name

    isn't the description just shortcut.description = "A" shortcut.save ? Works for me in a dummy test on my VM. The comment field is updated.
  20. VulcanJedi

    Need help getting script to save a file and then open saved file

    This seems flawed to me. First of all you already loaded the object for the shell, then loaded again? w/in another statement? As previous post suggests, not sure the line numbers but be really surprised this works? Regardless I would clean this up. Also if your environment is mixed this isn't...

Part and Inventory Search

Back
Top