Re: $$Excel-Macros$$ Re: Relating add-ins in word

2013-02-10 Thread David Grugeon
Sorry. Try this then https://groups.google.com/forum/m/?fromgroups#!msg/microsoft.public.word.vba.beginners/5s4yqyZJ610/3sSGE9nJPr0J. That group seems more suitable for you needs anyhow. On Monday, 11 February 2013, Prajakt Pande wrote: > This is for EXCEL but i am looking for word. > > Thanks &

Re: $$Excel-Macros$$ Re: Relating add-ins in word

2013-02-10 Thread Prajakt Pande
This is for EXCEL but i am looking for word. Thanks & Regards, Prajakt Pande +971551388482 ** On Mon, Feb 11, 2013 at 11:28 AM, David Grugeon wrote: > There is some actual vba code > On the MS website at > http://support.microsoft.com/default.aspx?scid=KB;EN-US;Q213360 > > Te page has instruct

RE: $$Excel-Macros$$ Macro

2013-02-10 Thread Manjunath Narayanappa
Dear Expert, I wanna learn basic macro, please anyone send me the ppt Thanks Manjunath From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Manjunath Narayanappa Sent: 07 February 2013 15:52 To: 'excel-macros@googlegroups.com' Subject: $$Excel-Macros$$ Macro

Re: $$Excel-Macros$$ Re: Relating add-ins in word

2013-02-10 Thread David Grugeon
There is some actual vba code On the MS website at http://support.microsoft.com/default.aspx?scid=KB;EN-US;Q213360 Te page has instructions how to use it. Hope this works for you. On Monday, 11 February 2013, Prajakt Pande wrote: > Any other option, our IT department not approving this EXE fil

Re: $$Excel-Macros$$ Re: Relating add-ins in word

2013-02-10 Thread Prajakt Pande
Any other option, our IT department not approving this EXE file. as per company policy. Please help. if it is keyboard shortcut it will be very good. Thanks & Regards, Prajakt Pande +971551388482 ** On Sun, Feb 10, 2013 at 4:29 PM, David Grugeon wrote: > I tried it and it works fine. After i

Re: $$Excel-Macros$$ U R G E N T - 2 sheet vlookup

2013-02-10 Thread nishant mendiratta
Hi, I hope this solves your problem, If not please elaborate your query. Regards, Nishant Mendiratta On Mon, Feb 11, 2013 at 11:35 AM, kannan excel wrote: > Hi, sorry boss... i didn't ask that. 1st sheet to 2nd sheet vlookup. 1st > sheet mobile number and 2nd sheet mobile numbers matching... >

Re: $$Excel-Macros$$ VBA Code for Home tab

2013-02-10 Thread amar takale
Dear Ashish & vijayajith Thanks Great work,thanks very much Regards Amar On Sat, Feb 9, 2013 at 6:07 PM, ashish koul wrote: > rename left button as lft_v > rename right button as rgt_v > rename home button as hm_v > > then assign this macro to all button > > > > > > > Sub macro_navigation() > >

Re: $$Excel-Macros$$ $$excel-$$ sumproduct not working in vba -reg.

2013-02-10 Thread karunanithi ramaswamy
Dear Gawli Anil,    I have slightly modified your code as per my requirement as follows and is working. Sub Macro1() Dim i, l, k As Long For l = 13 To 26   For i = 2 To 20     Cells(i, l).Value = "=SUMPRODUCT((C1=RC11)*(C8=R1C" & l & "))"         Next i   Next l    End Sub I sent you only the pa

Re: $$Excel-Macros$$ Re: VBA Code for Home tab

2013-02-10 Thread amar takale
Sorry for wrong name, Thanks Prince Sir. On Mon, Feb 11, 2013 at 12:06 PM, amar takale wrote: > Thank Price,thats Good idea > > > On Sat, Feb 9, 2013 at 6:33 PM, Prince wrote: > >> Hi Amar >> >> PFA. >> >> Note: Just remove all hyper links from the shapes and assign the name to >> all shapes

