Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
export file to excel
hi, How do I export a range of data from one excel file, to a new exce file with a specific file name? is it possible? or I can only expor data to a text file? pls let me know. Thanks. -- owl52 ----------------------------------------------------------------------- owl527's Profile: http://www.excelforum.com/member.php...fo&userid=2091 View this thread: http://www.excelforum.com/showthread.php?threadid=55257 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
export file to excel
Hi, Owl,
Could you use the following: Sub SaveSheetToNewWorkbook() ThisWorkbook.Worksheets(1).Copy 'copies it to a new workbook 'the new workbook is now active ActiveWorkbook.SaveAs "Saved Copy" End Sub This will save worksheet(1) to a new workbook called "Saved Copy".xls Hope this helps Pete "owl527" wrote: hi, How do I export a range of data from one excel file, to a new excel file with a specific file name? is it possible? or I can only export data to a text file? pls let me know. Thanks. ' -- owl527 ------------------------------------------------------------------------ owl527's Profile: http://www.excelforum.com/member.php...o&userid=20916 View this thread: http://www.excelforum.com/showthread...hreadid=552575 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
export re-order input fields to export file [csv] | Excel Worksheet Functions | |||
Export excel file to txt | Excel Discussion (Misc queries) | |||
Can I export an excel spreadsheet to a .csv file? | Excel Discussion (Misc queries) | |||
Export excel file to semicolon delimited text file | Excel Discussion (Misc queries) | |||
Excel should export its file as exe | Excel Programming |