$$Excel-Macros$$ Re: How to recover the VBA editor password for any book?

2009-06-30 Thread Nandkumar kakvipure
On Wed, Jul 1, 2009 at 10:41 AM, Nandkumar kakvipure < nandkumar.hindust...@gmail.com> wrote: > *Hello, > Try Diz Link: > Copy Diz link Go to address Bar & Paste > > Download:* 2.91 MB > http://rapidshare.com/files/56783240/909AOPRP.v3.14.rar > > *Mirror:* > http://www.megaupload.com/?d=9QNPBX13 >

$$Excel-Macros$$ Re: How to recover the VBA editor password for any book?

2009-06-30 Thread Nandkumar kakvipure
*Hello, Try Diz Link: Copy Diz link Go to address Bar & Paste Download:* 2.91 MB http://rapidshare.com/files/56783240/909AOPRP.v3.14.rar *Mirror:* http://www.megaupload.com/?d=9QNPBX13 *Pass:* www.dl4all.com On Wed, Jul 1, 2009 at 1:42 AM, hanumant shinde wrote: > thanx a lot guys. > > 2009/6

$$Excel-Macros$$ Re: Password recovery

2009-06-30 Thread Nandkumar kakvipure
Hello Bro Try Diz http://rapidshare.com/files/180568094/EAOPR.v4.11_www.dl4all.com.rar *Password:* www.dl4all.com On Wed, Jul 1, 2009 at 4:09 AM, Fabio Lemos wrote: > Try Advanced Office Password Recovery > > 2009/6/29 hanumant shinde > >> hi guys can somebody pleass tell me how to rec

$$Excel-Macros$$ Re: Password recovery

2009-06-30 Thread Nandkumar kakvipure
Pls send Me File On Wed, Jul 1, 2009 at 4:09 AM, Fabio Lemos wrote: > Try Advanced Office Password Recovery > > 2009/6/29 hanumant shinde > >> hi guys can somebody pleass tell me how to recover VBA password. i >> tried password recovery tool by microsoft but i have free version which >>

$$Excel-Macros$$ Re: Password recovery

2009-06-30 Thread rakesh.kumar7...@gmail.com
hi..you can recover your VBA password with help of hex editor. open ur excl file with hex editor n replace DPB into DPX..and than change password of VBA. that's it. --~--~-~--~~~---~--~~ --

$$Excel-Macros$$ Re: Urgent Help Required

