Thread: VBA macro issue
View Single Post
 
Old 10-05-2023, 05:35 AM
vivka vivka is offline Windows 7 64bit Office 2016
Expert
 
Join Date: Jul 2023
Posts: 302
vivka is on a distinguished road
Default

Hi! If the files to compare are Tables2 and these files are the only ones in the respective folders, then correct code lines will be:

strOPath = "D:\OneDrive - MSOPROD\test\Desktop\Old"
strRPath = "D:\OneDrive - MSOPROD\test\Desktop\New"
strCPath = "D:\OneDrive - MSOPROD\test\Desktop\Result"


Note that the Result folder should have a name different from other two folders.
PS. I didn't check the code on rtf files. I think it should work, but if it doesn't I'd save the files as docx (it's simple and easy) and then run the code.

Last edited by vivka; 10-05-2023 at 12:48 PM.
Reply With Quote