Eversince I have known Numista, I always wanted to be able to get information about a coin and directly import it into my Excel sheet, where I store information about my coin collection. Unfortunately, I was not able to find a way to do it. At some point, I have come across a solution, but it didn't work for what I was hoping to do. I was trying to figure out if there would be a way to create an API, but I couldn't get anywhere with it. For the lack of better, I created an Excel macro which seems to be able to get the job done. It is able to populate my Excel sheet with 12 different pieces of data from a con record from Numista. Please excuse me for the shameless blog promotion, but I would like to reference my blog where I have shared this macro and detailed how to use it. This way if the macro gets updated, I only have to update the instructions at one place. I hope you will find this tool useful. Here is where you can find the macro: http://blindcoincollector.com/2018/...ormation-about-coins-from-numista-into-excel/ I did post about this on Numista, and the official feedback was that as long as we keep a reasonable traffic it is fine and is not against the Numista terms. See discussion here. https://en.numista.com/forum/topic72165.html
I appreciate the effort you put into this. I think you'll find, however, that a lot of people are hesitant to download files, especially ones containing macros. There are many potential security concerns there.
Thank you, very good point. I didn't think about it, ok, I know I don't have anything unsafe in the file, but how would you? I could post the text of the macro and explain how to add it to your own excel sheet that way it would just be copy/paste of plain text from a web page. I'll try to post it soon.
The code is now available in a text file. Unfortunately this way you will have to set it up. I did update the instructions as well with setup instructions in case you choose to get the code for yourself. Here is the link where you can find the downloads and instructions: http://blindcoincollector.com/harvester/ Again, thanks for pointing out this issue, let me know if I can further help with anything.
Last year I posted here about the macro I created. I completely rewrote the macro, this way it is much faster, instead of 5-10 seconds it takes about 1 second to read a record from Numista, wich is also less taxing for their bandwidth. Also, instead of 12 pieces of information, I was able to retrieve 18 with higher accuracy. The above links still work if you would like to read about it, get the Excel file, or just the code itself. I hope it helps someone.
