Interoperability between access97 and excel 2003

  • Thread starter Thread starter alex.nunley
  • Start date Start date
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
 
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.
 
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.
 
Back
Top