Excel and Copy Sheet

[Aciano]

Hi,

I have a question regarding the Locodarwin' Excel UTF. For my project I need function that copies sheets and I was not able to find anything about such function on the forum. Someone might suggest to use the CopyCell function, but it is not the same (well I have not try it but I doubt it copies formating, borders, etc - if I am wrong please let me now). Let me explain. I have a template Excel file I want to fill with data. If there is too much data I need to create new template sheet (zes, on new sheet, not below, under or elsewhere) to continue adding the date. Are you with me? Since the template cannot be changed and is complex (too many cells merged and formated). And suggestions how to do that? And suggestion is highly appreciated.

AC

[big_daddy]

Here's the Sheets.Copy Method. You may also be able to use the Sheets.FillAcrossSheets Method.

Here is a good reference point.

Excel Object Model Reference

[randallc]

Hi

You can look at

_XLGetSheetName

_XLNameSheet

_XLNewSheetName

_XLSheetAdd

_XLSheetProperties

_XLSheetProps

in ExcelCom from link in my sig too..

Best, randall

Edited December 28, 2007 by randallc

[Aciano]

Thank you for all the references and give it a try. I appreciate it.