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
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
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
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
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
>
> -
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
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
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
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
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
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
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
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
>
>
>
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:"
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
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
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
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
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
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
--
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
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 :
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
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
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-
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
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
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
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
>
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
30 matches
Mail list logo