Search results for query: *

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

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

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.

[Link

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

$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"

IF you need to 'functionalize' it => Link

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

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

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

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.

does the vb constant vbCrLF work?

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?

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

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

As I suggested: Link

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?

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.

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.

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