VBA Macro: Auto CSV Upload

I need a VBA macro that pulls inventory data from my Excel workbook, generates a clean CSV, and then saves that file in both my OneDrive and the connected SharePoint library—no manual steps involved.

Scope
•
 Build or adapt VBA code inside the existing workbook.
•
 On run, the macro should:
– collect the latest inventory data (currently held on one sheet),
– create a CSV with the correct field order and UTF-8 encoding,
– push the file to my personal OneDrive folder and simultaneously to the mapped SharePoint document library, overwriting the previous version if it exists.
•
 Return the finished macro inside the workbook plus a short, step-by-step guide so I can adjust paths or sheet names later.

Tech notes
You’re free to leverage standard VBA, Power Query helpers, or the Microsoft Graph / SharePoint REST calls—whichever keeps the solution lightweight and reliable within Excel for Microsoft 365.

To be considered
Send a concise proposal outlining how you’ll handle the OneDrive + SharePoint write-back, any previous VBA automations you’ve done, and your estimated turnaround time. A small annotated code snippet that shows you understand the upload step will stand out.