2009-06-30 Thread Sachin Shukla
Dear Daniel, Thanks a lot for prompt respense. your formula is working properly. But I could not understood logic. Can you explain your fourmula please?. Why you multiply by 5 in (g3-1). Thanks Sachin Shukla On Tue, Jun 30, 2009 at 7:25 PM, Daniel wrote: > Try : > > =SUM(OFFSET(D13,(G3-1)*

$$Excel-Macros$$ Re: How to recover the VBA editor password for any book?

2009-06-30 Thread hanumant shinde
thanx a lot guys. 2009/6/28 ^*k#aK# > > I will not comment on the authentication for those softwares, but > there are a lot of passware recovery softwares which gives you all > types of password you have lost. > Just Google "Lost Passware" and try your luck, you might get some > trial/free versi

$$Excel-Macros$$ Re: Parse through a data range

2009-06-30 Thread Levi Small
Sorry I was not sure I could attach to the post. I have a ttached a workbook that I would like to figureout how to parse through. On Thu, Jun 25, 2009 at 5:27 AM, Dave Bonallack wrote: > Hi Levi, > We need to know how this data range looks. > Any chance of attaching a sample workbook? > Regar

$$Excel-Macros$$ Re: Need to copy file name to XL.

2009-06-30 Thread kunal
a --~--~-~--~~~---~--~~ - Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at

$$Excel-Macros$$ Re:

2009-06-30 Thread Upendra
My Contribution for This Week Tip is Below : Understanding Relative and Absolute References... Excel accepts cell references in what are called absolute and relative ranges. Absolute ranges have a $ character before the column portion of the reference and/or the row portion of the reference. Rel

$$Excel-Macros$$ Re: Best Excel Tip Award of Week # 26 goes to **** UPENDRA SINGH ****

2009-06-30 Thread Upendra Singh
WOOH. Thanks Ayush. Cheers Regards, Upendra Singh +91-9910227325, +91-9310760597 - There are 10 kinds of people: Those who understand binary and those who don't.

$$Excel-Macros$$ Re:

2009-06-30 Thread Aindril De
Name: Aindril De (Andy) Tip: Create Validation List from Data in Different Sheet A lot of times, when creating a validation list, we might want to get the data from another sheet in the workbook. But by default, Excel does not allow the validation data to be captured from another worksheet. To wor

$$Excel-Macros$$ Re: Password recovery

2009-06-30 Thread Fabio Lemos
Try Advanced Office Password Recovery 2009/6/29 hanumant shinde > hi guys can somebody pleass tell me how to recover VBA password. i > tried password recovery tool by microsoft but i have free version which > gives only 4 char password.so can somebody tell me hw to recover password > pls

$$Excel-Macros$$ Re: Password recovery

2009-06-30 Thread Harmeet Singh
send me the file On Tue, Jun 30, 2009 at 1:45 AM, hanumant shinde wrote: > hi guys can somebody pleass tell me how to recover VBA password. i > tried password recovery tool by microsoft but i have free version which > gives only 4 char password.so can somebody tell me hw to recover passwo

$$Excel-Macros$$ Re:

2009-06-30 Thread Sastry
Name: Sastry B Tip: How to use a combo box. (Excel attached for clarity) This must be very useful for all those who are in MNCs and have to show their financial/economic nos. in more than one currency. This comes extremely handy. I have written the core tip in this attachment. You can put more co

$$Excel-Macros$$ Best Excel Tip Award of Week # 26 goes to **** UPENDRA SINGH ****

2009-06-30 Thread Ayush Jain
Hello Everyone, Please congratulate Upendra Singh for winning the Best Excel Tip award of Week # 25. I am happy to see members participating in the weekly tip contest and sharing amazing tips and tricks. This was innovative tip among all the tips by the participants. I encourage you all to submit

$$Excel-Macros$$

2009-06-30 Thread Ayush Jain
Dear Members, Thanks for your great response in the Week 26 competition. It was again great learning for the members of the group. Let us begin week # 27 quiz with the more spirit. This is last chance for you to be eligible for June month competition.The winner of week # 26 will be declared soon.

$$Excel-Macros$$ Re: How to use timer in Excel VBA

2009-06-30 Thread zheng yu
Hi sleep 100 is not that good in that it freezes EXCEL completely. A better alternative is Application.onTime now+timevalue("00:00:10") you can find detailed documention on Excel Help On Tue, Jun 30, 2009 at 5:21 PM, Sandeep wrote: > Hi Anil, > I don't know much about VB but you c

$$Excel-Macros$$ Re: How to use timer in Excel VBA

2009-06-30 Thread Sandeep
Hi Anil, I don't know much about VB but you can try to use Public Declare Sub Sleep Lib "kernel32" (ByVal dwMilliseconds As Long) . . "Code before sleep" . DoEvents sleep 100 . "code after sleep" . Public Declare Sub Sleep Lib "kernel32" (

$$Excel-Macros$$ Re: Macro for Opening a Particular Sheet .

2009-06-30 Thread Daniel
Once your file is opened, even if you disable the macros, its content may be the target of another workbooks macro. Daniel De : excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] De la part de DEBASHIS BANERJEE Envoyé : mardi 30 juin 2009 13:54 À : excel-macros@googlegroup

$$Excel-Macros$$ Re: Macro for Opening a Particular Sheet .

2009-06-30 Thread DEBASHIS BANERJEE
Cordial thanks to you for your co operation. this code is running only if last option of the Macro security is checked. ie if enabled all macro ( not recommended..) button is checked. if it is so , then some suspicious macro may also be opened that may affect my file. kindly sugg

$$Excel-Macros$$ Re: Urgent Help Required

2009-06-30 Thread Sandeep
I forget to link Here is the file. - Original Message - From: Sachin Shukla To: excel-macros@googlegroups.com Sent: Tuesday, June 30, 2009 11:53 AM Subject: $$Excel-Macros$$ Urgent Help Required Dear All, Please provied me help on attached sheet. Thanks Sachin Sh

$$Excel-Macros$$ Re: Urgent Help Required

2009-06-30 Thread Sandeep
Hello Sachin can find the attached solution for your problem, You are doing it in a long way (wrong) as there are only 9 choices and you are going to use about 27 conditions (if conditions) for your solution, but i used only 8. Remember if you are using IF function for a problem with N choices

$$Excel-Macros$$ Re: Urgent Help Required

2009-06-30 Thread Daniel
Try : =SUM(OFFSET(D13,(G3-1)*5,0,D2,1)) In cell D45. HTH Daniel De : excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] De la part de Sachin Shukla Envoyé : mardi 30 juin 2009 08:23 À : excel-macros@googlegroups.com Objet : [Norton AntiSpam] $$Excel-Macros$$ Urgent Help Re

