-
'Guru' Greg, many thanks for the support; this works. However, it also counts valid date format as "incorrect". The expected date format is "d-Mmm-YYYY". If the date format is "dd-MMM-YYYY" (see upper case MMM and 2 digits of dd), then this code considers it as incorrect. Is there a way where we can bypass this using Ucase or Lcase when formatting.
Additionally, I need one help. This code of yours writes the output in the same document as where it checks. I need to have this code in 1st word document and then run through a bunch of word documents in a folder and then capture this information for each document in a 2nd document. I am in the process of identifying on how to run this and other codes for a set of files in a folder, but for now, will it be possible for you to clarify me on how to get the output (ActiveDocument.Range.InsertAfter vbCr & strPath & " - " & lngWrong) not in the active document but on the document where the macro is documented. I would be thankful to you if you can help me on this, as I am in the process of getting some manual tasks automated that can save effort and increase accuracy.
Once again, a very big thanks for the support you have already provided for which I am indebted to you and this community. I would be more happy, if I am able to get solutions for additional queries I might have.
Thanks and regards,
ragav_in
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules