Anyone Familiar with Excel & VBA - Net54baseball.com Forums
  NonSports Forum

Net54baseball.com
Welcome to Net54baseball.com. These forums are devoted to both Pre- and Post- war baseball cards and vintage memorabilia, as well as other sports. There is a separate section for Buying, Selling and Trading - the B/S/T area!! If you write anything concerning a person or company your full name needs to be in your post or obtainable from it. . Contact the moderator at leon@net54baseball.com should you have any questions or concerns. When you click on links to eBay on this site and make a purchase, this can result in this site earning a commission. Affiliate programs and affiliations include, but are not limited to, the eBay Partner Network. Enjoy!
Net54baseball.com
Net54baseball.com
ebay GSB
T206s on eBay
Babe Ruth Cards on eBay
t206 Ty Cobb on eBay
Ty Cobb Cards on eBay
Lou Gehrig Cards on eBay
 Baseball T201-T217 on eBay
Baseball E90-E107 on eBay
T205 Cards on eBay
Baseball Postcards on eBay
Goudey Cards on eBay
 Baseball Memorabilia on eBay
Baseball Exhibit Cards on eBay
Baseball Strip Cards on eBay
Baseball Baking Cards on eBay
Sporting News Cards on eBay
 Play Ball Cards on eBay
Joe DiMaggio Cards on eBay
Mickey Mantle Cards on eBay
Bowman 1951-1955 on eBay
Football Cards on eBay

Go Back   Net54baseball.com Forums > Net54baseball Main Forum - WWII & Older Baseball Cards > Net54baseball Vintage (WWII & Older) Baseball Cards & New Member Introductions
Reload this Page Anyone Familiar with Excel & VBA
Register NEW Chat! Who's Chatting FAQ Calendar Today's Posts Search

Reply
 
Thread Tools Display Modes
  #1  
Old 02-16-2018, 08:47 PM
cardsnstuff cardsnstuff is offline
Tony
Member
 
Join Date: Apr 2016
Location: Home of the SB LII Champs
Posts: 356
Default
Quote:
Originally Posted by Tennis13 View Post
I am good enough to be dangerous but bad enough to need help. Do you have the golf club video? I would have thought he would need python for a web scraper, not vba. But if it can be done in vba, i am intrigued to possibly jump down the rabbit hole

Here's the video

https://www.youtube.com/watch?v=Q125hnZaRe0
__________________
MY EBAY STORE; If you see something you Like PM me.
If you bought off me and were happy let others know;
if you bought off me and weren't satisfied for whatever reason let me know..
Reply With Quote
  #2  
Old 02-17-2018, 08:11 AM
Tennis13 Tennis13 is offline
Scott ku.rtis
 
Join Date: Jan 2016
Location: Princeton, NJ
Posts: 207
Default
Quote:
Originally Posted by cardsnstuff View Post

So, this is pretty easy. I didnt realize it was this easy. However, it's bad code because he hard codes in addresses. Its not smart enough to go crawling on its own. So its right inline with my experience of good enough to be dangerous to write bad code, but it can get you to where you want to be if you dont mind dropping in the link manuually. This is easy.
Reply With Quote
  #3  
Old 02-17-2018, 08:55 AM
cardsnstuff cardsnstuff is offline
Tony
Member
 
Join Date: Apr 2016
Location: Home of the SB LII Champs
Posts: 356
Default
Quote:
Originally Posted by Tennis13 View Post
So, this is pretty easy. I didnt realize it was this easy. However, it's bad code because he hard codes in addresses. Its not smart enough to go crawling on its own. So its right inline with my experience of good enough to be dangerous to write bad code, but it can get you to where you want to be if you dont mind dropping in the link manuually. This is easy.
Cool; and THANK YOU; but what does that mean; dropping link manually; Is there anyway to avoid that and do it automatically?; I envision a spreadsheet with thousands of items, eventually. But, hey any help is more than I can do. Thanks.
__________________
MY EBAY STORE; If you see something you Like PM me.
If you bought off me and were happy let others know;
if you bought off me and weren't satisfied for whatever reason let me know..
Last edited by cardsnstuff; 02-17-2018 at 09:03 AM.
Reply With Quote
  #4  
Old 02-17-2018, 08:58 AM
cardsnstuff cardsnstuff is offline
Tony
Member
 
