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

    remove space from File name

    never dreamed of a DblQuote Function, like it, it would have saved me years of typing Chr(34)'s ;-) I Hear, I Forget I See, I Remember I Do, I Understand Ronald McDonald
  2. mrmovie

    anguage of style

    ...i think the pattern is to just avoid the nesting, also avoid the Wscript.Quits in each Function, then i dont offend delicate sensibilities I Hear, I Forget I See, I Remember I Do, I Understand Ronald McDonald
  3. mrmovie

    anguage of style

    Hi All :-) I have just finished writing my first serious vbscript in about....god, 5 years. I am stuck between: [Option1] intGReturn = 1 Call Task A If Result from Task A is Good Call Task B If Result from Task B is Good Call Task C ...and so on, we all all good...
  4. mrmovie

    ODBC connection, or other from Linus system using AD account details

    Thanks Frederico, I also found this MS article which describes an implementation: Connecting to SQL from Linux is possible using Kerberos, according to this Microsoft documentation, https://docs.microsoft.com/en-us/sql/connect/odbc/linux-mac/using-integrated-authentication?view=sql-server-2017...
  5. mrmovie

    ODBC connection, or other from Linus system using AD account details

    Hi All, I think I am surpised to find that you cannot create an ODBC connection from a Linus system specifying AD account details in the connection string? that only a local SQL account being specified will work, that to use an AD account you need to choose one of the integrated options in the...
  6. mrmovie

    parameters/ Arguments using powershell

    historically i resorted to: $WshShell = New-Object -ComObject Wscript.Shell $objTask.ReturnCode = $WshShell.Run($objTask.Command + " " + $strParameters, 2, $TRUE) Write-Log ("------ Task(" + $objTask.Name + ").ReturnCode = " + $objTask.ReturnCode) -AsInfo Pretty ugly, but it was the early days...
  7. mrmovie

    Granting View Object Permissions via SQL PowerShell

    hello, how is $vwobject defined / declared and set? I Hear, I Forget I See, I Remember I Do, I Understand Ronald McDonald
  8. mrmovie

    parameters/ Arguments using powershell

    are you interested in if the MSI was successful or not? I Hear, I Forget I See, I Remember I Do, I Understand Ronald McDonald
  9. mrmovie

    Recursively copy files from sub-folders based on date-stamp without cscript\cmd

    for the shortcut the 'startin' can just be blank, then you want: c:\windows\system32\cscript.exe c:\pathtoscript\script.vbs "source_path_here" "target_path_here" ...you could also just create a .bat file or .cmd file and double click that. ...or you could hard code the variables in the .vbs...
  10. mrmovie

    Renaming multiple files

    i see the solution which is nice, still not sure why you need to rename the files.[afro] You could just enum files in the folder and open the file with the name Right(strFileName, "_ApproproateName"),,,and ignore the date so to speak I Hear, I Forget I See, I Remember I Do, I Understand Ronald...
  11. mrmovie

    IBM PCOMM : Need autECL systax for font/screen size change

    could be file based config or registry perhaps? regmon, filemon, procmon etc. would recommend asking the vendor, IBM on how to accomplish this I Hear, I Forget I See, I Remember I Do, I Understand Ronald McDonald
  12. mrmovie

    Problem with script as Scheduled Task

    oh, i would recommend just scheduling tasks on your other servers (each server having a scheduledtask), rather then your 'star' pattern. seems less complicated and would seem more supportable and transparent to me....less complicated as well I Hear, I Forget I See, I Remember I Do, I...
  13. mrmovie

    Problem with script as Scheduled Task

    you should use Chr(34) to wrap your params in your strCommandLine string which contain white space.,..i.e. strCommandLine = ".... -subj " & Chr(34) & strOrgName & " did not run" & Chr(34) & " -msg " & Chr(34) & " hello world" & Chr(34) .. but, i doubt that is your problem if when you run it...
  14. mrmovie

    Need Script to Open and Save .xlsx

    there are probably additional parameters you can supply to the saveas method which allow to automatically choose the options which you are being prompted for I Hear, I Forget I See, I Remember I Do, I Understand Ronald McDonald
  15. mrmovie

    reference types?

    I have ended doing this....which is clearly retarded!!! Public Class Container Public Property ID As String Public Property Children As Dictionary(Of String, String) Public Property Index As Dictionary(Of String, String) Public Property Technical As Dictionary(Of String, String)...
  16. mrmovie

    reference types?

    Hi All, I am showing my age here... I am creating a number of instances of a class (from a different module). at the point of creating the new instance of the class i am passing the New() Sub for the class some information to use / assign to the new instance of the class. I am struggling because...
  17. mrmovie

    VBA to create and update document tags?

    Hi All, So, using the File/Info/Properties/Tags results in data being put into MsgBox ActiveDocument.BuiltInDocumentProperties("Keywords") One can make us of CustomDocumentProperties as well (from MS Help) Set myRange = ActiveDocument.Content myRange.Collapse Direction:=wdCollapseEnd For Each...
  18. mrmovie

    VBA to create and update document tags?

    ..hmm, no, nothing gets recorded when you record a macro and go to File\Info\Properties\Tags I Hear, I Forget I See, I Remember I Do, I Understand Ronald McDonald
  19. mrmovie

    VBA to create and update document tags?

    Hi Andy, havent tried that, only because i read another post staying that they had tried that but nothing was recorded. Thanks for the post though. I will take a look at it tomorrow :-) I Hear, I Forget I See, I Remember I Do, I Understand Ronald McDonald
  20. mrmovie

    VBA to create and update document tags?

    Am looking for examples of how to set / create / update document tags? Probably start off with word documents, need to handle .doc and .docx if there are any differences in tagging implementation i dont know. have found things talking about ActiveWorkbook.ContentTypeProperties("Line of...

Part and Inventory Search

Back
Top