Results 1 to 8 of 8

Thread: Help with renaming part of file

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    VBAX Sage
    Joined
    Apr 2007
    Location
    United States
    Posts
    8,715
    Location
    Are you using VBA or Windows Scripting Host?

    It looks like you're using WSH (the .VBS), but the statements are VBA so I'm not surprised it isn't working

    You were also missing some path seperators

    If you want to use WSH, then use the FileSystemObject and the .Files collection

    Some thing like this

    
    Dim strFolder
    Dim strFile
    dim oFSO, oFiles, oFile
    
        strFolder = "C:\Users\Daddy\Downloads\test\"
        
        Set oFSO = CreateObject("Scripting.FileSystemObject")
    
        For Each oFile in oFSO.GetFolder(strFolder).Files
            strFile = oFile.Name
            If InStr(strFile, "Model (1)") > 0 Then
                oFSO.MoveFile strFolder & strFile, strFolder & Replace(strFile, " Model (1)", "")
            End If
        Next
        
    Last edited by Paul_Hossler; 06-08-2019 at 07:50 PM.
    ---------------------------------------------------------------------------------------------------------------------

    Paul


    Remember: Tell us WHAT you want to do, not HOW you think you want to do it

    1. Use [CODE] ....[/CODE ] Tags for readability
    [CODE]PasteYourCodeHere[/CODE ] -- (or paste your code, select it, click [#] button)
    2. Upload an example
    Go Advanced / Attachments - Manage Attachments / Add Files / Select Files / Select the file(s) / Upload Files / Done
    3. Mark the thread as [Solved] when you have an answer
    Thread Tools (on the top right corner, above the first message)
    4. Read the Forum FAQ, especially the part about cross-posting in other forums
    http://www.vbaexpress.com/forum/faq...._new_faq_item3

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •