Macro to upload Excel workbook to OneDrive / SharePoint

[sanket_sk]

Hi All,

Hope all are doing well.

I have excel forms / Sheets with different users/colleagues, they fill in the details and upload the complete file in SharePoint / OneDrive.

I am looking for solution VBA / Macro or any other functionality, once person fill the details and click on upload, the macro should automatically upload the file in SharePoint and confirm back that “File uploaded successfully”

Sharing sample form and OneDrive link for ready reference ..

OneDrive

Sign in to your OneDrive cloud storage and Office Online.

onedrive.live.com

Note:- OneDrive colleagues will have access to OneDrive

Form Input.xlsm
	A	B	C	D	E	F
1
2
3		Parts Orders Data Entry
4
5		Item
6
7		Location
8
9		Qty
10
11		Price
12
13		Total
14
15
16
Input

Cell Formulas
Range	Formula
D11	D11	=IF(D5="","",VLOOKUP(D5,PartLU,2,0))
D13	D13	=IF(D5="","",D9*D11)

Cells with Data Validation
Cell	Allow	Criteria
D7:D8	List	=LocationList
D9	Whole number	between -50000 and 50000
D5	List	=PartList

Form Input.xlsm
	A	B	C	D	E	F	G
1	Entered	Entered By	Part	Location	Qty	Price	Total
2	07-08-2021 11:50:40	Philips	Main Switch Cover	RC2	1	$155.00	$155.00
PartsData

Kindly let me know if it is possible

Thanks,
Sanket