Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 302
  • Last Modified:

excel show two files at the same time

using excel 2007 for windows

Please teach me how to compare two .csv files, so I can see both at the same time.
0
rgb192
Asked:
rgb192
4 Solutions
 
duncanb7Commented:
Could you use Excel 2007 VBA code ?  for example,  following code using FileDateTime function,

Range("a1") = FileDateTime("d:\file1.csv")
Range("a2") = FileDateTime("d:\file2.csv")
If  Range('a1") =Range("a2") Then
Range('a3") ="True"
Else
Range("a3")="False"
End If

Hope understand your question completely, if not, please pt it out
Duncan
0
 
Saqib Husain, SyedEngineerCommented:
You do not need VBA to do this. Simply go to

View > Arrange all
0
 
Saqib Husain, SyedEngineerCommented:
Alternatively,

Restore the file window (Not the excel window) by clicking on the square button next to the X button (for close file) and then resize the windows as desired.
0
 
theo kouwenhovenCommented:
Excel isn't the best program for this, I prefer the compare option Notepad++ (Freeware)
0
 
rgb192Author Commented:
All these options could work,
Saqib Husain, Syed is the easiest.

Thanks.
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now