Re: $$Excel-Macros$$ TOUGH QUESTION

2010-05-07 Thread Sandeep Kumar Maurya
Hi, It is possible AZHAR. What you have to do is 1. Mail merge all the links in word document. 2. Then use macro in MS Word to insert picture for all the links which have a image extension, like jpg, bmp etc. How you will do this. Apply the straight method of learning VBA. 1. Record a macro fo

Re: $$Excel-Macros$$ Re: Please help In seperating alphabets and numbers from a cell

2010-05-07 Thread Rahul Gandhi.
Guys I am very Sorry for turning up very late and giving you an alarm with respect to that all the above formula will not work if we found any alphanumeric string Lets take an example if we have appended string then the above formula will not work. "Hello my 9711 no is in 77 alpha numeric 2297 st

$$Excel-Macros$$ CC in Mail Merge

2010-05-07 Thread Rahul Gandhi.
Guys, I wanted to add CC or Multiple Receipients in a Mail Merge. Is there be any Possiblity then please let me know. Regards Rahul Gandhi. -- -- Some important links for excel users: 1. Follow us on TWITTER for ti

Re: $$Excel-Macros$$ Ebook on Excel 2003 VBA

2010-05-07 Thread Harpreet Singh Gujral
Jaao Matoso, The link doesnt work Harry On May 7, 2:35 am, João Matoso wrote: > www.tudosobrexcell.com > > 2010/5/6 nagendra baral > > > > > > > Hi There > > > Please send some website links which can be helpful in learning Excel > > VBA and downloading Ebooks. > > > Thanks and Regards > > Nag

Re: $$Excel-Macros$$ Excel Bug ?

2010-05-07 Thread Harpreet Singh Gujral
Shyam: Good Catch OSA: Good Solution... Thanks to both, for sharing this Harry On May 7, 1:14 pm, OSA wrote: > Hi,  Because "?" is a special character set in computer, if you want to find > it you must prefix it with tilde in the find. ( ~?) > > http://support.microsoft.com/kb/214138 > > -

$$Excel-Macros$$

2010-05-07 Thread nitz gupta
good to hear from u shyam, I am currently using trade tiger from sharekhan and i have a strategy that i think is profitable, wanted to know if i can use excel to automate my strategy nitin gupta 9731423808 -- -- So

$$Excel-Macros$$ VBA DATE

2010-05-07 Thread Sundarvelan N
Hi Friends, Can any one help me to solve the below condition *"HIGHLIGHT ANYTHING OVER 30 DAYS SINCE LAST ACTION FILL IN COLOR YELLOW"* Thanks, N.Sundarvelan -- -- Some important links for excel users: 1. Follow us

Re: $$Excel-Macros$$ VBA code to delete all dates before last week

2010-05-07 Thread Sundarvelan N
Hi Siti, Thank you very much Thanks, Sundarvelan On Fri, May 7, 2010 at 1:44 PM, siti Vi wrote: > Assuming that : > * YOUR LIST OF DATE are in a Range > * "to delete" means to clear the content of a cell containing Date > data > > Sub DoSomething() > Dim MyRange as Range, Xel As Range > Di

Re: $$Excel-Macros$$ TOUGH QUESTION

2010-05-07 Thread Aindril De
Hi azhar, Are these images stored somewhere in your local disk or online? Regards, aindril On Fri, May 7, 2010 at 10:46 AM, Azhar Rai wrote: > Dear Members > > Can someone help me create a trick related to mail merge in Office > 2007/2010. > > I want to mail merge pictures FROM an excel sheet

Re: $$Excel-Macros$$-Macro to Prepare Letters

2010-05-07 Thread Aindril De
Hi atul, Why dont u use mail merge. Regards, Andy On Fri, May 7, 2010 at 12:38 PM, Atul Kesaria wrote: > Hello Team, > > I am looking at a macro to write letter in word (a predefine letter format) > with certain field to be picked from an excel-sheet source. > > Request you to send me macro cod

