Is there any way of editing a Google Sheet with VBA

I have written VBA code that reads a very complex email from MS Outlook, interprets it to extract over a dozen fields. The code then displays the info on a form giving me the opportunity to check and edit before I press the Go button. The Go button searches for the Key field in an Excel spreadsheet and updates it, or if it can't find it, adds the record to the sheet.

I am then using the Excel spreadsheet as a data source for an Appsheet form that is updated on mobile devices in the field. Unfortunately Excel is proving very unstable so I should use a Google Sheet instead which will make it very robust.

My problem is that, although I am very confident with VBA, I have zero knowledge of any code that will enable me to manipulate Google Sheets. Is there a way to manipulate Google Sheets with VBA, or is there any other solution that anyone could suggest?
LVL 1
Rob4077Asked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Fabrice LambertFabrice LambertCommented:
Hi,

Well, VBA have no native facilities to interract with Google sheets.
Maybe the following link will provide something usefull:
https://scand.com/products/gspread/
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Rob4077Author Commented:
Thanks Fabrice. I will have a look and hopefully it will provide the functionality I need
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Google

From novice to tech pro — start learning today.