#79 "Full Compare": Run-time error 13' Type mismatch with MS Office standard Excel 2013

[Daniel Margerit]

Hi

I have MS Office standard Excel 2013. 15.0 32 bits

When running "Full Compare" I have the error:
Run-time error 13'
Type mismatch

In debug mod the error is on the very beginning on the line

fMain.OpenSession = Session

in the code :

Public Sub Run_Spreadsheet_Compare(Optional Session As String = "")
'On Error GoTo Run_Spreadsheet_Compare_Error

'Load settings
SettingsLoad

Dim fMain As New frmMain
fMain.OpenSession = Session
fMain.Show vbModal

I test it on an other PC with office 2007 and it works well without any trouble. So what is the problem with office 2013?
Could you please help me.

Regards,

[SteveT]

Have you tried the troubleshooting tips in the help file. It may be an issue with one of the Excel controls.

Steve

[Peter Lakatos]

Hi Steve, I am getting the same error on the latest version. I was running the add in on two large excel files and first time it went nicely. Then I started getting the error. I tried to uninstall and reinstall the tool but it did not help.

Cheers, Peter

[SteveT]

This thread is a few years old, so you are better creating a new ticket. If you do, can you detail if you have tried other spreadsheets to compare and if the Quick Compare and/or Range Compare windows appear.

Thanks, Steve