Re: $$Excel-Macros$$ Date formatting

2010-05-07 Thread Aindril De
Hi Azhar, PFA the solution Regards, Andy On Fri, May 7, 2010 at 10:27 AM, Azhar Rai wrote: > Dear Members > > I was just trying to calculate a similer thing but could not. Please help > me too. > > I need to add a certain number of years to a date and get the resulting > date. HOW? > > Thanks

Re: $$Excel-Macros$$ Date formatting

2010-05-07 Thread Aindril De
Hi Goldie, PFA the solution. Regards, Aindril On Thu, May 6, 2010 at 4:43 PM, dare2gold wrote: > Dear Members,., > > i want to know how to get a later date just by inserting present date > into one column and getting the date we desire just by typing the no > of days > > suppose i entered

Re: $$Excel-Macros$$ Re: Extract Right Word in Line

2010-05-07 Thread anand shivappa
I am fine buddy. If it is more than 5 words in a cell how will you extract the right word. Probably Ashish has sent was the perfect solution for it. Thanks and Regards, Anand S On Fri, May 7, 2010 at 9:49 AM, Vikas Chouhan wrote: > hi anand how are you > > >

Re: $$Excel-Macros$$ prima and non-prima

2010-05-07 Thread siti Vi
there is a little correction in my code '--- Dim ArrDevisors() Sub BlaBlaBlaBla() ' siti Vi / bluewater, indonesia / 7 May 2010 Dim MyCell As Range Dim isPrima As String, n As Long Set MyCell = Selection isPrima = IsPrimeNumber(MyCell.Value) MyCell(1, 4) = "Result:"

Re: $$Excel-Macros$$ prima and non-prima

2010-05-07 Thread siti Vi
Dim ArrDevisors() Sub BlaBlaBlaBla() ' siti Vi / bluewater, indonesia / 7 May 2010 Dim MyCell As Range Dim isPrima As String, n As Long Set MyCell = Selection isPrima = IsPrimeNumber(MyCell.Value) MyCell(1, 4) = "Result:" MyCell(1, 5) = isPrima If isPrima = "NON-PRIMA" Then

Re: $$Excel-Macros$$ VBA code to delete all dates before last week

2010-05-07 Thread siti Vi
Assuming that : * YOUR LIST OF DATE are in a Range * "to delete" means to clear the content of a cell containing Date data Sub DoSomething() Dim MyRange as Range, Xel As Range Dim LastWeekWednesday As Date '--Please edit the code for your Range Set MyRange = Sheets("Bla").Range("A2:A65

Re: $$Excel-Macros$$ Excel Bug ?

2010-05-07 Thread OSA
Hi, Because "?" is a special character set in computer, if you want to find it you must prefix it with tilde in the find. ( ~?) http://support.microsoft.com/kb/214138 --- On Fri, May 7, 2010 at 3:05 PM, rf1234 rf1234 wrote: > Dear All, > Last time 1 of my friend come to me and ask that he is

Re: $$Excel-Macros$$ EXCEL SHORTCUT -- PLEASE HELP :-)

2010-05-07 Thread Sandeep Kumar Maurya
When we write function in any excel cell, EXCEL 2007 shows us a list of functions available from the word or character we written in the cell. Michael wants to know how we can get the function in the cell when list appears without writing it completely. So the solution is start to write your func

Re: $$Excel-Macros$$ EXCEL SHORTCUT -- PLEASE HELP :-)

2010-05-07 Thread L.K. Modi
sorry did not get select the funcion and presss tab can u expalin this dear friend On Fri, May 7, 2010 at 11:54 AM, Sandeep Kumar Maurya wrote: > Select the function and press tab. > > Thanks & Regards > Sandeep > > > On Thu, May 6, 2010 at 11:38 PM, Michael wrote: > >> I posted a picture

$$Excel-Macros$$-Macro to Prepare Letters

