Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
copy to a sheet
hello everybody.
I have this workbook I do insert data in. At the end of the work I need some of the data to be copied into a different workbook which I have on my desktop. Is it possible to automate this? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
copy to a sheet
This website might be useful http://www.rondebruin.nl/ado.htm VBA Noo -- VBA Noo ----------------------------------------------------------------------- VBA Noob's Profile: http://www.excelforum.com/member.php...fo&userid=3383 View this thread: http://www.excelforum.com/showthread.php?threadid=56172 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
copy to a sheet
Hi Antonov,
Turn on the macro recorder and perform the necessary operations manually. This will provide you with code which may be edited to afford more generic application. If you experience problems in editing the recorder code, post back with the problematic code. --- Regards, Norman "antonov" wrote in message .. . hello everybody. I have this workbook I do insert data in. At the end of the work I need some of the data to be copied into a different workbook which I have on my desktop. Is it possible to automate this? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
copy to a sheet
If you want to use a database workbook to copy below your existing data see
http://www.rondebruin.nl/copy1.htm -- Regards Ron de Bruin http://www.rondebruin.nl "Norman Jones" wrote in message ... Hi Antonov, Turn on the macro recorder and perform the necessary operations manually. This will provide you with code which may be edited to afford more generic application. If you experience problems in editing the recorder code, post back with the problematic code. --- Regards, Norman "antonov" wrote in message .. . hello everybody. I have this workbook I do insert data in. At the end of the work I need some of the data to be copied into a different workbook which I have on my desktop. Is it possible to automate this? |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
copy to a sheet
Hi VBA Noob
This example only get data from a workbook -- Regards Ron de Bruin http://www.rondebruin.nl "VBA Noob" wrote in message ... This website might be useful http://www.rondebruin.nl/ado.htm VBA Noob -- VBA Noob ------------------------------------------------------------------------ VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833 View this thread: http://www.excelforum.com/showthread...hreadid=561727 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copy rows from one Data sheet to another sheet based on cell conte | Excel Discussion (Misc queries) | |||
Auto Copy/autofill Text from sheet to sheet if meets criteria | Excel Discussion (Misc queries) | |||
How can i copy data from a tabbed working sheet to a summary sheet | Excel Discussion (Misc queries) | |||
relative sheet references ala sheet(-1)!B11 so I can copy a sheet. | Excel Discussion (Misc queries) | |||
providing a sheet-copy event or copy CustomProperties | Excel Programming |