Join Date: Apr 2016
Location: Home of the SB LII Champs
Posts: 356
Default
here's some sample items

2009-10 First Edition #192 Jrue Holiday PSA 10 GEM MINT RC Rookie MEM 76ers
2009-10 First Edition #186 Taj Gibson PSA 10 GEM MINT RC Rookie MEM Bulls
2009-10 48 #81 Dominique Wilkins PSA 10 GEM MINT Hawks
2009-10 48 #98 Clyde Drexler PSA 10 GEM MINT Blazers
2009-10 First Edition #181 Darren Collison PSA 10 GEM MINT RC Rookie MEM Hornets
2006-07 Topps #240B J.J. Redick PSA 10 GEM MINT RC Rookie Magic
2007-08 Finest #79 Nick Young PSA 10 GEM MINT RC Rookie Wizards
2013 Allen and Ginter Across the Years #CRJ Cal Ripken Jr. PSA 10 GEM MINT Orioles
2012 Chrome #45 Clayton Kershaw PSA 10 GEM MINT Dodgers
2013 Topps 1972 Topps Minis #TM-42 Willie Mays PSA 10 GEM MINT Giants
2008-09 Sunkist #3 Carey Price PSA 10 GEM MINT Canadiens
2014 Prizm Rookies #287 Johnny Manziel PSA 10 GEM MINT RC Rookie Browns
2014 Chrome Rookie Die Cuts #CRDC-JM Johnny Manziel PSA 10 GEM MINT RC Rookie Browns
2014 Press Pass Gold #30 Johnny Manziel PSA 10 GEM MINT
2014 Finest #125 Johnny Manziel PSA 10 GEM MINT RC Rookie Browns
2014 Finest Refractor #125 Johnny Manziel PSA 10 GEM MINT RC Rookie Browns
2014 Prizm Believe the Hype #1 Johnny Manziel PSA 10 GEM MINT RC Rookie Browns
__________________
MY EBAY STORE; If you see something you Like PM me.
If you bought off me and were happy let others know;
if you bought off me and weren't satisfied for whatever reason let me know..
Last edited by cardsnstuff; 02-17-2018 at 08:59 AM.
Reply With Quote
  #5  
Old 02-17-2018, 10:08 AM
frankbmd's Avatar
frankbmd frankbmd is offline
Fr@nk Burke++
Member
 
Join Date: Nov 2011
Location: Between the 1st tee and the 19th hole
Posts: 7,595
Default
Quote:
Originally Posted by cardsnstuff View Post
here's some sample items

2009-10 First Edition #192 Jrue Holiday PSA 10 GEM MINT RC Rookie MEM 76ers
2009-10 First Edition #186 Taj Gibson PSA 10 GEM MINT RC Rookie MEM Bulls
2009-10 48 #81 Dominique Wilkins PSA 10 GEM MINT Hawks
2009-10 48 #98 Clyde Drexler PSA 10 GEM MINT Blazers
2009-10 First Edition #181 Darren Collison PSA 10 GEM MINT RC Rookie MEM Hornets
2006-07 Topps #240B J.J. Redick PSA 10 GEM MINT RC Rookie Magic
2007-08 Finest #79 Nick Young PSA 10 GEM MINT RC Rookie Wizards
2013 Allen and Ginter Across the Years #CRJ Cal Ripken Jr. PSA 10 GEM MINT Orioles
2012 Chrome #45 Clayton Kershaw PSA 10 GEM MINT Dodgers
2013 Topps 1972 Topps Minis #TM-42 Willie Mays PSA 10 GEM MINT Giants
2008-09 Sunkist #3 Carey Price PSA 10 GEM MINT Canadiens
2014 Prizm Rookies #287 Johnny Manziel PSA 10 GEM MINT RC Rookie Browns
2014 Chrome Rookie Die Cuts #CRDC-JM Johnny Manziel PSA 10 GEM MINT RC Rookie Browns
2014 Press Pass Gold #30 Johnny Manziel PSA 10 GEM MINT
2014 Finest #125 Johnny Manziel PSA 10 GEM MINT RC Rookie Browns
2014 Finest Refractor #125 Johnny Manziel PSA 10 GEM MINT RC Rookie Browns
2014 Prizm Believe the Hype #1 Johnny Manziel PSA 10 GEM MINT RC Rookie Browns
If this is a prewar mainboard topic, where can I get a helmet and a foxhole. But then again I may just hide behind the water cooler.
__________________
RAUCOUS SPORTS CARD FORUM MEMBER AND MONSTER FATHER.