2010-05-07 Thread Atul Kesaria
Hello Team, I am looking at a macro to write letter in word (a predefine letter format) with certain field to be picked from an excel-sheet source. Request you to send me macro code. Thanks and Regards Atul Kesaria --

Re: $$Excel-Macros$$ Pivot Table Help - Gross Margin % & % of Sales

2010-05-07 Thread gurumurthy sastry Kondury
Hi, Just see the attached file and confirm If this is what you are looking for. Best Regards, Guru On Tue, May 4, 2010 at 8:57 PM, dza7 wrote: > Hello, > > I have a challenging pivot table issue that I hope I can get some help > on. > > Here is the spreadsheet I'm working with: > https://www.y

$$Excel-Macros$$ Find the last 5 users

2010-05-07 Thread Chetan
Someone has changed data in my sheet and i want to know the last 5 users , is there any possiblity to track the users -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links :

$$Excel-Macros$$ prima and non-prima

2010-05-07 Thread L- Van
hi all, im new member in this group.. I want to find a number of non-prime numbers.. (please see attachment) http://groups.google.com/group/excel-macros/web/prima_nonprima-EXCELMACRO.xls example READ45 RESULT NON-PRIMA 3

$$Excel-Macros$$ prima and non-prima

2010-05-07 Thread L- Van
hi all, im new member in this group.. I want to find a number of non-prime numbers.. (please see attachment) example READ 45 RESULT NON-PRIMA 3 5 9 15 … i read the number 15 the result will be NON-PRIMA and the below cell (optional) will create a number that can be divide

$$Excel-Macros$$ TOUGH QUESTION

2010-05-07 Thread Azhar Rai
Dear Members Can someone help me create a trick related to mail merge in Office 2007/2010. I want to mail merge pictures FROM an excel sheet (where there are hyperlink to different pictures) TO a word document. Your help will save a lot of my time and efforts. Regards AZHAR RAI Cell: 0333-552-

Re: $$Excel-Macros$$ Date formatting

2010-05-07 Thread Azhar Rai
Dear Members I was just trying to calculate a similer thing but could not. Please help me too. I need to add a certain number of years to a date and get the resulting date. HOW? Thanks AZHAR RAI Skype: azhar.rai On 6 May 2010 16:13, dare2gold wrote: > Dear Members,., > > i want to know how

RE: $$Excel-Macros$$ Need Help to pickup Rate List for formula

2010-05-07 Thread Hitesh Dilipbhai Dhare
Thanks for reply. With Regards, Hitesh. From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of ashish koul Sent: Thursday, May 06, 2010 3:55 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Need Help to picku

Re: $$Excel-Macros$$ Re: Extract Right Word in Line

2010-05-07 Thread Vikas Chouhan
hi anand how are you AB 1 vikas kumar =right(A1,LEN(A1)-FIND(" ",A1) RESULT IS "KUMAR" On Thu, May 6, 2010 at 9:39 AM, P.VIJAYKUMAR wrote: > Use the function RIGHT(Select the whole text in which the textor the thing > which you

Re: $$Excel-Macros$$ Re: Extract Right Word in Line

2010-05-07 Thread anand shivappa
Thanks Ashish. You have cleared my burden. Thanks a ton. Thanks and Regards, Anand S On Thu, May 6, 2010 at 9:22 PM, ashish koul wrote: > Public Function exright(Str) > Dim i, NumStr1 > NumStr1 = "" > > For i = Len(Str) To 1 Step -1 > If (Mid(Str, i, 1)) <> " " Then >

$$Excel-Macros$$ Excel Bug ?

2010-05-07 Thread rf1234 rf1234
Dear All, Last time 1 of my friend come to me and ask that he is using to search ? and want to replace it 0 just try it,in range a:a values are,i.e 1 1 1 1 1 1 ? ? 1 ? ? ? 1 1 ? Now when u will try to search ? and replace with 0,have a look what happen -- Thanks Regards Shyam Software Enginee