Comment 9 for bug 1034141

Dear Kirill,

I am experiencing the same bug. Below I will describe the exact problems I have.

In the past I have used Excel2Latex in an excel file with success. Later I have changed my entire folder structure on my current with the result that both the excel file as the .xla file are now in another location. Since then I am experiencing problems, in the sense that I run into the following error when I use it in a new file:
Error 1004 during execution
Method Range of object_Application failed.

When I click on the button to go to the code in debugging mode I get sent here:

Public Function AddressToRange(ByVal sRangeAddress As String) As Range
    Set AddressToRange = Nothing
    If sRangeAddress = "" Then Exit Function
    Set AddressToRange = Application.Range(sRangeAddress)
End Function

For some reason sRangeAddress contains the name of the tab in the old excel file I used Excel2Latex in. Then it got interesting:
I openend this old excel file (not in the same location as it was then) and tried whether Excel2Latex worked there. This was the case. It also worked in the other tabs of that file. But as soon as I did that sRangeAddress fixed to this new tab name in the debugging when I run Excel2Latex in my current file.
What stunned me even more was that when I change the tab name in my current file to the exact same as is currently in sRangeAddress, it worked!!!

Summarizing, for some reason it does not reset the range, in particular the tab name. Can you fix this bug?

I have already tried, without success, multiple times to delete Excel2Latex from my computer, and from Excel Add-Ins. Even deleted it from the ribbon in excel, which is not standardly done when deleting it from the Add-ins. Installed new downloaded version. All without success.

Some additional information:
- I am using Excel 2007.
- In the attachment I have added the complete call stack.
- There are no hidden sheets (that are not my own) in either the old nor the new excel file.
- It also does not work on excel files created on other computers.
- I do not remember my exact previous folder structure, so I cannot recreate it to test it.

I hope you can help me to fix this problem.

Kind regards.

Roland