Jump to content

Excel help please?


Recommended Posts

With ActiveSheet.QueryTables.Add(Connection:= _

"URL;http://www.neopets.com/stamps.phtml?type=album&page_id=1&owner=", Destination:=Range("$R$8"))

 

I'm trying to make a stamp logger for neopets, and everything works. All I need to do is to make it so it works for just your album, so I need the link to display your username at the owner= part, just wondering if anyone could help me? :)

Link to comment
Share on other sites

This sort of answers your question but there is a database on http://www.s2bookworld.co.uk/ that already does this. They have a database of stamps, avatars, foods, collectable cards, book, booktastic, and BD challengers.They update it all the time so you wouldn't have to worry about that. It also shows all the other stamps you still need and general prices. (might not be super up to date but it helps)

 

I don't know how to answer your problem in excel but that is my solution.

Link to comment
Share on other sites

Yeah it is my guild so that is how I heard of it. I understand trying to get yours working though. That one just has the one click import like here. I prefer here for avatars but there for the rest of the database.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
×
×
  • Create New...