Hypertext link to external site automation

Desired functionality:

Advanced Order Entry support from Excel to our web site shopping cart.

Our web site currently supports the addition of a product to the shopping cart by means of a specifically coded hypertext link. The link must contain the product id number and the desired quantity. We currently imbed this type of link into PDFs and Excel files that we distribute to our customers.

The "advanced" aspect of this post is the desire to add a Batch Update button to an Excel file that has many rows, each row containing a product id and a column where the customer may enter a desired quantity.

The button when clicked would run VBA code that scans the Excel file for rows with non-blank desired quantity and ultimately generate and submit hypertext links with product id and quantity to our shopping cart.

Does this appear to be a capability of VBA code?

Any assistance would be appreciated.

Thank you.

Hello Tom,

Welcome to the forum. I do believe this can be accomplished using VBA. It would help to see the layout of the workbook, and the web page. Please include which versions of Office and Windows you are using also.

Sincerely,
Leith Ross

Hi Leith,

Thank you for the response and the encouragement that my objective is possible.

The worksheet layout could be as simple as 2 columns, SKU# and Desired Quantity.

The hypertext link we currently imbed in PDFs or Excel files is typically like this...

Please Login or Register  to view this content.

What I am hoping for is a VBA function that will create the href (with the sku number for the row) and the qty= (the value in the desired quantity column for the row) and then submit the href.

The function would process all rows in the worksheet with non-blank desired quantity.

We intend to email the Excel file with the VBA code to our customers, so the version of Office and Excel the customer is using is not within our control.

I hope these answers are responsive to your questions.

Again, thank you for your assistance.

Regards,

Tom.