How to export data to a closed Workbook

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??

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" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>