Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Code to create atbs in excel sheet
My doubt is this. I need to write a program to open an excel sheet and copy 3 excel sheet into single .xls file which should contain 3 excel sheets.How do i proceed? -- deepa prabhakar ------------------------------------------------------------------------ deepa prabhakar's Profile: http://www.excelforum.com/member.php...o&userid=34821 View this thread: http://www.excelforum.com/showthread...hreadid=545774 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Code to create atbs in excel sheet
To create your new workbook with three sheets you can use Sub Test() Workbooks.Add If ActiveWorkbook.Sheets.Count < 3 Then For N = 1 To 3 - ActiveWorkbook.Sheets.Count Sheets.Add Next N ElseIf ActiveWorkbook.Sheets.Count 3 Then Application.DisplayAlerts = False For N = 1 To ActiveWorkbook.Sheets.Count - 3 Sheets(1).Delete Next N Application.DisplayAlerts = True End If End Sub -- mrice Research Scientist with many years of spreadsheet development experience ------------------------------------------------------------------------ mrice's Profile: http://www.excelforum.com/member.php...o&userid=10931 View this thread: http://www.excelforum.com/showthread...hreadid=545774 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I create a link between cells in two separate Excel sheet | Excel Worksheet Functions | |||
using excel how would I create sheet for adding mileage? | Setting up and Configuration of Excel | |||
Macro for changing text to Proper Case | Excel Worksheet Functions | |||
Getting Excel Data from One Sheet to Another.... | Excel Discussion (Misc queries) | |||
Make Change Case in Excel a format rather than formula | Excel Worksheet Functions |