[bloodzdevil]

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

[BobRodes]

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.

[bloodzdevil]

Will this work with VB6.0 specifically? I came across this earlier and thought that it was for .NET

[BobRodes]

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.

[bloodzdevil]

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?

[BobRodes]

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.