Jump to content
Sign in to follow this  
Aciano

Excel and Copy Sheet

Recommended Posts

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

Share this post


Link to post
Share on other sites
randallc

Hi

You can look at

_XLGetSheetName

_XLNameSheet

_XLNewSheetName

_XLSheetAdd

_XLSheetProperties

_XLSheetProps

in ExcelCom from link in my sig too..

Best, randall

Edited by randallc

Share this post


Link to post
Share on other sites
Aciano

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

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.