| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copying text file into worksheet
Hi,
I'm trying to write a macro that copies the data from one excel file from a different workbook into another one, can anybody help Thank You |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Copying text file into worksheet
Turn on the macro recorder and do it manually.
If you want to copy an entire sheet, do that, via Edit/Move or Copy Sheet. OTOH, if you only want to copy cell contents, do that: select the cells, Copy, switch to the other book and paste. Turn off the recorder and, if necessary, modify the code that was generated to make it more general. Post back if you have problems with the latter. On Sun, 10 Oct 2004 17:57:12 -0700, wrote: Hi, I'm trying to write a macro that copies the data from one excel file from a different workbook into another one, can anybody help Thank You |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copying worksheet, path/file access error: '\vbxxx.tmp' | Excel Discussion (Misc queries) | |||
| EXCEL Worksheet to text file!!!!!!!!!! | Excel Discussion (Misc queries) | |||
| Copying certain lines from a text file | Excel Discussion (Misc queries) | |||
| Copying Text to another cell/worksheet | Excel Worksheet Functions | |||
| Imported Text File Worksheet Tab Name | Excel Programming | |||
Linear Mode
