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 January 21st, 2006, 06:19 AM
Friend of Wrox
 
Join Date: Dec 2005
Posts: 233
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to anukagni Send a message via Yahoo to anukagni
Default Probs while running macro


  Hi guy's iam new to this Excel VBA Community, I use search for the Access issues and now i am have an problem while runing the macro in Excel.I am using an macro which having the foloing property:

 I got two xls working sheet "Macro","Result". The data which is going to sorted ill be pasted in the marco sheet. When macro is runnig first the format and other processs are doned then the old data in the Result sheet is deleted (i.e.) that is the whole sheet is deleted from the Xls file and new sheet is instered and renamed as result by macro. It show error while the new sheet name is deducting different . Iam not intrested in deleting the data in the result Xls worksheet . I want to delete the work sheet itself.

 pls help me in this issue..
 Thanks in advance......:)
Bye


P.A.P.Raguv
 
Old February 1st, 2006, 04:42 AM
Authorized User
 
Join Date: Oct 2004
Posts: 60
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via AIM to shattered Send a message via Yahoo to shattered
Default

Can you post yoru actual macro, it should be faily simple to sort out. I suspect its having a problem knowing which sheet to actually rename once you create a new one but without seeing your code I can only guess.

 
Old February 2nd, 2006, 03:29 AM
Registered User
 
Join Date: Oct 2005
Posts: 9
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via ICQ to ix_ly Send a message via MSN to ix_ly
Default

ni,

i'm lost too. well, mind to post your code?

ix





Similar Threads
Thread Thread Starter Forum Replies Last Post
calling to xlam macro from macro inside xlsb SteveB Excel VBA 0 June 30th, 2008 06:43 PM
stop macro from running on EVERY cell change!! forkliftpete Beginning VB 6 1 October 26th, 2005 07:36 AM
running macro/user form from other excel files kliu9 Excel VBA 2 April 7th, 2005 11:06 AM
Show Sheet after running macro sridevi Excel VBA 2 November 5th, 2004 08:18 AM
Strange error when running macro in multiple files medaugh Excel VBA 0 September 15th, 2003 11:06 AM





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