Try Worksheet.Move() function.It preserves all format and styles with position.
Don't call WorkBook.Save() or Workbook.Close() after calling Move() function for the source workbook because it automatically closes the source workbook without any changes.
Thanks,
Manish
Please 'Mark As Answer', if one or multiple posts helped you in your problem so that it might be useful for others.
singhmanish_...
Participant
894 Points
167 Posts
Re: How to merge sheets from multiple excel files into one .xls file?
Nov 14, 2009 06:03 AM|LINK
Try Worksheet.Move() function.It preserves all format and styles with position.
Don't call WorkBook.Save() or Workbook.Close() after calling Move() function for the source workbook because it automatically closes the source workbook without any changes.
Manish
Please 'Mark As Answer', if one or multiple posts helped you in your problem so that it might be useful for others.