-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
move text file into workbook
- Thread starter jdoiron
- Start date
Andrew Poulsom
MrExcel MVP
- Joined
- Jul 21, 2002
- Messages
- 73,092
Right click the sheet tab and choose Move or Copy. In the To Book dropdown choose the name of the workbook to which you want to move the sheet (it must be open) and click OK. Your text file will disappear as a Window and appear as a new sheet in the target workbook.
Upvote
0
Hi,
I am not sure I understand why you cannot move it and copy it to another workbook.
Is there a sheet of this name already in the destination workbook? Do you want to paste to a new sheet, or rewrite over the existing data.
If you want to rewrite over the current sheet you could do something like this:
'this is the sheet you want to copy
Workbooks("Book1").Sheets("Sheet1").Select
Cells.Select
Selection.Copy
'this is the workbook you want to copy too
Workbooks("Book2").Activate
'this is the sheet you want to copy to
Workbooks("Book2").Sheets("Sheet1").Select
Range("A1").PasteSpecial xlPasteAll
Hope this helps. If it doesn't try to explain the situation a little more, and we can go from there.
Krupa
I am not sure I understand why you cannot move it and copy it to another workbook.
Is there a sheet of this name already in the destination workbook? Do you want to paste to a new sheet, or rewrite over the existing data.
If you want to rewrite over the current sheet you could do something like this:
'this is the sheet you want to copy
Workbooks("Book1").Sheets("Sheet1").Select
Cells.Select
Selection.Copy
'this is the workbook you want to copy too
Workbooks("Book2").Activate
'this is the sheet you want to copy to
Workbooks("Book2").Sheets("Sheet1").Select
Range("A1").PasteSpecial xlPasteAll
Hope this helps. If it doesn't try to explain the situation a little more, and we can go from there.
Krupa
Upvote
0
