Copying text file into worksheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Copying cells and formula from closed workbook to all sheets in open workbook 0
Excel Move or Copy Stopped Working? 0
copy and paste data only to a new file 1
Worksheet copying in Excel 2007 3
How to append data from different sheet and different workbook? 2
COPY MODULE MACRO WITH WORKSHEET TO OTHER WORKBOOKS 2
Copying Text from a file into Excel w/ Macro 6

Back
Top