Direct a cell to a product and purchase the product without seeing the process.

%3CLINGO-SUB%20id%3D%22lingo-sub-1739456%22%20slang%3D%22en-US%22%3EDirect%20a%20cell%20to%20a%20product%20and%20purchase%20the%20product%20without%20seeing%20the%20process.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1739456%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20trying%20to%20set%20up%20a%20spreadsheet%20with%20an%20Amazon%20link%20in%20the%20B%20column.%20If%20a%20person%20clicks%20on%20the%20link%2C%20I%20want%20the%20purchase%20to%20occur%20without%20further%20input%20from%20the%20person%20clicking%20the%20link.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBasically%2C%20a%20through-put%20action%20that%20lands%20them%20on%20a%20%22Your%20Order%20Placed%22%20page.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAnyone%20know%20how%20to%20do%20this%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1759024%22%20slang%3D%22en-US%22%3ERe%3A%20Direct%20a%20cell%20to%20a%20product%20and%20purchase%20the%20product%20without%20seeing%20the%20process.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1759024%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F817897%22%20target%3D%22_blank%22%3E%40BruceBoggan%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20could%20think%20of%20a%20solution%20with%20%3CSTRONG%3Exlwings%3C%2FSTRONG%3E%20(which%20is%20a%20Python%20package)%20that%20could%20be%20addressed%20from%20Excel%20to%20do%20the%20purchase%20on%20Amazon%20(with%20the%20help%20of%20%3CSTRONG%3Eselenium%3C%2FSTRONG%3E%20which%20is%20another%20Python%20package%20for%20driving%20web%20pages).%26nbsp%3B%3C%2FP%3E%3CP%3EJust%20checking%20if%20this%20route%20is%20applicable%20for%20you.%20It%20takes%20some%20Python%20programming%20knowledge%20to%20set%20it%20up.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20this%20is%20an%20option%20for%20you%2C%20I%20could%20sketch%20a%20set%20up%20if%20you%20like.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBest%20wishes%2C%3C%2FP%3E%3CP%3ETieme%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

I am trying to set up a spreadsheet with an Amazon link in the B column. If a person clicks on the link, I want the purchase to occur without further input from the person clicking the link. 

 

Basically, a through-put action that lands them on a "Your Order Placed" page. 

 

Anyone know how to do this?

1 Reply
Highlighted

@BruceBoggan 

I could think of a solution with xlwings (which is a Python package) that could be addressed from Excel to do the purchase on Amazon (with the help of selenium which is another Python package for driving web pages). 

Just checking if this route is applicable for you. It takes some Python programming knowledge to set it up.

 

If this is an option for you, I could sketch a set up if you like.

 

Best wishes,

Tieme