Log in or Sign up
Coin Talk
Home
Forums
>
Coin Forums
>
Coin Chat
>
I wrote a macro to get numista coin info into Excel
>
Reply to Thread
Message:
<p>[QUOTE="Tom Babinszki, post: 3145584, member: 70812"]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.</p><p><br /></p><p>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.</p><p><br /></p><p>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.</p><p>I hope you will find this tool useful.</p><p><br /></p><p>Here is where you can find the macro:</p><p><br /></p><p><a href="http://blindcoincollector.com/2018/07/28/harvester-copy-information-about-coins-from-numista-into-excel/" target="_blank" class="externalLink ProxyLink" data-proxy-href="http://blindcoincollector.com/2018/07/28/harvester-copy-information-about-coins-from-numista-into-excel/" rel="nofollow">http://blindcoincollector.com/2018/07/28/harvester-copy-information-about-coins-from-numista-into-excel/</a></p><p><br /></p><p>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.</p><p>See discussion here.</p><p><a href="https://en.numista.com/forum/topic72165.html" target="_blank" class="externalLink ProxyLink" data-proxy-href="https://en.numista.com/forum/topic72165.html" rel="nofollow">https://en.numista.com/forum/topic72165.html</a>[/QUOTE]</p><p><br /></p>
[QUOTE="Tom Babinszki, post: 3145584, member: 70812"]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: [url]http://blindcoincollector.com/2018/07/28/harvester-copy-information-about-coins-from-numista-into-excel/[/url] 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. [url]https://en.numista.com/forum/topic72165.html[/url][/QUOTE]
Your name or email address:
Do you already have an account?
No, create an account now.
Yes, my password is:
Forgot your password?
Stay logged in
Coin Talk
Home
Forums
>
Coin Forums
>
Coin Chat
>
I wrote a macro to get numista coin info into Excel
>
Home
Home
Quick Links
Search Forums
Recent Activity
Recent Posts
Forums
Forums
Quick Links
Search Forums
Recent Posts
Competitions
Competitions
Quick Links
Competition Index
Rules, Terms & Conditions
Gallery
Gallery
Quick Links
Search Media
New Media
Showcase
Showcase
Quick Links
Search Items
Most Active Members
New Items
Directory
Directory
Quick Links
Directory Home
New Listings
Members
Members
Quick Links
Notable Members
Current Visitors
Recent Activity
New Profile Posts
Sponsors
Menu
Search
Search titles only
Posted by Member:
Separate names with a comma.
Newer Than:
Search this thread only
Search this forum only
Display results as threads
Useful Searches
Recent Posts
More...