Replies: 12 comments 3 replies
-
|
Hello G.W. Sorry to hear about the trouble. The steps you took should have given you a clean slate. When you receive the error message, does it give you the option to "Debug"? If so, it should open a window with a line of code highlighted. Can you please post that to this ticket? Thanks! Tom Ventimiglia |
Beta Was this translation helpful? Give feedback.
-
|
I've been trying to let go of "should have" in the MSFT context for years now ;-) The line the debugger stops on reads: LookupDialog.LookupRange.Value = sSourceRange. Here it is visually: 
|
Beta Was this translation helpful? Give feedback.
-
|
Thanks, this is helpful. The good news is I don't think the issue was caused by installing the plugin while Excel was still running, so no need to blame yourself. It may be a compatibility issue. Can you please let me know what version of Windows you are running, what version of Excel, and if it is 32- or 64-bit? (You can see this by going to the Home tab, clicking "Account" in the left sidebar, then clicking the "About Excel" button. Tom |
Beta Was this translation helpful? Give feedback.
-
|
Thanks for the quick help, Tom. Microsoft® Excel® for Microsoft 365 MSO (Version 2508 Build 16.0.19127.20082) 64-bit |
Beta Was this translation helpful? Give feedback.
-
|
Thank you. It turns out you are not the only one experiencing this type of error. The solution is not immediately obvious, but I will investigate. However, I may not have an answer before the weekend. Thanks for your patience. One other question - is this your first time installing the plugin, or were you updating a previous (working) edition? Tom |
Beta Was this translation helpful? Give feedback.
-
|
It was my first time. I saw it in a presentation yesterday and had to start exploring it immediately. |
Beta Was this translation helpful? Give feedback.
-
|
I hope we can get you up and running as soon as possible! Tom |
Beta Was this translation helpful? Give feedback.
-
|
Hello again, Sorry for not updating this issue last week. I have been looking into it more. I wanted to ask you for another screenshot of a dialog. When you get a chance, can you please do the following?
Can you please attach a screenshot showing the information in that dialog? Thanks! |
Beta Was this translation helpful? Give feedback.
-
|
No worries re your turnaround time. It would be rude to complain about free tech support. Here's the cap:
***@***.***
And here's that folder's contents (I have hidden files showing):
***@***.***
Regards,
G.W.
…______________________________________________
G.W. Swicord [Working Onsite and Remotely]
Complex Metadata Associate, Resource Description Services
Make a UFDC metadata request here<https://forms.office.com/r/7mg5XyKpGH>.
George A. Smathers Libraries at the University of Florida
Typical pronouns: he/him/his
From: tventimi ***@***.***>
Sent: Wednesday, September 10, 2025 14:57
To: pulibrary/ExcelAlmaLookup ***@***.***>
Cc: Swicord, G.W. ***@***.***>; Author ***@***.***>
Subject: Re: [pulibrary/ExcelAlmaLookup] How do you completely uninstall the Excel Alma Lookup add-in? (Discussion #34)
[External Email]
Hello again,
Sorry for not updating this issue last week. I have been looking into it more. I wanted to ask you for another screenshot of a dialog. When you get a chance, can you please do the following?
* After opening Excel, type Alt+F11 to open the Visual Basic Editor.
* Click "VBAProject (CatalogLookup.xlam)" in the left sidebar.
* Open the "Tools" menu and select "References..."
* A dialog should appear with a list in which the first several entries are checked. If there is one called "Ref Edit Control", click it once so that the bottom of the dialog populates with more detailed information about that control.
Can you please attach a screenshot showing the information in that dialog? Thanks!
-
Reply to this email directly, view it on GitHub<#34 (comment)>, or unsubscribe<https://github.com/notifications/unsubscribe-auth/AQUWKFEPE7NWU5XLM3QJHP33SBX7BAVCNFSM6AAAAACFBI437GVHI2DSMVQWIX3LMV43URDJONRXK43TNFXW4Q3PNVWWK3TUHMYTIMZWGY2DOMA>.
You are receiving this because you authored the thread.Message ID: ***@***.***>
|
Beta Was this translation helpful? Give feedback.
-
|
For some reason, your screenshots were removed and replaced with "@.***". Can you please try posting them again? Tom |
Beta Was this translation helpful? Give feedback.
-
|
I guess GitHub/Microsoft don't feel like processing images pasted into HTML email. Sigh. We had an update cycle last night and the contexts I capped yesterday look quite different today, but I still get the same VB error when I attempt to use the add-in. Excel/VBA selected the Ref Edit Control check box when I tried running the tool. Yesterday: 
Today: Lots more files in the folder today, including REFEDIT.DLL |
Beta Was this translation helpful? Give feedback.
-
|
Thanks very much! I have an idea of what the problem might be. I have made a change to the main dialog, and included it in the beta release of the plugin. Can you please download and install the version below and let me know if it works for you? The main dialog will look slightly different than what is described in the documentation, as this beta version also includes other new features, such as multi-index searching. I am actually going to post some documentation on this new version later today. But I first wanted to confirm that your bug is resolved in the beta as well. Thanks again! |
Beta Was this translation helpful? Give feedback.
-
|
YAY! I see the large, lovely Look up in Catalog dialog box! I look forward to seeing my colleagues drool a little when I show this off. Thank you so much.
Regards,
G.W.
…______________________________________________
G.W. Swicord [Working Onsite and Remotely]
Complex Metadata Associate, Resource Description Services
Make a UFDC metadata request here<https://forms.office.com/r/7mg5XyKpGH>.
George A. Smathers Libraries at the University of Florida
Typical pronouns: he/him/his
From: tventimi ***@***.***>
Sent: Thursday, September 11, 2025 10:07
To: pulibrary/ExcelAlmaLookup ***@***.***>
Cc: Swicord, G.W. ***@***.***>; Author ***@***.***>
Subject: Re: [pulibrary/ExcelAlmaLookup] How do you completely uninstall the Excel Alma Lookup add-in? (Discussion #34)
[External Email]
Thanks very much! I have an idea of what the problem might be. I have made a change to the main dialog, and included it in the beta release of the plugin. Can you please download and install the version below and let me know if it works for you?
https://github.com/pulibrary/ExcelAlmaLookup/releases/download/v1.4.0-beta/CatalogLookupInstaller.exe
The main dialog will look slightly different than what is described in the documentation, as this beta version also includes other new features, such as multi-index searching. I am actually going to post some documentation on this new version later today. But I first wanted to confirm that your bug is resolved in the beta as well. Thanks again!
-
Reply to this email directly, view it on GitHub<#34 (reply in thread)>, or unsubscribe<https://github.com/notifications/unsubscribe-auth/AQUWKFBGCDE7Q3HX36UTOID3SF6ZRAVCNFSM6AAAAACFBI437GVHI2DSMVQWIX3LMV43URDJONRXK43TNFXW4Q3PNVWWK3TUHMYTIMZXGQ4DIMA>.
You are receiving this because you authored the thread.Message ID: ***@***.***>
|
Beta Was this translation helpful? Give feedback.
-
|
Great news. I appreciate your patient screen-shooting and the details your provided. And this should (hopefully) solve a similar issue reported by another user. Just out of curiosity, what was the presentation where you heard about this? Was it something public, or internal to your institution? I saw some increased traffic on the site around the time of your message, so I thought perhaps others who attended the same event also tried downloading it. Hopefully they did not encounter the same issue... |
Beta Was this translation helpful? Give feedback.
-
|
Hi, Tom,
The session where I learned about the tool was offered by our statewide university and college libraries consortium, https://flvc.org/.
I hope that someone will be able to set up the Alma access point next week so our department can start learning and using the tool.
Regards,
G.W.
…______________________________________________
G.W. Swicord [Working Onsite and Remotely]
Complex Metadata Associate, Resource Description Services
Make a UFDC metadata request here<https://forms.office.com/r/7mg5XyKpGH>.
George A. Smathers Libraries at the University of Florida
Typical pronouns: he/him/his
From: tventimi ***@***.***>
Sent: Thursday, September 11, 2025 16:10
To: pulibrary/ExcelAlmaLookup ***@***.***>
Cc: Swicord, G.W. ***@***.***>; Author ***@***.***>
Subject: Re: [pulibrary/ExcelAlmaLookup] How do you completely uninstall the Excel Alma Lookup add-in? (Discussion #34)
[External Email]
Great news. I appreciate your patient screen-shooting and the details your provided. And this should (hopefully) solve a similar issue reported by another user.
Just out of curiosity, what was the presentation where you heard about this? Was it something public, or internal to your institution? I saw some increased traffic on the site around the time of your message, so I thought perhaps others who attended the same event also tried downloading it. Hopefully they did not encounter the same issue...
-
Reply to this email directly, view it on GitHub<#34 (reply in thread)>, or unsubscribe<https://github.com/notifications/unsubscribe-auth/AQUWKFASWD7GTVH3NWEKJLT3SHJJXAVCNFSM6AAAAACFBI437GVHI2DSMVQWIX3LMV43URDJONRXK43TNFXW4Q3PNVWWK3TUHMYTIMZXG43TGNQ>.
You are receiving this because you authored the thread.Message ID: ***@***.***>
|
Beta Was this translation helpful? Give feedback.
Uh oh!
There was an error while loading. Please reload this page.
-
Hello, good people,
Even though I know better, I managed to run CatalogLookupInstaller.exe without closing Excel. When I try to start the tool, the VBA debugger appears letting me know that at line 209 there is a "Compile error: Method or data member not found."
I have tried running the Uninstall.exe, manually deleting the .xlam file, and manually deleting the entire AppData\Roaming\Excel Local Catalog Lookup folder. After I reinstalled using the installer.exe, the error recurs.
Does anyone know how I could fix the problem that I caused for myself?
Regards,
G.W.
Beta Was this translation helpful? Give feedback.
All reactions