Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #3  
Old 03-02-2016, 12:34 PM
NoS NoS is offline Macro to change/convert/delete txt files in folder+subfolders Windows 7 64bit Macro to change/convert/delete txt files in folder+subfolders Office 2013
Novice
Macro to change/convert/delete txt files in folder+subfolders
 
Join Date: Mar 2016
Posts: 3
NoS is on a distinguished road
Default

Thank you very much, macropod!
As for the first find/replace problem you found, I think you are correct and something got mixed up. I´ll look into it.
As for replacing "'" with itself, it seems that by copying the code here, the forum changed the html-way of writing "'", which I have in the txt files, automatically to the correct way of displaying the character, which is basically the same thing I am doing in the txt files. So it may seem unnecessary but at least to this one there is some logic

As for the code, there still seems to be a problem. I apologize if I did not understand correctly or if am being stupid here, but if I paste it into the VBA editor and then run sub "Main", I get to the part, where it asks me for the top folder. After selecting it, I get a runtime error 424 "object required" though. Do you have any idea why?

Also, could you change the popup asking to select the location to a fixed one in the code? I understand that your solution is much more elegant but the folder will never change and thus I can save a few more clicks during the day.

Once again, thank you for your help!
Reply With Quote
 

Tags
subfolders, vba macro



Similar Threads
Thread Thread Starter Forum Replies Last Post
Macro to change/convert/delete txt files in folder+subfolders Macro to change all text color to black in all docx files in a selected folder joewoods Word VBA 13 05-16-2016 06:29 PM
Macro to replace SSN in all files within a folder caj1980 Word VBA 7 09-11-2014 04:17 PM
Macro to change/convert/delete txt files in folder+subfolders macro to change name of files in a folder in order expert4knowledge Word VBA 5 07-10-2014 03:54 PM
Macro to change/convert/delete txt files in folder+subfolders Word Macro - change date in footer for all files in a folder patidallas22 Word VBA 2 03-09-2012 08:14 AM
Macro to change/convert/delete txt files in folder+subfolders Macro to loop in subfolders, change links, export xml data Catalin.B Excel Programming 2 09-08-2011 11:37 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:05 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft