Steve Rindsberg Steve Rindsberg 3, 1 1 gold badge 14 14 silver badges 10 10 bronze badges. How is this code any different from the code in the question?! Guess I'm too late Write strContents objTS.
Bojie Shuai Bojie Shuai 2 2 silver badges 9 9 bronze badges. Nice and probably faster than the other proposals — Patrick Honorez. Best of my Choice. I have had the same problem and came acrosse this site. Geoff 8, 1 1 gold badge 38 38 silver badges 49 49 bronze badges.
This does not address the question. Active Oldest Votes. FunThomas FunThomas Sign up or log in Sign up using Google. Sign up using Facebook. Sign up using Email and Password. Post as a guest Name. Email Required, but never shown. The Overflow Blog. Podcast Making Agile work for data science.
Stack Gives Back Featured on Meta. New post summary designs on greatest hits now, everywhere else eventually. Related You can also go through our other suggested articles —. Submit Next Question. By signing up, you agree to our Terms of Use and Privacy Policy. Forgot Password? This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy.
By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy. Login details for this Free course will be emailed to you. Email ID. Contact No. I am trying to write a macro to replace a string of characters like a part number in a workbook with a new string of characters, all of which are on a separate spreadsheet.
There are 25, pairs of strings to replace on the spreadsheet, and the one to be replaced could be on any sheet of a workbook. I have workbooks to do. Thanks very much for your code. I have used it in my code but I had to fix a "little" issue.
Therefore, here is the fix I have done to handle that situation :. OK Correct. Your email address will not be published. How to extract a list of all the files and fo Import data from a closed workbook ADO usin
0コメント