compare text

[vlad123]

Hi!
I want to compare the text from 2 different files, to see if there are some differences.
Do you have any idea how can I first open these files to have the text from them? (in VBA)
I have the path and also the file name in 2 variables.
Thanks!

 

[PHV]

One way is to use the FileSystemObject:

http://msdn.microsoft.com/library/en-us/script56/html/FSOoriFileSystemObject.asp

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[vlad123]

thanks a lot!!

 

[comaboy]

Also it might worth your while to investigate Command-Line comp command... ;-)

 

[WalterContrata]

...also WinDiff may be useful, if you have it

WC