Basically you are asking how to use automation to automate Excel. Here are
several examples:

http://support.microsoft.com/search/...false&numDays=

The above should all be on one line in your browse.

For specific code to use in Excel, all you need to do is turn on the macro
recorder and perform those actions manually. Turn off the macro recorder,
then view the code recorded. Then you can adapt that code to an automation
scenario as shown above.

--
Regards,
Tom Ogilvy



"zac" wrote in message
...
Hello,
I have a spreadsheet (XP) with links to query's in Access
XP and SQL 2000 that needs to be opened and refreshed
(Refresh All button is the one that works when done
manually) on all tabs. Would anyone be able to provide
some sample code in VB 6 that would show how to open and
refresh a spreadsheet, then save and close? The first 2
are more important though.

thanks,
Zac

Tom,

As someone who regularly posts links, could I respectfully suggest that you
take a look at www.tinyURL.com, which will do a similar job to condensing
the URLs as Make A Shorter Link, but without the intermediate step via that
site. In addition, you can add a link to your favourites that will generate
a tinyURL from the active web page.

I think you will like it.

Regards

Bob


"Tom Ogilvy" wrote in message
...
Basically you are asking how to use automation to automate Excel. Here
are
several examples:


http://support.microsoft.com/search/...3D1033%26CDID%
3DEN-US-KB%26PRODLISTSRC%3DON&withinResults=&QuerySource=g ASr_Query&Product=
vb6&Queryc=automation+excel&Query=automation+excel &KeywordType=ANY&maxResult
s=25&Titles=false&numDays=

The above should all be on one line in your browse.

For specific code to use in Excel, all you need to do is turn on the macro
recorder and perform those actions manually. Turn off the macro recorder,
then view the code recorded. Then you can adapt that code to an
automation
scenario as shown above.

--
Regards,
Tom Ogilvy



"zac" wrote in message
...
Hello,
I have a spreadsheet (XP) with links to query's in Access
XP and SQL 2000 that needs to be opened and refreshed
(Refresh All button is the one that works when done
manually) on all tabs. Would anyone be able to provide
some sample code in VB 6 that would show how to open and
refresh a spreadsheet, then save and close? The first 2
are more important though.

thanks,
Zac