Re: $$Excel-Macros$$ Google Translator Using VBA - HELP !!!

2010-07-23 Thread Mahesh parab
Hi Vijay if you want to convert a figure in to words for other files then either you have to copy vb code in other files or you can download addin from below mention link which convert a figure in to words http://www.simpletaxindia.org/2010/01/convert-figure-to-word-excel-excel.html On Fri, Jul

Re: $$Excel-Macros$$ Google Translator Using VBA - HELP !!!

2010-07-22 Thread Vijay Aggarwal
Hi Mahesh, Convertword formula is working in your file only. If I open a new file it doesn't work. Please let me know what should I do? regards, Vijay Kumar Aggarwal 048542 On Wed, Jul 21, 2010 at 11:57 AM, Mahesh parab wrote: > Hi > > find attach sheet to convert amount into word. > > On

Re: $$Excel-Macros$$ Google Translator Using VBA - HELP !!!

2010-07-16 Thread saroj.32006
Dear Kishanreddy, Thank you very much for your tip, the disclosed tip saves my clerical work time a lot..! Thank you once again. And also I would like to take this opportunity to thank all the EXPERTS in this excel macro group who are not only helping to "N" no.of members in their p

Re: $$Excel-Macros$$ Google Translator Using VBA - HELP !!!

2010-07-16 Thread preeti vora
HI IS THAT ANY FORMULA WHEN WE WRIGHT NUMERICAL AMOUNT AND WANT TO CONVERT IN WORD. ANY BODY KNOW FORMULA ??? E.G = 25 ( TWENTY FIVE) On Thu, Jul 15, 2010 at 12:48 PM, Kishanreddy Kethireddy < kishanreddy.kethire...@gmail.com> wrote: > Hi, > > You can use iserror() function to find out an

Re: $$Excel-Macros$$ Google Translator Using VBA - HELP !!!

2010-07-15 Thread Kishanreddy Kethireddy
Hi, You can use iserror() function to find out any errors. You can use If() function to replace error values to zeroes. use the following formula in adjucent column/row of the actual values that you want to sum eg. you want total the values in column C, then use this formula in column D =IF(IS

Re: $$Excel-Macros$$ Google Translator Using VBA - HELP !!!

2010-07-15 Thread ashish koul
=SUMIF(C456:F456,"<>#N/a") or =SUMIF(C456:F456,"<0")+SUMIF(C456:F456,">0") regards ashish koul akoul.blogspot.com On Thu, Jul 15, 2010 at 11:27 AM, preeti vora wrote: > > Hi > > is that any formula when we do sum formula but some time in our data #N/A > in list that's WY we not able to see

Re: $$Excel-Macros$$ Google Translator Using VBA - HELP !!!

2010-07-14 Thread preeti vora
Hi is that any formula when we do sum formula but some time in our data #N/A in list that's WY we not able to see sum total. pls find the below mention example.if anybody know pls tell me formula. *Total* 20 25 #N/A 20 51 10 *#N/A=sum() * On Tue, Jul 13, 2010 at 11:48 PM, Harmeet Singh wrote:

Re: $$Excel-Macros$$ Google Translator Using VBA - HELP !!!

2010-07-14 Thread Anish Shrivastava
Hi Harmeet, Thanks a lot mate for this but I have been through this file and it converts the values one by one and takes hell lot of time. What I wanted was to upload the files to google translator... I m still breaking my head with google to find it smhow.. but coudnt find it. Thnks ANISh On

Re: $$Excel-Macros$$ Google Translator Using VBA - HELP !!!

2010-07-13 Thread Anish Shrivastava
PLease help me on this. On 7/13/10, Anish Shrivastava wrote: > > Hello Experts, > > Yesterday, while using Google Translator manually I just thought if it > can be automated using VBA. Actually what my task includes is to > Convert various European language values to Standard English lang. > > I

$$Excel-Macros$$ Google Translator Using VBA - HELP !!!

2010-07-12 Thread Anish Shrivastava
Hello Experts, Yesterday, while using Google Translator manually I just thought if it can be automated using VBA. Actually what my task includes is to Convert various European language values to Standard English lang. I have values in a single Column (No fixed number of rows/values but it will be