Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
opening new csv file in existing xls file's worksheet
Hi All,
I want to open up a new csv file in an existing xls file's worksheet. Is there any way to do this? Regards, |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
opening new csv file in existing xls file's worksheet
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. "Shikha" wrote: Hi All, I want to open up a new csv file in an existing xls file's worksheet. Is there any way to do this? Regards, |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
opening new csv file in existing xls file's worksheet
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? "Joel" wrote: 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. "Shikha" wrote: Hi All, I want to open up a new csv file in an existing xls file's worksheet. Is there any way to do this? Regards, |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
opening new csv file in existing xls file's worksheet
Crate new worksheet from menu
Insert Worksheet Use the menu Data - Import External Data - Import Data "Shikha" wrote: 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? "Joel" wrote: 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. "Shikha" wrote: Hi All, I want to open up a new csv file in an existing xls file's worksheet. Is there any way to do this? Regards, |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
opening new csv file in existing xls file's worksheet
Thanks Joel. This worked.
"Joel" wrote: Crate new worksheet from menu Insert Worksheet Use the menu Data - Import External Data - Import Data "Shikha" wrote: 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? "Joel" wrote: 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. "Shikha" wrote: Hi All, I want to open up a new csv file in an existing xls file's worksheet. Is there any way to do this? Regards, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
on opening an existing file I get blank blue screen | Excel Worksheet Functions | |||
Excel 2007 blank when opening existing file | Excel Discussion (Misc queries) | |||
Hyperlinking to another worksheet in existing file | Excel Discussion (Misc queries) | |||
opening an existing file | Excel Discussion (Misc queries) | |||
my file's format changes when i open the file on another computer | Excel Discussion (Misc queries) |