Re: $$Excel-Macros$$ Re: VBA Code for Home tab

2013-02-10 Thread amar takale
Thank Price,thats Good idea On Sat, Feb 9, 2013 at 6:33 PM, Prince wrote: > Hi Amar > > PFA. > > Note: Just remove all hyper links from the shapes and assign the name to > all shapes as i have provided on sheet2. Use same names to other shapes on > other sheets too. And assign the same macro to

Re: $$Excel-Macros$$ U R G E N T - 2 sheet vlookup

2013-02-10 Thread kannan excel
Hi, sorry boss... i didn't ask that. 1st sheet to 2nd sheet vlookup. 1st sheet mobile number and 2nd sheet mobile numbers matching... pls do the needful urgent base... my boss or waiting for that sheet. regads kannan On Mon, Feb 11, 2013 at 11:22 AM, nishant mendiratta < nishant.mendira...@g

Re: $$Excel-Macros$$ U R G E N T - 2 sheet vlookup

2013-02-10 Thread kannan excel
THANKS BOSS THANKS YOU VERY MUCH :) REGARDS KANNAN V On Mon, Feb 11, 2013 at 11:22 AM, nishant mendiratta < nishant.mendira...@gmail.com> wrote: > Hi, > The solution is attached. > > On Mon, Feb 11, 2013 at 11:00 AM, kannan excel wrote: > >> Hi, >> >> pls find the attachment file... here

Re: $$Excel-Macros$$ U R G E N T - 2 sheet vlookup

2013-02-10 Thread nishant mendiratta
Hi, The solution is attached. On Mon, Feb 11, 2013 at 11:00 AM, kannan excel wrote: > Hi, > > pls find the attachment file... here i enclosed my excel sheet i want > vlookup formula for 2 sheets. anybody help me urgent... > > > > regards > kannan v > 9940110453 > > -- > Are you =EXP(E:RT) or =NO

$$Excel-Macros$$ U R G E N T - 2 sheet vlookup

2013-02-10 Thread kannan excel
Hi, pls find the attachment file... here i enclosed my excel sheet i want vlookup formula for 2 sheets. anybody help me urgent... regards kannan v 9940110453 -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of thi

$$Excel-Macros$$ Re: Damage file

2013-02-10 Thread bonmaria57
Go to http://www.repaircorruptexcel.com to download excel file recovery software to recover your excel file which is corrupted. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.co

$$Excel-Macros$$ Re: How to write letter to boss

2013-02-10 Thread Prakash
Have a look here: http://www.readwritethink.org/files/resources/interactives/letter_generator/ On Thursday, February 7, 2013 10:48:36 AM UTC+5:30, nandu wrote: > > Hello Guys, > > I need your help, how to write a letter for additional staff in our branch. > > Please give me u r format here > > T

$$Excel-Macros$$ Re: Damage file Unable to retrive

2013-02-10 Thread Prakash
Hello Sajid, It seems your excel file is badly corrupted. It may be the only cause you are facing trouble. You need to restore it from backup file. *Additional Tips*: 1. Try to open it in WordPad, Notepad or MS Word, luckily if it works then you can recover at least your data. 2. Che

$$Excel-Macros$$ Damage file Unable to retrive

2013-02-10 Thread SAJID MEMON
dear I have done as per your suggestion but unable to retrieve my data. plz help me to retrieve it.awaiting your positive response RegardsSajid Memon Date: Fri, 8 Feb 2013 02:22:20 -0800 From: jpstel...@gmail.com To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Re: Damage file To re

$$Excel-Macros$$ vba code to insert chart from another excel file

2013-02-10 Thread Mangesh Vimay
Hi Friends, I need vba code to insert a chart from another Excel file. I have attached sample sheet. Please do the needful. Thanks !!! -- With regards, *MaNgEsH* -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page o

Re: $$Excel-Macros$$ Database sort (copy from one sheet to another sheet in different order)

