Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Excel VBA > Excel VBA
|
Excel VBA Discuss using VBA for Excel programming.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Excel VBA section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old June 28th, 2006, 06:05 AM
Registered User
 
Join Date: Jun 2006
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default Copying Xl sheet from one Xl file to another

Hi all,
       I need one urgent help in Vb.net code. I have two Xl files with many sheets. I wants to copy all the Execel sheets from One Excel file to another. If the same Excel sheets are found in the Destiantion Execl file .It needs to to deleted first.and then copy.

         Please Anyone Reply me ASAP.......

Thanks ,
Kesavan.
 
Old July 3rd, 2006, 10:11 PM
Friend of Wrox
 
Join Date: Sep 2005
Posts: 812
Thanks: 1
Thanked 53 Times in 49 Posts
Default

If you can use the Excel Object

Use something like this

Sheets("Sheet1").Copy Before:=Workbooks("Input.xls").Sheets(1)

Nothing 'Works' like Excel





Similar Threads
Thread Thread Starter Forum Replies Last Post
Help In using XL wunnavabk VB.NET 2002/2003 Basics 17 May 11th, 2007 08:29 AM
need of jar file(for XL operation) sam123 J2EE 0 February 7th, 2007 11:13 PM
XL VBA Compile - what occurs - why crash PCWeaver Excel VBA 0 September 13th, 2006 11:13 AM
xl Cell Properties Neal Excel VBA 0 May 16th, 2006 06:19 AM
Getting xl sheet names from asp??? Shibu Classic ASP Databases 2 February 1st, 2005 05:47 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.