I'm sure that will work, but what if the OP is wanting to automate this
through Windows Scripting or some kind of addin? If that's the case, you
could still use VBScript (or JavaScript for that matter), but you would
have to create the Excel objects and all that, and he/she still hasn't
said how he/she is trying to accomplish this and may not even know how
to use VBA for all we know...
--
gmorris
------------------------------------------------------------------------
gmorris's Profile:
http://www.thecodecage.com/forumz/member.php?userid=245
View this thread:
http://www.thecodecage.com/forumz/sh...ad.php?t=90608