GOOD FOR THE HOBBY AND THE FORUM WITH A VAULT IN AN UNDISCLOSED LOCATION FILLED WITH WORTHLESS NON-FUNGIBLES

274/1000 Monster Number

Reply With Quote
  #6  
Old 02-17-2018, 10:36 AM
cardsnstuff cardsnstuff is offline
Tony
Member
 
Join Date: Apr 2016
Location: Home of the SB LII Champs
Posts: 356
Default
Quote:
Originally Posted by frankbmd View Post
If this is a prewar mainboard topic, where can I get a helmet and a foxhole. But then again I may just hide behind the water cooler.
They were just recent samples I had, such a thing would be great for all ungraded cards too. For example: I could have provided a sample list of ungraded t206's with standard/various backs in VG
__________________
MY EBAY STORE; If you see something you Like PM me.
If you bought off me and were happy let others know;
if you bought off me and weren't satisfied for whatever reason let me know..
Reply With Quote
  #7  
Old 02-17-2018, 11:17 AM
Tennis13 Tennis13 is offline
Scott ku.rtis
 
Join Date: Jan 2016
Location: Princeton, NJ
Posts: 207
Default
Quote:
Originally Posted by cardsnstuff View Post
Cool; and THANK YOU; but what does that mean; dropping link manually; Is there anyway to avoid that and do it automatically?; I envision a spreadsheet with thousands of items, eventually. But, hey any help is more than I can do. Thanks.
Dropping the link manually: If you see on his video, he is hard-coding that ebay link and pulling data from that. Ebay has very obvious links, so you can write a loop that replaces it programatically and maybe goes through every link -- like he changed some letter in the link, you could just say "find, replace" in the code and do that. In addition, it's my hunch that while ebay caps you at 200, you could probably go into that link and change the 200 to 3000. MAYBE.

You will want to migrate from a spreadsheet to a database eventually -- again, out of my area of expertise, but NOT THAT HARD and I'd bet the other guy that works in VBA probably has some views on this.

I think what you'd ideally like is to build a python webscraper, write it to a database rather than excel, and then build basic SQL queries to pull down attributes. The SQL is easy, the writing to a database is pretty easy, too. The python web scraper, i have failed building a few times, but I'm sure we could collectively stumble through it to create it.
Reply With Quote
  #8  
Old 02-19-2018, 05:23 PM
cardsnstuff cardsnstuff is offline
Tony
Member
 
Join Date: Apr 2016
Location: Home of the SB LII Champs
Posts: 356
Default
I want to give a big THANK YOU to Richard, for his work, we have a working {although, it has issues} version. Once completed I will happy to share with everyone; it will be a tremendous time saver and a tool that anyone who has cards that are not in VCP database {such as raw or modern} or items {such as balls, bats, jersey's, etc} for that matter will appreciate. Can anyone continue on this working model and help us fine tune it? If you can help, please PM me.
__________________
MY EBAY STORE; If you see something you Like PM me.
If you bought off me and were happy let others know;
if you bought off me and weren't satisfied for whatever reason let me know..
Last edited by cardsnstuff; 02-19-2018 at 05:47 PM.
Reply With Quote
Reply

« Previous Thread | Next Thread »



Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is On
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel Spreadsheets for Collection ruth-gehrig WaterCooler Talk- Off Topics 6 09-02-2014 03:02 PM
t206 Excel Doc? drazz5 Net54baseball Vintage (WWII & Older) Baseball Cards & New Member Introductions 3 08-03-2014 10:24 PM
PM me for Excel Spreadsheet of 6,000+ Autographs btcarfagno Baseball Memorabilia B/S/T 28 07-08-2012 07:07 AM
Loading Excel files Pat R Net54baseball Vintage (WWII & Older) Baseball Cards & New Member Introductions 2 06-01-2012 09:00 AM
Excel list for 33 and 34 Goudeys Archive Net54baseball Vintage (WWII & Older) Baseball Cards & New Member Introductions 6 09-03-2008 10:25 PM


All times are GMT -6. The time now is 04:31 AM.

RSS - Contact Us - Home - Archive - Top

ebay GSB