2013-02-10 Thread joseph . camill
Thanks David for your quick response. Also the formula one is also a good one. If other experts can help, please do so. Sent on my BlackBerry® from Vodafone -Original Message- From: David Grugeon Sender: excel-macros@googlegroups.com Date: Sun, 10 Feb 2013 22:54:56 To: excel-macros@g

Re: $$Excel-Macros$$ Database sort (copy from one sheet to another sheet in different order)

2013-02-10 Thread David Grugeon
Hi Joseph It is certainly possible. I don't really have the time to do it right now. I am very busy at work but someone else may be able to help. On Sunday, 10 February 2013, joseph camill wrote: > can I get the same in vba > > > On Sun, Feb 10, 2013 at 5:18 AM, David Grugeon > > > wrote: > >

Re: $$Excel-Macros$$ Database sort (copy from one sheet to another sheet in different order)

2013-02-10 Thread joseph camill
can I get the same in vba On Sun, Feb 10, 2013 at 5:18 AM, David Grugeon wrote: > Hi Joseph > > Please find attached a solution. (Sheet - Output) > > It uses helper columns and rows which you can hide. > > To add another region just copy a complete region block (for example A3 to > L18 and pas

Re: $$Excel-Macros$$ Re: Relating add-ins in word

2013-02-10 Thread David Grugeon
I tried it and it works fine. After it is installed you have to close word (and possibly outlook because that has word as its editor) and reopen word. Then type a number, select it, and right click. You should get a window with the words and some options and buttons. If you click the right gree

Re: $$Excel-Macros$$ Re: Relating add-ins in word

2013-02-10 Thread Prajakt Pande
I tried this also but doesn't work. Thanks & Regards, Prajakt Pande +971551388482 ** On Sun, Feb 10, 2013 at 3:30 PM, David Grugeon wrote: > It looks as though you right click on the number and then click "spell > Number" > > Regards > David Grugeon > > > On 10 February 2013 21:10, Prajakt P

Re: $$Excel-Macros$$ Re: Relating add-ins in word

2013-02-10 Thread David Grugeon
It looks as though you right click on the number and then click "spell Number" Regards David Grugeon On 10 February 2013 21:10, Prajakt Pande wrote: > Dear David, > > I install but i didn't understand following sentence. > > Do not forget! The ''SpellNumber'' command will be available on docum

Re: $$Excel-Macros$$ Number Format code-not working !!

2013-02-10 Thread David Grugeon
try semicolons instead of commas Regards David Grugeon On 10 February 2013 20:08, Sreejith K.V wrote: > Hi There, > > I have tried adding the below number format code in the custom tool bar. > But i not getting the desired result. Can someone help me in fixing this > and let me know what went

Re: $$Excel-Macros$$ Re: Relating add-ins in word

2013-02-10 Thread David Grugeon
Hi Prajakt Pande Go to this web link and download.the com add-in http://cpap.com.br/orlando/WordSpellNumberMore.asp?IdC=OMKtPlc If you have problems with it let us know and we will try to help. Regards David Grugeon On 10 February 2013 19:59, Prajakt Pande wrote: > Dear David, > > Thanks fo

$$Excel-Macros$$ Number Format code-not working !!

2013-02-10 Thread Sreejith K . V
Hi There, I have tried adding the below number format code in the custom tool bar. But i not getting the desired result. Can someone help me in fixing this and let me know what went wrong. Number Format 1. 0.0,,”M” 2. 0.00,,”M” 2. $0.0,,”M” After applying any of the number formats and keyin

Re: $$Excel-Macros$$ Re: Relating add-ins in word

2013-02-10 Thread Prajakt Pande
Dear David, Thanks for your e-mail, Yes i am working on office 2010, and i am trying to convert amount in words by keyboard stork, currency will be USD (with Sign), AED (dherams), GBP (Pounds), EURO etc. I searched in Microsoft office web site but i failed to get the add-ins. Attached word file