VBA excel paste to web html

Factual Questions
1

Dear all,

I am new here and as much as I could I searched for my answer but never got the one I wanted.

I want to create a VBA to be able to past a specific column from a specific worksheet from an Excel file to a web page and then “click” a button to generate the outcome.

I have created this so far:

Sub papafi_1_command()

ThisWorkbook.Activate
Sheets(“RPInputs”).Select

Sheets(“RPInputs”).Range(“C7:C10005”).Select
Selection.Copy
Sheets(“Sheet2”).Select
Range(“L7”).Select
ActiveSheet.Paste

Workbooks.Open (“C:\Users\FilipposP\Downloads\deprivation-by-postcode (6)”)
Sheets(“Sheet1”).Select

Sheets(“Sheet1”).Range(“A1:AB9999”).Select
Selection.Copy

ThisWorkbook.Activate
Sheets(“Sheet1”).Select
Sheets(“Sheet1”).Range(“A1:AB9999”).Select
Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:= _
False, Transpose:=False

End Sub

With which I am able to copy paste from a different excel file to my working one and then copy a column from this new data to another sheet.

What I would like is to be able to instead copy the latest to another spreadsheet go online at:

and paste there the column, and then click the button to generate outcome…

Thanks for the help. Any clarification questions please ask!

2

The question isn’t really the VBA, it’s how to connect to the service that will be hosting this web page or spreadsheet. Your first step is to look at the APIs and maybe search/post on a forum that is specific to that hosting platform. Note that depending on how that platform works, accessing it directly from Excel VBA might not be possible.

I found this link to the APIs and developer documentation on the link you provided. Start there, and good luck.