<div>
Thanks Fabrice. I will have a look and hopefully it will provide the functionality I need
</div>


Thanks Fabrice. I will have a look and hopefully it will provide the functionality I need

<div>
<div class="content wysiwyg-content">
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. <br />
<br />
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.<br />
<br />
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?
</div>
</div>


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?

Is there any way of editing a Google Sheet with VBA

Google is an American multinational technology company specializing in Internet-related services and products that include online advertising technologies, search, cloud computing, software, and hardware.

Google

Visual Basic for Applications (VBA) enables building user-defined functions (UDFs), automating processes and accessing Windows API and other low-level functionality through dynamic-link libraries (DLLs). VBA is closely related to Visual Basic and uses the Visual Basic Runtime Library, but it can normally only run code within a host application rather than as a standalone program. It can, however, be used to control one application from another via OLE Automation. VBA is built into most Microsoft Office applications.