$$Excel-Macros$$ Re: Export selected worksheets into new workbook from list box

hi all, i want to learn VBA & Macros, can anybody send example excel file and macro file, kindly do the need ful thanks & Regards, kumar On Thu, May 14, 2009 at 10:01 PM, Steve wrote: > > I have a UserForm with a multi-selection ListBox (ListBox1) that is > populated with all the worksheet na

$$Excel-Macros$$ What can I do rather than repeating the same procedure over and over again?

Hello Everyone, I am very new in programing. As seen below I open 2 files and retrieve specific cells from these files into my database. Rather then repeating the whole procedure for each sheet, how is a shorter way doing this? I thank you in advance for your help Regards Ahmet Sub Main

$$Excel-Macros$$ Check date if exist break hyperlink

Hello Everyone, I am very new in macro programming and would appreciate any help I can get. I have a workbook with two sheets. The first sheet has mm/ labeled hyperlinks eg 03/2008, 04/2008.. 04/2009. When I press on the hyperlink the macro which I have writtien in a very primitive

$$Excel-Macros$$ Re: passwordupprotect file

Dear Tareq Which are the programs you use to crack the 1. Excel file password 2. vba password Thanks Yahya On Mon, May 18, 2009 at 4:52 PM, tariq wrote: > > hello mahesh, > > this file password is : AABBBAABBAAP > > AND ANY PASSWARD CRACKING SO MAIL ME ... > > my e_mail : tariq.78.

$$Excel-Macros$$ passwordupprotect file

hello mahesh, this file password is : AABBBAABBAAP AND ANY PASSWARD CRACKING SO MAIL ME ... my e_mail : tariq.78...@gmail.com & contect no. : 09893729520 tariq khan +91 9893729520 --~--~-~--~~~---~--~~ --

$$Excel-Macros$$ Re: Custom function for cell color

Thanks Rakesh!!! Good job..!! Regards, dilipandey -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On Sun, May 17, 2009 at 7:40 AM, Rakesh Sharma wrote: > > Hi > > you can follow this link below. i have used a c

$$Excel-Macros$$ Re: Copy, past and move down one cell VBA/Macro

Thanks a lot buddy..works perfect..great work On May 18, 6:23 am, Dilip Pandey wrote: > 'Hi TAIgo, > > 'Use following code:- > > Sub TAIgo() > Range("a1").Copy > Range("b1").Select > If Selection.Value = "" Then > ActiveSheet.Paste > Else > Selection.End(xlDown).Select > Selection.End(xlDown).Se

$$Excel-Macros$$ Run Macro Automatically

Hello, I need help in 2 macros. Any suggestions will be greatly appreciated. thanks in advance. 1) Is it possible to run a macro automatically if certain cell value changes? e.g Cell A1 has a value which comes from a formula and 1) Can I schedule a fixed time to run a macro but only on weekda

$$Excel-Macros$$ Re: put settlement data in new cell

*Hi TAIgo,* Solution is attached. Thanks. -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On Sat, May 16, 2009 at 11:25 PM, TAlgo wrote: > > All, > > I've just started learning vba with few books but need a

$$Excel-Macros$$ Re: formula in macros

*Hi Habeeb,* To get the flexibility, use the following formula:- =SUMPRODUCT((A3:A65536="Sub Total")*(B3:B65536)) Thanks & Regards, Dilipandey On Fri, May 15, 2009 at 10:04 AM, Habeeb Mohammed wrote: > Hi Guys, > > I currently written a code were in total will be populated by adding > various su

$$Excel-Macros$$ Re: Copy, past and move down one cell VBA/Macro

'Hi TAIgo, 'Use following code:- Sub TAIgo() Range("a1").Copy Range("b1").Select If Selection.Value = "" Then ActiveSheet.Paste Else Selection.End(xlDown).Select Selection.End(xlDown).Select Selection.End(xlUp).Select ActiveCell.Offset(1, 0).Select ActiveSheet.Paste End If End Sub 'Thanks & Regar