$$Excel-Macros$$ Re: To Unprotect Sheet

2009-07-30 Thread Abdul Hakim
Hi thanks a lot, Can u plz specify this breaker could work for excel 2007 if the xlsx file is encrypted with a password. Assist plz, Rgds, A Hakim On Jul 28, 6:22 pm, Harmeet Singh wrote: > use this code > > Sub PasswordBreaker() > >   Dim i As Integer, j As Integer, k As Integer >   Dim l A

$$Excel-Macros$$ Re: Password removal Tool !

2009-07-30 Thread सचिन गोरे
Hi Shafique, Where is the program? Regards Sachin On Wed, Jul 29, 2009 at 7:53 PM, Dhananjay Pinjan wrote: > Hi Shafique, > > Where is the program? > > > On 7/28/09, shafiq online wrote: >> >> >> Attached is password removal tool. You can you it by add-in. These is for >> removing password

$$Excel-Macros$$ Please help me to solve this problem

2009-07-30 Thread Swapnil Palande
Hi All, I want to do conditional formatting on selected cells based on values inserted in other cells. I have explained the problem in attached excel. If you still have any query let me know I will try to explain it again. Thanks and Best regards, Swapnil. --~--~-~--~~~

$$Excel-Macros$$ Progress Reporter

2009-07-30 Thread vivek agrawal
Hi ALL Can any body help me create a progress reporter or if someone has it or if someone has build on his and he is willing to share that... then PLEASE do... Your help would be greatly appreciated... thanks a lot.. Regards, Vivek Agrawal Skype ID - vivek.agrawal83 GoogleMoonlight.com

$$Excel-Macros$$ Re: Overflow error in Excel 2007 VBA

2009-07-30 Thread Ajit Navre
I think, it is due to the implicit conversion of constants in expression. In this particular case, both the quantities i.e. 4 and 1 are interpreted as integers. After multiplication, the result actually is 4 which is beyond the max-min limits of an integer - +32767 to -32768. The fix in typ

$$Excel-Macros$$ Re: Overflow error in Excel 2007 VBA

2009-07-30 Thread danielc
Hello. When computing, Excel uses intermediate variables. "1" and "4" being less than 32760 are considered as integers. the internal result variable is also considered as integer, whence error. Regards. Daniel On 30 juil, 08:46, Harmeet Singh wrote: > Couldn't figure out why but workaround i

$$Excel-Macros$$ Re: Overflow error in Excel 2007 VBA

2009-07-30 Thread Serghei Ovanesov
Hi, Try the following instead of your line: c = CLng(4) * CLng(1) You need to convert both or at least one of the integers into longs as VBA treats them as integers by default. Regards. Serghei > Date: Wed, 29 Jul 2009 19:50:06 -0700 > Subject: $$Excel-Macros$$

$$Excel-Macros$$ Re: Progress Reporter

2009-07-30 Thread zheng yu
you mean progress bar? On Thu, Jul 30, 2009 at 10:45 AM, vivek agrawal wrote: > Hi ALL > Can any body help me create a progress reporter or if someone has it > or if someone has build on his and he is willing to share that... then > PLEASE do... Your help would be greatly appreciated...

$$Excel-Macros$$ Re: Overflow error in Excel 2007 VBA

2009-07-30 Thread zheng yu
Super explanation ! On Thu, Jul 30, 2009 at 10:33 AM, Ajit Navre wrote: > I think, it is due to the implicit conversion of constants in expression. > In this particular case, both the quantities i.e. 4 and 1 are > interpreted as integers. After multiplication, the result actually is 4

$$Excel-Macros$$ Re: Progress Reporter

2009-07-30 Thread vivek agrawal
Yes... PROGRESS BAR Thanks and Regards, Vivek Agrawal Skype ID - vivek.agrawal83 GoogleMoonlight.com - Saving energy-Save Earth On Thu, Jul 30, 2009 at 3:26 PM, zheng yu wrote: > you mean progress bar? > > On Thu, Jul 30, 2009 at 10:45 AM, vivek agrawal > wrote: > >> Hi ALL >> Can any bo

$$Excel-Macros$$ Re: To Unprotect Sheet

