How to export data to a closed Workbook
 

Hey! I am currently doing a project in which i am reqd to export a rang
of cells from the current worksheet to another Excel worksheet at som
location at the click of a button (using a macro). How do i go abou
it? :confused: . i already got a piece of code which can import dat
from a closed workbook. but i am not able to reverse the process
Anyone with an answer?

--
newbi
-----------------------------------------------------------------------
newbie's Profile: http://www.excelforum.com/member.php...fo&userid=2538
View this thread: http://www.excelforum.com/showthread.php?threadid=38859

How to export data to a closed Workbook
 

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? :confused: . 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