Extract Records from Two Opened Workbooks based on A Column

[vikas_newports]

Hello
I want to extract the difference between two excel files and save it to my Maco files sheet name (NEW_RECORDS)
File Names changes on daily basis so I am selecting Files manually

File1 have old records and File 2 have new records. I am finding the new records based upon Column C (Account IDs)
I am using vlookup before automating it

I need your suggestion to achieve it.
my code is as under

Sub New_Records()

    Application.DisplayAlerts = False
    Application.ScreenUpdating = False
    Dim FileToOpen As Variant
    Dim OpenBook As Workbook
    Dim FileToOpen1 As Variant
    Dim OpenBook1 As Workbook
    
        'Select File to be Open
    FileToOpen = Application.GetOpenFilename(Title:="Select File1", FileFilter:="CSV Files (*.csv*),*csv*")
    If FileToOpen <> False Then
        Set OpenBook = Application.Workbooks.Open(FileToOpen)
        
    End If
    Application.ScreenUpdating = True
    
    
            'Select File to be Open
    FileToOpen1 = Application.GetOpenFilename(Title:="Select File2", FileFilter:="CSV Files (*.csv*),*csv*")
    If FileToOpen1 <> False Then
        Set OpenBook1 = Application.Workbooks.Open(FileToOpen1)
        
    End If
    Application.ScreenUpdating = True

End Sub

 

[Fluff]

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: compare two excel files and extract differences [SOLVED]
If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

 

[vikas_newports]

@Fluff thanks but what is the solution?

 

[Fluff]

No idea, but you've marked it as solved on EF.