Before starting to Program your own code with ADO..
check out Excel's QueryTables.

Data/Import External Data/New DB Query.

(and it helps to ensure that MSQuery is installed)
it's optional in Office Setup.)


keepITcool

< email : keepitcool chello nl (with @ and .)
< homepage: http://members.chello.nl/keepitcool


"Vinicio Ascone" wrote:

Hi all!

I've got an Access macro and i need to change it to Excel. :(

Is there any way i could connect to SqlServer database and use
openrecordsets and stuff like that?

Please, any help is welcome!

Vinicio