Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-05-2023, 05:35 AM
vivka vivka is offline VBA macro issue Windows 7 64bit VBA macro issue Office 2016
Expert
 
Join Date: Jul 2023
Posts: 305
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
  #2  
Old 10-05-2023, 08:32 AM
VBAlearn VBAlearn is offline VBA macro issue Windows 10 VBA macro issue Office 2021
Novice
VBA macro issue
 
Join Date: Oct 2023
Posts: 7
VBAlearn is on a distinguished road
Default

Thank you for the reply. It worked for the 'Docx' files but not the RTF files for Some reason ( I replaced 'Docx' with 'RTF' in the code). Thank you for explaining how to use the paths. Can you try any RTF-converted file? I am unsure if I attach a file here because most people won't download it because of safety issues. Thank you again for your patience
Reply With Quote
Reply

Tags
vba macro



Similar Threads
Thread Thread Starter Forum Replies Last Post
Macro security issue harry Outlook 1 01-19-2023 12:21 AM
VBA macro issue Path issue using a macro on the ribbon troels Excel Programming 1 05-26-2015 10:25 AM
issue in running macro in mac expert4knowledge Word VBA 5 08-13-2014 02:33 PM
MS Publisher Macro Issue Chayes Office 0 06-16-2013 11:36 AM
Macro Issue Basanth Excel 1 12-05-2008 08:07 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:32 AM.


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