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!

Recent content by tractng

  1. tractng

    script to delete files modified in a particular folder

    Guys, I need help with a script where I can tell it to delete files older than 2 days (date modified) in a folder called "c:\backup". I was able to find some similar codes (see below), but this codes goes and delete folders instead files. TIA, Tnt ------------------------------ Option...
  2. tractng

    Wrapping output in quote to distinquish from comma in field

    Thanks man. I will give it a try and will report back.
  3. tractng

    Wrapping output in quote to distinquish from comma in field

    In notepad, it looks fine, but when I opened it up in excel (csv), the field are push back when the data has a comma in it. Is that normal? tnt
  4. tractng

    Wrapping output in quote to distinquish from comma in field

    Guys, I need be able to tell the field that some of the data has a comma in it. For example, the field Title. It may have something like VP, Finance. With the current code, it thinks it is a seperate field. Below is my code. ------------------------------------------------- 'Global...
  5. tractng

    Help me get started with the ldap

    Guys, I am looking to connect to AD and pull some of the following information from it. I am looking to get First Name, Last Name, Phone Number etc. One of the criteria is to look at the "Member of" and determine if he/she is a member of the F-Accounting or F-MHR. Then output the result...
  6. tractng

    Calling the second file when both files are opened

    Guys, Lets say the Drawing.idw and Part1.ipt files are already open by the users. The .Drawing.idw will be the "active document". How do I call the Part1.ipt file so it will be the file that I want to copy the information too? Instead of hard-coding. Set oDoc1 =...
  7. tractng

    File Location for directory

    Robert, It doesn't work. The files are already opened by the user. Before the script is run, i want to have a prompt box that prompts the user for the exact location (that the file is going to be updated). With that exact location, it goes into memory for the following line (instead of hard...
  8. tractng

    Help verifying items

    Guys, The codes work when the value matches the listed items from the material component. Since I am reading the value from another place, the end users might have entered "steels" instead of "steel". Any codes that I can check to see it matches, if it doesn't match then I want a message...
  9. tractng

    File Location for directory

    Guys, Instead of hard coding the location of the file, I like to have a dialog box that allows the user to locate the file. Any code samples or link I can use. Set oDoc1 = oApplication.Documents.ItemByName("C:\twd\Part1.ipt") Below is my complete code. I commented things out for testing...
  10. tractng

    Carry a variable in memory (substitute)

    Thanks so much. Tony
  11. tractng

    For Each loop and storing data

    Thanks so much. Tony
  12. tractng

    Carry a variable in memory (substitute)

    Guys, Its been years I have touch VB/VBA. How do i carry a variable in memory. I need to put the value of Myvalue on this line below. I recall something about using the % or &, but its been too long time ago. oPropsets2.Add "'%Myvalue%'", "Category", 2 Thanks, Tony...
  13. tractng

    For Each loop and storing data

    Guys, How do I keep/write the variables on the section of the "For Each". I want to be able to store them in memory and write them to another file of the property page called (Part1.ipt). Right now, I can read the value. Not sure what to do it from there. Btw, the field has a value and a...
  14. tractng

    calling non active document

    Tony, I will try each one individually. There will be two files opened by the user. The documents have full file. I just want to make sure the file that i am updating is opened within the software. Thanks, Tractng
  15. tractng

    calling non active document

    Tony, This is what the vendor suggested. Use oApplication.Documents.Item or oApplication.Documents.ItemByName to obtain the second document of interest. The ItemByName property accepts the full file name of the document that is open. I was able to use: Set oDoc1 =...
See more

Part and Inventory Search

Back
Top