Interoperability between access97 and excel 2003

A

alex.nunley

The job uses an odd mix of resources. Anybody know of interoperability
issues with these? I need to create a script / macro / just getting
started, dont know yet- that allows me to throw the data culled from a
query into excel, so I can chop it up and prettify it.

Any landmines I should avoid? Tips? Suggestions?

Alex
 
D

Douglas J. Steele

Nothing shows as bold in that post, so I have no idea where you're running
into problems.

In general, though, I always try to avoid using Active anything when
automating Excel: you have no way of knowing whether the user will also be
doing something with Excel at the same time.
 
A

alex.nunley

Sorry, I didnt even realize the formatting was lost. Below is the
snippet of the code where things fall apart.

To the notion of using "Active anything when automating Excel", I am
new at this and am just picking apart books and other materials to
find out how to get this done. If you could suggest a different way,
that'd be great because to be honest, this is the most direct way I
have seen.

Anyway, I hate to keep bothering you, but thanks for your help.

Alex

)----snipet----(

' Create recordset.
Set rst = New ADODB.Recordset
rst.Open Source:=conQuery,
ActiveConnection:=CurrentProject.Connection

)---snipet----(

Every time I run it, it says Run-time error '424": Object Required,
and the debugger highlights that rst.open line.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top