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 |
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 |
All times are GMT +1. The time now is 12:05 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com