Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Saving worksheet Data only
Hi All. I have created a workbook("one"). When I run it(with auto_open() macro), It generates all the data in its ("Sheet1"). Now I opened another workbook("two"). How can I just copy the data from "Sheet1" of "one" workbook to "Sheet1" of "two" workbook. I tried this way: I have opened "one" workbook already and "Sheet1" is the active sheet. ------------------------------------------------------- ThisWorkbook.Saved = False ThisWorkbook.Worksheets("Sheet1").Copy Workbooks.Open Filename:="C:\two.xls" Workbooks("two.xls").Worksheets(1).Select ActiveSheet.Paste Workbooks("two.xls").Saved = True ThisWorkbook.Close ------------------------- The code is not working. What is the problem? Thanks -- jesmin ------------------------------------------------------------------------ jesmin's Profile: http://www.excelforum.com/member.php...o&userid=29540 View this thread: http://www.excelforum.com/showthread...hreadid=500928 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Saving charts and data from one worksheet to another | Excel Discussion (Misc queries) | |||
Saving file using data from worksheet | Excel Programming | |||
Saving data in a worksheet within a workbook | Excel Discussion (Misc queries) | |||
Saving worksheet as CSV after pulling data from an external data source | Excel Programming | |||
Saving hidden data with a worksheet (preferably without using a hidden sheet) | Excel Programming |