ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Posting Excel spreadsheet to Google Spreadsheet using VBA (https://www.excelbanter.com/excel-discussion-misc-queries/205306-posting-excel-spreadsheet-google-spreadsheet-using-vba.html)

Greg

Posting Excel spreadsheet to Google Spreadsheet using VBA
 
Hello,

I am looking for a way to use Excel, VBA or some sort of Google API
to update a Google spreadsheet. Here is a little more of an
explanation. I have a budget for me and my wife that I would like to
share online for easy reference. A lot of its functionality is via
VBA so I must use Excel, but I would like to post a summary sheet that
both of us can see. I think that Google Spreadsheets would be an
optimal way to do this, but I just don't know how. Any comments/
thoughts/ideas?

Sheeloo[_2_]

Posting Excel spreadsheet to Google Spreadsheet using VBA
 
You can simply upload the workbook with your summary sheet to Google Docs as
an spreadsheet.

"Greg" wrote:

Hello,

I am looking for a way to use Excel, VBA or some sort of Google API
to update a Google spreadsheet. Here is a little more of an
explanation. I have a budget for me and my wife that I would like to
share online for easy reference. A lot of its functionality is via
VBA so I must use Excel, but I would like to post a summary sheet that
both of us can see. I think that Google Spreadsheets would be an
optimal way to do this, but I just don't know how. Any comments/
thoughts/ideas?


Greg

Posting Excel spreadsheet to Google Spreadsheet using VBA
 
Yes, but I want it to be programmatic, meaning that I want to use code
to upload it every time I execute the code.


All times are GMT +1. The time now is 01:18 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com