2009-07-30 Thread Dhananjay Pinjan
Is there anything to crack password for msword or msexcel? Pl. assist me. Thanks & Regards, Dhananjay On 7/28/09, Harmeet Singh wrote: > > use this code > > > > Sub PasswordBreaker() > > > Dim i As Integer, j As Integer, k As Integer > Dim l As Integer, m As Integer, n As Integer > Dim

$$Excel-Macros$$ Re: Open file with name from a column in excel: How in vb?

2009-07-30 Thread Sanjeev Kumar
could you pls share the same with me too. Thanks n Regards Sanjeev Kumar On 7/30/09, Batfacez wrote: > > > Hi, > > Many thanks for producing this code for me. I've had a go but it seems > to call up the files well but it doesn't seem to copy any of the cells > across. Please could you give som

$$Excel-Macros$$ Please Number in to Words

2009-07-30 Thread Alok Nayak
Hi ,Every one Greeting of the Day Pleasen urgently i want Convert Number in to Word in Excel 2007/2003 . if wrote Rs.2023 in cell then I get the same in other cell in to Word . Please sugest which Function i will use , I have been Use BAHTTEXT (number) function but have erorr pleasea s

$$Excel-Macros$$ need some samples of sales analysis!!!! life and death matter :-( !!!!!

2009-07-30 Thread shannu shannu
Hi all,     Need your help urgently, I am new to sales analysis, can someone give me anu sample excel data like gap analysis, wht if analysis etc.     Regards, Shannur --~--~-~--~~~---~--~~ ---

$$Excel-Macros$$ Re: Please help me to solve this problem

2009-07-30 Thread Swapnil Palande
Hi Serghei, Thanks for giving reply. I saw you excel, but it is not solving my problem. I am not able to find macro written in your excel. I want to apply conditional formatting on Major suppliers columns "PP" and "PE" i.e. column M and N Suppose If I insert supplier name in "PP" column (i.e. c

$$Excel-Macros$$ Re: Open file with name from a column in excel: How in vb?

2009-07-30 Thread Daniel
Hi, Data is pasted on < Target > sheet. If you have any trouble, could you attach files to your reply ? Daniel From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of Sanjeev Kumar Sent: jeudi 30 juillet 2009 13:38 To: excel-macros@googlegroups.com Subjec

$$Excel-Macros$$ Template Development

2009-07-30 Thread Abdul Hakim Khan
Dear All, I want to develop an excel template to automate invoicing jobs. The problem is as described. FROM Cell A10 To L10 Data is manually plugged. Based on this data Cell O10 have a formula that automaticall describe the manually entered Cell description. Based on formulae O10 the unit price

$$Excel-Macros$$ Re: Please help me to solve this problem

2009-07-30 Thread Serghei Ovanesov
Hi Swapnil, I have attached a text document with the VBA macro code which addresses your problem. All you need to do is copy+paste the code under Tools>Macro>Visual Basic Editor in Sheet1. I have tested the same here and it seems to do what you need. I am using Excel 2003. Try e

$$Excel-Macros$$ Re: Please Number in to Words

2009-07-30 Thread Dave
Alok: Your answer is in this link: http://excel.tips.net/Pages/T002270_Numbers_Spelled_Out.html On Jul 30, 8:02 am, Alok Nayak wrote: > Hi ,Every one > Greeting of the Day > > Pleasen urgently i want Convert Number in to Word in Excel 2007/2003 . > if  wrote Rs.2023 in cell then I get the same

$$Excel-Macros$$ Re: Open file with name from a column in excel: How in vb?

2009-07-30 Thread Batfacez
Worked it out Daniel's 090729.xls file has a second sheet called target the values are pasted there in sequence. It does work in Excel 2007. Thank you. On 30 July, 12:37, Sanjeev Kumar wrote: > could you pls share the same with me too. > > Thanks n Regards > > Sanjeev Kumar > > On 7/30/09, Batf

$$Excel-Macros$$ Re: Please help me to solve this problem

2009-07-30 Thread Serghei Ovanesov
Hi Swapnil, Furthermore to my previous email you can alternatively import at Tools>Macro>Visual Basic Editor screen the file attached. That also includes solution to your first step which has been omitted in previous version of the code. Regards. Serghei From: oserg...@hot

$$Excel-Macros$$ Re: Template Development

2009-07-30 Thread Norman May
A Hakim, I have an invoice workbook at the website below, it might be helpful. http://sites.google.com/site/normay/excel-files Norman On Thu, Jul 30, 2009 at 10:53 AM, Abdul Hakim Khan wrote: > Dear All, > > I want to develop an excel template to automate invoicing jobs. > > The problem is as

$$Excel-Macros$$ HELP: creating random numbers

2009-07-30 Thread janet dickson
hi I have numbers ranging from 1 to 1 in excel column, how can i make random number after every tenth group (and bold it or color that number)? For example from 1 to 10 i can choose 3 manually, from 11 to 20 i can choose 17, from 21 to 30 i can choose 23...etc. This is boring in a very large n

$$Excel-Macros$$ Auto Filter - Custom Auto Filter

2009-07-30 Thread Johnnyboy5
HI all writing a sheet for people at work who dont know how to use Excel menus etc. Auto Filter already turned on. I need help on how to write a macro to select the Custom Auto filter option in the drop down menu (no 3) in a particular column. (say column A) and to bring up the Custom Auto Fi

$$Excel-Macros$$ Query concerning Option/Radio Buttons and their captions

2009-07-30 Thread Yptrumpet
Hello, everyone. This is my first post. I've looked high and low for an answer to this problem. I'm making a form in Excel to easily input data. I want to operate it with the keyboard as much as possible. There is a section of my form with four radio buttons. I want the captions above the buttons

$$Excel-Macros$$ Re: Hi Frnd Plz Solve This Pro

2009-07-30 Thread Aamir Shahzad
Thanks Dilip Kumar Aamir Shahzad - Original Message - From: Dilip Pandey To: excel-macros@googlegroups.com Sent: Wednesday, July 29, 2009 3:50 PM Subject: $$Excel-Macros$$ Re: Hi Frnd Plz Solve This Pro Hi Aamir, After "O" column, other columns are hidden till the end o

$$Excel-Macros$$ Re: how to fill series

2009-07-30 Thread Aamir Shahzad
Thanks Mukesh, It's really nice. Aamir Shahzad - Original Message - From: mukesh kumar To: excel-macros@googlegroups.com Sent: Wednesday, July 29, 2009 11:35 AM Subject: $$Excel-Macros$$ Re: how to fill series Hi amir shahzad Plz find attached is solution. Regards

$$Excel-Macros$$ Re: how to fill series

2009-07-30 Thread Aamir Shahzad
Thanks a lot Daniel this is also nice solution. Aamir Shahzad - Original Message - From: "Daniel" To: Sent: Wednesday, July 29, 2009 3:27 PM Subject: $$Excel-Macros$$ Re: how to fill series Hello. Have a look at the attached file. Don't know if this addresses your problem, though.

$$Excel-Macros$$ Re: Please Number in to Words

2009-07-30 Thread Radhe Sham L
Hi Alok, This file was provided by one of the masterminds in the group which i have saved and been using This definately solves ur prob the formula to be used is =num2text(Cell Ref) Regards Radhe On Thu, Jul 30, 2009 at 6:32 PM, Alok Nayak wrote: > > Hi ,Every one > Greeting of the Day >

$$Excel-Macros$$ Need Help

2009-07-30 Thread Aamir Shahzad
Dear Members, Can any body remove the attached file's password which will highly appriciated. Regards, Aamir Shahzad --~--~-~--~~~---~--~~ -- Some important links for excel users: 1.

$$Excel-Macros$$ Find a Value From Other Worksheet Without Activating?

2009-07-30 Thread HumanJHawkins
Hi, The following code snippit works fine: Dim iMyValue As Integer Worksheets("Config").Activate iMyValue = Cells(Cells.Find(What:="FindMe", After:=Cells(1, 1), LookIn:=xlFormulas, LookAt:=xlPart, _ SearchOrder:=xlByColumns, SearchDirection:=xlNext, MatchCase:= False, SearchF

$$Excel-Macros$$ Excel 2007

2009-07-30 Thread lymabeane
Hi: I am new to this group and please excuse me if I ask what has been asked before. Where I work I am considered a power user in Excel 2003. I have many customized toolbars and special pull down menus and lots of macro buttons. It took me years to do all this, but it really makes my job go fa

$$Excel-Macros$$ help with formula for report

2009-07-30 Thread harris a
Hello, I am enclosing file <>. I need help in populating the report table (Table 2). Problem explained in detail in the file. thank you regards Harris --~--~-~--~~~---~--~~ -- Some imp