Submit My Question - Recent Questions - Recent Answer
Msdn Tech >> Visual Studio Tools for Office >> Visual Studio Tools for Office

create a new worksheet in a excel file using VBA

I have a button on the sheet1 of the excel file and when i click on the button, i want it to help me create a new excel worksheet and put it at the last sheet and name the sheet base on date by the format "YYYY/MM/DD" can anyone teach me how to do this. Thanks
[278 byte] By [dnzone] at [2007-12-24]
«« Cannot use anonymous methods inside SQLCLR...
»» Error In Action Pane Add In's
# 1

Hi :-)

This forum is dedicated to the VSTO technology: a way to substitute .NET code for VBA in Word and Excel.

In order to get help with VBA questions for Excel, you need to ask in the excel.programming newsgroup which you'll find here:

http://msdn.microsoft.com/newsgroups/default.aspx?dg=microsoft.public.excel.programming&lang=en&cr=US

Enjoy !

CindyMeister at 2007-10-8 > top of Msdn Tech,Visual Studio Tools for Office,Visual Studio Tools for Office...
Visual Studio Tools for Office

Visual Studio Tools for Office Hot Topic

Visual Studio Tools for Office New Topic

Visual Studio Tools for Office

Java / MSDN / Linux Tech / PHP Tech / MSDN DotNet / MSDN TECH / Health Library / Programmers Tech / visual basic Tech / Developer Tech / Ipod faqs / Msdn China Tech

Site Classified