This page might be a help:
http://www.bygsoftware.com/Excel/SQL..._using_sql.htm
Using an UPDATE query in SQL.REQUEST to change values in closed workbooks.
How to COUNT data in an Excel table and in an MsAccess database using
SQL.REQUEST.
--
Andy Wiggins FCCA
www.BygSoftware.com
Excel, Access and VBA Consultancy
-
"newbie" wrote in
message ...
Hey! I am currently doing a project in which i am reqd to export a range
of cells from the current worksheet to another Excel worksheet at some
location at the click of a button (using a macro). How do i go about
it? 
. i already got a piece of code which can import data
from a closed workbook. but i am not able to reverse the process.
Anyone with an answer??
--
newbie
------------------------------------------------------------------------
newbie's Profile:
http://www.excelforum.com/member.php...o&userid=25385
View this thread: http://www.excelforum.com/showthread...hreadid=388598