Thanks a lot Mohan, Its working fine and its allowing person to sign in via
yahoo and gmail.
Can we send an email to someone by giving recipient ID through a macro ?
Warm Regards
Ankur Aggarwal
91-8010614628
Analyst
Mckinsey Knowledge Center
Mckinsey & Co.
Fr
Sure Joseph.
Regards
Prince
On Friday, January 4, 2013 11:22:52 AM UTC+5:30, Joseph wrote:
>
> Thanks Prince, will go through this and revert incase of any further
> queries.
> Sent on my BlackBerry® from Vodafone
> --
> *From: * Prince >
> *Date: *Thu, 3 Jan 2013 19
Thanks Prince, will go through this and revert incase of any further queries.
Sent on my BlackBerry® from Vodafone
-Original Message-
From: Prince
Date: Thu, 3 Jan 2013 19:40:14
To:
Cc:
Subject: Re: $$Excel-Macros$$ Re: VBA or VSTO
Hi Joseph,
I m sharing this link please go through
Most welcome amar.
Regards
Prince
On Friday, January 4, 2013 11:05:00 AM UTC+5:30, amar takale wrote:
>
> Hi Prince,
> Really Great formula
> Thanks a lot
>
> Regards
> Amar
>
> On Fri, Jan 4, 2013 at 10:39 AM, Prince
> > wrote:
>
>> =IF(ISERROR( IF(ISERROR(
>> VLOOKUP(C6,Sheet2!$B$7:$F$25,5,0
Hi Prince,
Really Great formula
Thanks a lot
Regards
Amar
On Fri, Jan 4, 2013 at 10:39 AM, Prince wrote:
> =IF(ISERROR( IF(ISERROR(
> VLOOKUP(C6,Sheet2!$B$7:$F$25,5,0)),"NA",VLOOKUP(C6,Sheet2!$B$7:$F$25,5,0))/K6),"",IF(ISERROR(
> VLOOKUP(C6,Sheet2!$B$7:$F$25,5,0)),"NA",VLOOKUP(C6,Sheet2!$B$7:$F
Hi Mohan,
A humble request with experts to provide me a solution or guide me how to
extract closing price for specific stock Example ABB,ACC,INFY,WIPRO from
nseindia website.If Share market are open then show current price & after
closing market it show closing price.When I wish to add any stock
Hi Amar,
Just Paste the following formula in I6 Cell and Drag up to data I26.
=IF(ISERROR( IF(ISERROR(
VLOOKUP(C6,Sheet2!$B$7:$F$25,5,0)),"NA",VLOOKUP(C6,Sheet2!$B$7:$F$25,5,0))/K6),"",IF(ISERROR(
VLOOKUP(C6,Sheet2!$B$7:$F$25,5,0)),"NA",VLOOKUP(C6,Sheet2!$B$7:$F$25,5,0))/K6)
Regards
Prince
Hi Dear,
Can you please share it again with the output or result you want to see for
better clearity.
Regards,
Lalit Mohan
On Friday, 4 January 2013 01:18:39 UTC+5:30, Best Of Luck wrote:
>
> Lalit
>
> thanks for the macro. I am loading an example sheet for you . I need to
> run it for each
Hi Rashid,
Paste below code in the same module where the previous procedure is saved
and assign this procedure to the shape.
*Sub StartProcess()*
*
*
*Dim varData() As Variant*
*Dim rngRangeAs Range*
*
*
*Const strRawDataShtName
Hi Prashant,
I guess it is not the best practice to have the same identifier name for a
variable that going to be used locally and globally.But if you still want
have the same situation please use any of the example shared by Lalit Or
Paul.
Bu i will avoid this situation as this way of coding
Thanks for providing the link Mohan.
But unfortunately its giving me an error, file is corrupted and cannot be saved.
Warm Regards
Ankur
From: "mohan.pande...@gmail.com"
To: excel-macros@googlegroups.com
Sent: Friday, 4 January 2013 12:13 AM
Subject: Re: $$Ex
Hi Joseph,
I m sharing this link please go through with this i hope you will get all
your answer about VSTO.
http://easyvsto.wordpress.com/2010/01/01/vba-vs-vsto-an-interesting-study/
Regards
Prince
On Friday, January 4, 2013 12:00:44 AM UTC+5:30, Joseph wrote:
>
> Thanks Prince, could you giv
Thank you all for your help. I greatly appreciated it.
On Wednesday, January 2, 2013 10:17:41 PM UTC-5, Awal wrote:
>
> Hello,
> I would like to wish y'all a Happy New year...
> I am still learning VBA and I really need help:
> I want to be able to look up for an item and change its price.
> See
**Thanks Lalit
I can see the sample sheet and the code works fine.
As I requested in my previous post, can you please amend your code to look
for
*Col A - Date/Time* (the present code looks for Date/Time in Col B)
*Col B - Name* (the present code looks for Name in Col A)
If you can please amend
Lalit
thanks for the macro. I am loading an example sheet for you . I need to run
it for each activesheet using a button on a form.
On Thursday, January 3, 2013 4:47:27 AM UTC-6, Lalit Mohan Pandey wrote:
> Hi Dear,
>
> May be blow code will work as i understand but for better clearity
The link which I have sent you is my blog and I have done this for google
login. At that time it was working.
Sent from BlackBerry® on Airtel
-Original Message-
From: ANKUR AGGARWAL
Sender: excel-macros@googlegroups.com
Date: Fri, 4 Jan 2013 02:40:10
To: excel-macros@googlegroups.com
Re
Thanks, so you meant that you have logged in to the account but hasn't sent any
email.
I have tried doing that, but after entering the details into my yahoo email id,
its not allowing me to press enter, due to yahoo security.
Can you shared your method ?
Warm Regards
Ankur Aggarwal
91-8010614
Yes I already did it. Need some time if you really want it but I have just log
in the account not sure about sending email using vba.
Sent from BlackBerry® on Airtel
-Original Message-
From: ANKUR AGGARWAL
Sender: excel-macros@googlegroups.com
Date: Fri, 4 Jan 2013 02:07:47
To: Lalit
Thanks Prince, could you give me some more info on VSTO.
Sent on my BlackBerry® from Vodafone
-Original Message-
From: Prince
Sender: excel-macros@googlegroups.com
Date: Thu, 3 Jan 2013 02:07:46
To:
Reply-To: excel-macros@googlegroups.com
Cc:
Subject: $$Excel-Macros$$ Re: VBA or VSTO
If you INSIST on using the same variable as Public and Local, then
the only way I can think of is to make the assignment in a space in which
the Public variable is available.
I would use something like:
...
Save_Var(xyz)
...
then, create a subroutine:
Sub Save_Var(tVal)
xyz = tVal
End Sub
Hi Lalit,
Thanks for the reply.
Below link is not working and the file they have provided is not functioning.
Even I have googled a lot, and it seems due to security concerns, gmail or
yahoo servers are not allowing to access there web sites using a macro.
Please let me know if you have tried
Hi Prashant,
You can do it in this way but it is not a good practice
*Dim intValueAs Integer*
*
*
*Sub Test()*
*
*
*Dim intValueAs Integer*
**
*intValue = 10*
*
*
*End Sub*
*
*
*Sub AssignValueToGlobalVariable(ByVal intParameter As Integer)*
*
*
*
Hi Prashant,
Can you explain why you take same name variable in Public and Private scope.
Regards,
Lalit Mohan
On Thursday, 3 January 2013 23:15:17 UTC+5:30, prashant shinde wrote:
>
>
>
>
> Original message
> Subject: Conflict between Local and Global variable
> From: "Shinde,
Original message
Subject: Conflict between Local and Global variable
From: "Shinde, Hanumant"
To: "arsfan2...@yahoo.co.in"
CC:
Hi friends
I have below query.
There is variable xyz which has global scope as well as local scope.
In below sub I am able to change the value of
Hi All
I've been trying to write a VB/macro that will follow hyperlinks to fetch
data and then transpose this into a simple format, but to no avail.
An example of the information -
http://www.lawsociety.org.uk/find-a-solicitor/?view=solicitorswithspecialism&orgid=53235&specialism=LL&searchType=
Ignore the last one
PFA
On Thursday, January 3, 2013 6:28:42 PM UTC+5:30, harshad shukla wrote:
>
> dear Sir,
> please find attached file.
> In this I have to collect the value of supplier based on item code.
> For any single item code there can be two or more vendors.I want to get
> the qty. su
HI harshad ,
PFA.
Regards
Prince
On Thursday, January 3, 2013 6:28:42 PM UTC+5:30, harshad shukla wrote:
>
> dear Sir,
> please find attached file.
> In this I have to collect the value of supplier based on item code.
> For any single item code there can be two or more vendors.I want to get
> t
Hi Ankur,
You can find an example to login in gmail account using vba at below
mentioned link:-
http://powerofexcel.wordpress.com/2012/09/12/google-login-automation-through-excel-vba/
let us know for further assistance.
Regards,
Lalit Mohan
On Thursday, 3 January 2013 19:11:36 UTC+5:30, ankur
Hi Team,
I wanted to run an excel macro which can automate yahoo/gmail process using
excel vba. Upon clicking of the button, it will send an email from a web
browser ( IE ) using yahoo/gmail to a given email id.
Can anybody please help in doing that ? I have written a macro which actually
op
Dear,
PFA, Solved
Thanks & Regards,
Prajakt Pande
+971551388482
**
On Thu, Jan 3, 2013 at 4:58 PM, harshad shukla
wrote:
> dear Sir,
> please find attached file.
> In this I have to collect the value of supplier based on item code.
> For any single item code there can be two or more vendors.I
dear Sir,
please find attached file.
In this I have to collect the value of supplier based on item code.
For any single item code there can be two or more vendors.I want to get the
qty. supplied by each by using VLOOKUP.For any further clarification you
can give a miss call on my number mentioned b
Thanks to everyone who replied on my request.
I received several solutions for my problem and the file works perfect now.
You were all very helpfull.
Thanks again!
On Wednesday, January 2, 2013 4:04:59 PM UTC+1, dannym...@gmail.com wrote:
> In excel 2012 I'm using the name typed in a cell as a
Hi harshad,
May be this link help you for applying vlookup. It contains tutorial with
pictures
http://www.timeatlas.com/5_minute_tips/general/learning_vlookup_in_excel
Video tutorial
http://www.youtube.com/watch?v=HjRjRnzy-hA
Regards,
Lalit Mohan
On Thursday, 3 January 2013 16:09:23 UTC+5:3
Hi Rashid,
There is a sheet to make it visible just press alt + f11 in left side there is
a sheet named sample goto its properties visible and select visible
Regards,
Lalit Mohan
Sent from BlackBerry® on Airtel
-Original Message-
From: prkhan56
Sender: excel-macros@googlegroups.com
Dat
Can you please share ur wbk or can explain the senario through an example.
Regards
Prince
On Thursday, January 3, 2013 4:09:23 PM UTC+5:30, harshad shukla wrote:
>
> Dear all.
> I was stuck up while using vlookup on two parameters.please help.
> Urgent requirement.
> Harshad Shukla
>
--
Join of
Hi Hilary.
Please try to use database formula like (DSUM) instead of normal fomula as
D functions are much faster then normal functions.
Regards
Prince
On Thursday, January 3, 2013 2:53:23 PM UTC+5:30, hilary lomotey wrote:
>
> Hello Big Bosses
>
> I have a data am preparing which currently ha
Thanks will do
Sent from my BlackBerry® smartphone from Airtel Ghana
-Original Message-
From: Prajakt Pande
Sender: excel-macros@googlegroups.com
Date: Thu, 3 Jan 2013 14:49:38
To:
Reply-To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Slow processing of Data * *
This me
Hi hilary,
you can share your file by uploding it to other public file sharing website
and share the link to download it.
Regards,
Lalit Mohan
On Thursday, 3 January 2013 16:14:52 UTC+5:30, hilary lomotey wrote:
>
> This Ȋ̝̊̅§ very valuable info unfortunately this forum limits the size of
> da
Ok, can you do one thing, send me sample data
Thanks & Regards,
Prajakt Pande
+971551388482
**
On Thu, Jan 3, 2013 at 2:44 PM, wrote:
> **
> This Ȋ̝̊̅§ very valuable info unfortunately this forum limits the size of
> data I can send as ♍Ɣ file Ȋ̝̊̅§ about 6mg. So I can't send the file but
> c
Hi Dear,
May be blow code will work as i understand but for better clearity share
sample workbook.
*Sub FillWithSource()*
*
*
*Dim wksSht As Worksheet*
*Dim rngRangeAs Range*
**
*Const strSourceRangeAs S
This Ȋ̝̊̅§ very valuable info unfortunately this forum limits the size of data
I can send as ♍Ɣ file Ȋ̝̊̅§ about 6mg. So I can't send the file but can you let
me have the VBA code to do this or any option to send the file to you. Thanks
Sent from my BlackBerry® smartphone from Airtel Ghana
-
Hi,
Can you share your excel file.
Thanks & Regards,
Prajakt Pande
+971551388482
**
On Thu, Jan 3, 2013 at 2:39 PM, harshad shukla
wrote:
> I was stuck up while using vlookup on two parameter
--
Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1
Dear all.
I was stuck up while using vlookup on two parameters.please help.
Urgent requirement.
Harshad Shukla
--
Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent,
Hi Friend,
This group is only for VBA excel related stuff please dont post these here.
Regards
Prince
On Thursday, January 3, 2013 1:15:12 PM UTC+5:30, Entertainment daily wrote:
>
> LONDON (AP) — Stella McCartney, who designed the uniforms worn by
> Britain's record-smashing Olympic team, an
Hello Lalit
Thanks for your response.
There is no sheet *Sample* in the file you sent me.
However, can you also please the amend the code to take
Col A - Date/Time
Col B - Name
Your code looks for name in Col A and Date/Time and Col B
Thanks a lot once again for your time and help
Regards
Rashid
Hi Danny,
Just pass the name of file in belo metioned function it will remove all the
special charactor into the name
Function RemoveSpecialChrs(s As String) As String
Static RegEx As Object
If RegEx Is Nothing Then
Set RegEx = CreateObject("VBScript.RegExp")
With Re
Dear,
Can you share your worksheet.
What i am thinking:-
Just like your sheet having A column to z column data, with full of
formula's. we can do one thing we can insert one VBA code that will help
you.
Solution :-
Open the excel sheet with the popup of dont update the value. Like below.
wha
Thanks Anil but if I paste the formula as values it won't solve ♍Ɣ problem as
the data will be static.
Sent from my BlackBerry® smartphone from Airtel Ghana
-Original Message-
From: अनिल नारायण गवली
Date: Thu, 3 Jan 2013 15:03:04
To: ; Hilary Lomotey
Reply-To: gawlianil8...@gmail.com
Hi Joseph,
I guess both the technology has its own advantages and disadvantge.
*1: Easy to Use*
*
*
VBA is very simple and can be used to developed office application i a
quick time where as VSTO is bit tough but not so.
*2:Compatibility*
*
*
An application written is compatible only with wind
Try this
Sub sample_macro()
'tools -refrences - Outlook
Dim olApp As Outlook.Application
Dim olMail As MailItem
Dim imgnm As String
'Chnage path of image here
imgnm = "C:\Documents and Settings\user\Desktop\a.jpg"
Set olApp = New Outlook.Application
Set olMail = olApp.CreateItem(olMailItem)
Wit
Hi Viper,
Thanks for providing a very Nice formula
Regards
Prince
On Wednesday, January 2, 2013 3:07:20 PM UTC+5:30, §»VIPER«§ wrote:
>
> =LEFT(A1,MIN(IFERROR(FIND({0,1,2,3,4,5,6,7,8,9},A1),""))-1)&SUBSTITUTE(MID(A1,MIN(IFERROR(FIND({0,1,2,3,4,5,6,7,8,9},A1),"")),255),"
>
> ","")
>
> this sh
Hi Hilary,
As u r insered too-much formula it will hang the pc, because if u change
any cells value of simply edit that cell the processor calculate all the
fomula cell and hangsup.
simple way is to copy the formula values and paste it as simple values. but
from this it will not change the calcula
Hello Big Bosses
I have a data am preparing which currently has no VBA actions only formulas.
But anytime I click enter on any action or check a button calculation
processing starts from 58% to 100% before it completes the action. If I get to
the formula tab and set calculation to manual ♍Ɣ for
hi,
Happy new year,
I need a macro that would copy cells based upon values in other cells. I
am using Excel 10.
I have a worksbook that has about 20 worksheets in it. Each of these
worksheets has 2 columns A8:A108 & B8:B108.. I want a macro that would do
the following:
1. Select the act
54 matches
Mail list logo
