Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? . 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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? . 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Export cell data to closed workbook | Excel Discussion (Misc queries) | |||
Get Data From Closed Workbook | Excel Worksheet Functions | |||
add data to a closed workbook | Excel Programming | |||
PUT data in closed workbook | Excel Programming | |||
getting data from closed workbook | Excel Programming |