Is there a way to run an Excel macro abc.xls on a
spreedsheet xyz.xls in an ActiveX script

Quite a few previous posts on this topic, for example-

http://tinyurl.com/pg9l

KB that covers this topic-
http://support.microsoft.com/default...b;en-us;177760



--
Darren Green
http://www.sqldts.com

"Billy" <bjrichard21 (AT) hotmail (DOT) com> wrote

Hi Darren
I'm trying to run a macro that's on a spreadsheet by it's
self. One contains the macro the other the table to be
modified. Doesn't it require me to open both?

thanks
billy

In article <159701c3890d$2c0fd0c0$a001280a (AT) phx (DOT) gbl>, Billy
<bjrichard21 (AT) hotmail (DOT) com> writes
Quite probably. Sorry but Excel automation is not a strong point of
mine. You might want to ask this in an Excel group as DTS is not the
issue here, you are just writing script.

Sorry.

--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org