Hi everyone.
I am relatively new to VBA, and while I have found several threads to import entire ranges from a Google sheet to MS Excel, I haven't been able to find this answer.
I want to be able to produce a form in Google sheets, and use it to populate content control in a Word document.
The part I am getting stuck on is how do i import a single cell from a Google Sheet (A1), and use it as a string variable in VBA (for Word).
Thank you very much!
I am relatively new to VBA, and while I have found several threads to import entire ranges from a Google sheet to MS Excel, I haven't been able to find this answer.
I want to be able to produce a form in Google sheets, and use it to populate content control in a Word document.
The part I am getting stuck on is how do i import a single cell from a Google Sheet (A1), and use it as a string variable in VBA (for Word).
Thank you very much!