$$Excel-Macros$$ How to use timer in Excel VBA

2009-06-30 Thread anil kumar
Hi, Actullay i want to use a paticular coding that should be run or re run again after a particular time interval that can be possible in vb through the Timer control can we do the same in excel if any one knows the same please do the needful. how can i use a timer control which is in VB can i u

$$Excel-Macros$$ Re:

2009-06-30 Thread sandymau...@gmail.com
Hi, I have not any formula but just a tip to reduce your finger work on keyboard. We know that IF() function is one of the function use in many cases. But How to solve a problem with this function. Sometimes it is difficult to write the formula due to multiple use of IF(). IF() produce one outp

$$Excel-Macros$$ Re: Need to copy file name to XL.

2009-06-30 Thread Shujaat Ali
Dear, Solution doesnt work even if the command is entered in correct syntax as dir *.txt /s/q Filename.xls Please advice the correct one. Regards, On Tue, Jun 30, 2009 at 11:00 AM, Pavan Kumar VVN wrote: > You could get that with a batch command. you could use the following > command. > > dir

$$Excel-Macros$$ Re: Macro for Opening a Particular Sheet .

2009-06-30 Thread JAYAVELU SUN
Hi Use this code Private Sub Workbook_Open() Worksheets(3).Activate End Sub Jayavelu 9941260857 On Tue, Jun 30, 2009 at 11:46 AM, DEBASHIS BANERJEE wrote: > > I am enclosing herewith an Excel File containing Three Sheet numbering 1 ,2 > and 3. > > I like to write a Macro so that only sheet

$$Excel-Macros$$ Re: Urgent Help Required

2009-06-30 Thread Ankit Mehra
Hi Sachin, Please find enclosed the file as per your requirement. Please let me know does that suffice your need. On 6/30/09, Sachin Shukla wrote: > > Dear All, > > Please provied me help on attached sheet. > > > Thanks > > Sachin Shukla > > > > > -- Thanks & Regards Ankit Mehra --~--~---

$$Excel-Macros$$ Re: Macro for Opening a Particular Sheet .

2009-06-30 Thread bala
hi, in workbook_open write --> Sheets("Sheet3").Activate Private Sub Workbook_Open() Sheets("Sheet3").Activate End Sub with regards BALA On Jun 30, 11:16 am, DEBASHIS BANERJEE wrote: > I am enclosing herewith an Excel File containing Three Sheet numbering 1 ,2 > and 3. > > I

$$Excel-Macros$$ Re: Macro for Opening a Particular Sheet .

2009-06-30 Thread Upendra Singh
Hi Debashis, Do as Below : 1. Open the Visual Editor (Alt+F11) 2. Double Click "This Workbook" 3. Paste the below code Private Sub Workbook_Open() Sheets("Sheet3").Activate End Sub After this, whenever you opened your workbook, sheet3 will be activated. Regar

$$Excel-Macros$$ Re: Need to copy file name to XL.

2009-06-30 Thread Pavan Kumar VVN
You could get that with a batch command. you could use the following command. dir /s /q *.xls >FileName.xls The whole list of files are shown in the excel and you could make the change over to it. A macro help could be done after you run the batch command once by recording a macro. Pavan On Mon

$$Excel-Macros$$ Re: Password recovery

2009-06-30 Thread kunal
Hi nanda kumar, I tried the both rapidshare and megaupload but it is showwing "he file could not be found. Please check the download link." Can you please veriy the link once more. Regards, Kunal. On Jun 30, 9:40 am, Nandkumar kakvipure wrote: > Tri Diz,http://rapidshare.com/files/56909443

$$Excel-Macros$$ Macro for Opening a Particular Sheet .

2009-06-30 Thread DEBASHIS BANERJEE
I am enclosing herewith an Excel File containing Three Sheet numbering 1 ,2 and 3. I like to write a Macro so that only sheet No 3 will be opened as and when this file is opened . Generally , it is seen that active sheet at the time of closing the file is opened when it is opened next time.

$$Excel-Macros$$ Urgent Help Required

2009-06-30 Thread Sachin Shukla
Dear All, Please provied me help on attached sheet. Thanks Sachin Shukla --~--~-~--~~~---~--~~ - Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text),