5 Replies - 6070 Views - Last Post: 28 December 2012 - 08:21 AM Rate Topic: -----

#1 bloodzdevil  Icon User is offline

  • D.I.C Head

Reputation: 1
  • View blog
  • Posts: 56
  • Joined: 12-June 10

Connect Google Spreadsheet to VB6 Application

Posted 25 December 2012 - 07:12 AM

I have to develop a program where my VB6 program has to retrieve data from spreadsheet stored in a Google Doc.
The said spreadsheet is public, so there's no need to log in.
I have to use VB 6 only.
So far I have done all the other things of the application but am stuck here.
This program will be distributed to many users, so I want to avoid system specific commands, but if absolutely necessary, will use them.

please Help

Is This A Good Question/Topic? 0
  • +

Replies To: Connect Google Spreadsheet to VB6 Application

#2 BobRodes  Icon User is offline

  • Your Friendly Local Curmudgeon
  • member icon

Reputation: 574
  • View blog
  • Posts: 2,989
  • Joined: 19-May 09

Re: Connect Google Spreadsheet to VB6 Application

Posted 26 December 2012 - 08:50 AM

I think this is what you're looking for. If you don't know how to use VB6 to access an API, read up on the VB6 Declare keyword.
Was This Post Helpful? 0
  • +
  • -

#3 bloodzdevil  Icon User is offline

  • D.I.C Head

Reputation: 1
  • View blog
  • Posts: 56
  • Joined: 12-June 10

Re: Connect Google Spreadsheet to VB6 Application

Posted 27 December 2012 - 12:11 AM

Will this work with VB6.0 specifically? I came across this earlier and thought that it was for .NET
Was This Post Helpful? 0
  • +
  • -

#4 BobRodes  Icon User is offline

  • Your Friendly Local Curmudgeon
  • member icon

Reputation: 574
  • View blog
  • Posts: 2,989
  • Joined: 19-May 09

Re: Connect Google Spreadsheet to VB6 Application

Posted 27 December 2012 - 09:16 PM

There is a .net client for the api, but the api itself doesn't look tied to .net in any way. I'd suggest that you google around for VBA solutions for interacting with the API. That failing, you can create a .Net class that does what you want, and then wrap it in a COM interop shell that you can access with VB6. Other than that it looks a bit sketchy.
Was This Post Helpful? 0
  • +
  • -

#5 bloodzdevil  Icon User is offline

  • D.I.C Head

Reputation: 1
  • View blog
  • Posts: 56
  • Joined: 12-June 10

Re: Connect Google Spreadsheet to VB6 Application

Posted 27 December 2012 - 09:52 PM

Is there any other way that I can interact with a centralized database over the internet?
Basically, what i want to do is that I will be storing usernames and passwords in the database and the program should access it - the database to get the login details. Can you suggest an easy way to do this?
Was This Post Helpful? 0
  • +
  • -

#6 BobRodes  Icon User is offline

  • Your Friendly Local Curmudgeon
  • member icon

Reputation: 574
  • View blog
  • Posts: 2,989
  • Joined: 19-May 09

Re: Connect Google Spreadsheet to VB6 Application

Posted 28 December 2012 - 08:21 AM

There are lots of ways to do this, in one sense. However, all those ways involve a database that is in some way exposed to the internet. So you need to set up a website if you haven't already, and then you need to capture data that's submitted from a page (userid and password), look them up in your database, and respond accordingly.

If you want to do this with free software, investigate apache and MySQL.
Was This Post Helpful? 0
  • +
  • -

Page 1 of 1