You can put a worksheet in a new workbook by right clicking the tab on the
bottom of the worksheet (normally Sheet1) and select move or copy. On the
top pulldown ogf the Pop Up window select New Workbook and check the box to
make a copy. Next go to menu File - Save As and select the type of Workbook
as "CSV" and select the location and name of new workbook.
Thanks Joel, but this did exact opposite of what I wanted. By following what
you have written, it copied existing worksheet into a new csv file. Instead
what I want is to open file2 (a csv file) in file1.xls. File1.xls already
contains a worksheet Sheet1. I want file1.xls to now have another worksheet
titled file2, which contains data of file2.csv file.
Any suggestions?
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.
