Excel2Latex stopped working after a day

[simon]

Hi, I have been using Excel2Latex on my PC for a while, however without changing anything, it just suddenly stopped working.

I have attached my excel file which I want to convert to latex table. After I highlight the entire cell contents, then click on "Convert table to LaTeX" I get the following error:

Run-time error '1004':

Application-defined or object-defined error

I then click on debug and it leads me to the following VBA code:

Private Function GetDefaultFileName()
    Dim sName As String
    On Error Resume Next
    sName = ActiveSheet.Name
    sName = RangeToUse.Name.Name
    On Error GoTo 0
    GetDefaultFileName = Printf("%1.tex", sName)
End Function

with this line "sName = RangeToUse.Name.Name" highlighted in yellow.

I am using Excel 2010 and v3.3 of Excel2LaTeX. I am using windows XP and I have placed the Excel2LaTeX addin file in the microsoft addin folder. The addin was working fine a few days ago however it just suddenly stopped working, it gives me the same error on every excel file I try.

Many thanks in advance.

[Kirill Müller (krlmlr)]

Could this be a duplicate of #1034141? For a resolution, see my comment #11 in that issue. Does this work for you?

https://bugs.launchpad.net/excel2latex/+bug/1034141/comments/11

[simon (simo-piano)]

Thanks Kirill! That fixed it :)