Re: $$Excel-Macros$$ 10 Ways to Use Magical INDIRECT Function

[C.G.Kumar]

Sir,


Could you plz explain how did you got the pic in worksheet 3 from worksheet
4 as the function yields to 0 when pasted in other area.

Regards,


C.G.Kumar

On Mon, Nov 14, 2011 at 11:58 PM, NOORAIN ANSARI
wrote:

> Dear Group,
>
> Please find attached Sheet to use 10 Simple way to use Indirect Function
> example..
>
> if any one have more examples Kindly share with group.
>
> The Excel INDIRECT function takes a text string and converts this into a
> cell reference.
>
> Excel does not understand the text string "B1" to mean a reference to the
> cell B1. Therefore, if you extract or build up a reference to a cell or
> range using text, you will need to use the INDIRECT function to convert
> this into a reference that Excel can understand.
>
> The format of the function is :
> INDIRECT( *Ref_text*, *A1* )
>
> Where the arguments are as follows :
>   *Ref_text* - The text describing the reference  *A1* - An optional
> logical argument that defines the style of the *Ref_text* reference.
> This can be either :
>
>- True - to denote that the reference is in A1 style
>- False - to denote that the reference is in R1C1 style
>
> If this argument is omitted, it takes on the default value "True"
>
> --
> Thanks & regards,
> Noorain Ansari
>  *http://excelmacroworld.blogspot.com/*
> *http://noorain-ansari.blogspot.com/*
>
>  --
> FORUM RULES (934+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>

-- 
FORUM RULES (934+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

$$Excel-Macros$$ Indirect formula

[smitha.kumari]

Hi,

 

Any one please explain why these quotes are used in this formula

 

=SUMIF(INDIRECT("'"&B$5&"'!A:A"),$A6,INDIRECT("'"&B$5&"'!I:I"))

 

Regards

Smitha 

 

-- 
FORUM RULES (934+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Fwd: $$Excel-Macros$$ Query on dd-mm & mm-yy format

[Suyog Kulkarni]

Hello Friends,

Following some additional clues I found to sort this issue & I think will
need good macro to solve the problem.
Step by step clues :

1) Identify the cells which have year 2000 & same cells should be converted
into "mm-yy" TEXT format.
2) Identify the cells which have mm-dd-yy format & same cells should be
converted into "dd-mm" TEXT format.
3) Remaining al cells should be remain UNCHANGED.

Formula I tried :
=IF(D7="","",IF(YEAR(D7)=2000,TEXT(D7,"mm-yy"),TEXT(D7,"dd-mm")))
But this is changing cells which are in correct format.

Please review.

Thanks & regards,
Suyog K


-- Forwarded message --
From: Suyog Kulkarni 
Date: Tue, Nov 15, 2011 at 10:32 AM
Subject: $$Excel-Macros$$ Query on dd-mm & mm-yy format
To: excel-macros@googlegroups.com


Hello Friends,

Find attached excel file for ref.

I'm using one software which list out required material for structure in
excel. Output of that excel file converts some length of "Ft-In" format in
"mm-dd-yy or mm-yy" format.
Ex: For Length 10-11, excel shows Nov-11 & For length 11-10, excel shows
10/11/11.

Somehow I need to keep all length either in text format or in Ft-inch
format. I'm not importing file into excel so I can't fix the "text type"
for particular column.

Manual edition will be tedious as there are more than 75 pages (Each have
more than 1000 rows), If anybody can suggest any easy way to save time.

Thanks & regards,
-- 
*Suyog Kulkarni*
Mailto:-suyog.kulka...@yahoo.com
   suyog.kulka...@hotmail.com
Ph:-( +91 ) 9890123539

-- 
FORUM RULES (934+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please
Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
will not get quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security
measure.

4) Acknowledge the responses you receive, good or bad.

5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited.

NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com



-- 
Suyog Kulkarni
Mailto:-suyog.kulka...@yahoo.com
   suyog.kulka...@hotmail.com
Ph:-( +91 ) 9890123539

-- 
FORUM RULES (934+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com


3042.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Re: $$Excel-Macros$$ 10 Ways to Use Magical INDIRECT Function

[David Lanne]

Sorry I zsee I forgot my name
 
Thanks,
David Lanne



From: David Lanne 
To: "excel-macros@googlegroups.com" 
Sent: Tuesday, November 15, 2011 1:09 AM
Subject: Re: $$Excel-Macros$$ 10 Ways to Use Magical INDIRECT Function

Thanks for the guide, I'm trying to do something similiar to example 3 but I 
can't seem to get my =getphoto cell (C3) to be a picture. Result comes up 0. I 
can't seem to get my C3 to accept/format the pic. 
 
My formula is
=indirect("Logos!B"&match('newspaper headlines'!$F$3,Logos!$A$:$A$,0)) My pics 
are in col b of Logos and the Text to match is in col A. 


From: NOORAIN ANSARI 
To: excel-macros@googlegroups.com
Sent: Monday, November 14, 2011 10:04 PM
Subject: Re: $$Excel-Macros$$ 10 Ways to Use Magical INDIRECT Function

Thanks Don,

I have removed all external name range link from file which were showing ref 
error.

Aside to Nikhil : In Example 9 Form's Controls has used,which are not in excel 
2003 so it is showing error. -- 
Thanks & regards,
Noorain Ansari
http://excelmacroworld.blogspot.com/
http://noorain-ansari.blogspot.com/
On Tue, Nov 15, 2011 at 12:55 AM, dguillett1  wrote: 
That example is using an external file so the defined name shows ref
>
>Don Guillett SalesAid softwaredguille...@gmail.com
>
>From: Nikhil Shah 
>Sent: Monday, November 14, 2011 12:43 PM
>To: excel-macros@googlegroups.com 
>Subject: Re: $$Excel-Macros$$ 10 Ways to Use Magical INDIRECT Function
>
>Dear Noorain 
>
>Excellent Help.
>
>Example 9 - Sheet is showing some error...Can you rectify ?
>
>I am using Office Excel 2003. 
>
>Thanks in advance
>
>Nikhil
>
>On Mon, Nov 14, 2011 at 11:58 PM, NOORAIN ANSARI  
>wrote: 
>Dear Group,
>>
>>Please find attached Sheet to use 10 Simple way to use Indirect Function 
>>example..
>>
>>if any one have more examples Kindly share with group.
>>
>>The Excel INDIRECT function takes a text string and converts this into a cell 
>>reference. 
>>Excel does not understand the text string "B1" to mean a reference to the 
>>cell B1. Therefore, if you extract or build up a reference to a cell or range 
>>using text, you will need to use the INDIRECT function to convert this into a 
>>reference that Excel can understand. 
>>The format of the function is : 
>>INDIRECT( Ref_text, A1 )
>>
>>Where the arguments are as follows : 
>>Ref_text - The text describing the reference 
>>A1 - An optional logical argument that defines the style of the Ref_text 
>>reference.
>>This can be either :
>>
>>  * True - to denote that the reference is in A1 style 
>>  * False - to denote that the reference is in R1C1 styleIf this argument 
>> is omitted, it takes on the default value "True"  -- 
>>Thanks & regards,
>>Noorain Ansari
>>http://excelmacroworld.blogspot.com/
>>http://noorain-ansari.blogspot.com/
>>-- 
>>FORUM RULES (934+ members already BANNED for violation)
>> 
>>1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
>>Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not 
>>get quick attention or may not be answered.
>> 
>>2) Don't post a question in the thread of another member.
>> 
>>3) Don't post questions regarding breaking or bypassing any security measure.
>> 
>>4) Acknowledge the responses you receive, good or bad.
>> 
>>5) Cross-promotion of, or links to, forums competitive to this forum in 
>>signatures are prohibited. 
>> 
>>NOTE : Don't ever post personal or confidential data in a workbook. Forum 
>>owners and members are not responsible for any loss.
>> 
>>--
>>To post to this group, send email to excel-macros@googlegroups.com
>>
>-- FORUM RULES (934+ members already BANNED for violation)   1) Use concise, 
>accurate thread titles. Poor thread titles, like Please Help, Urgent, Need 
>Help, Formula Problem, Code Problem, and Need Advice will not get quick 
>attention or may not be answered.   2) Don't post a question in the thread of 
>another member.   3) Don't post questions regarding breaking or bypassing any 
>security measure.   4) Acknowledge the responses you receive, good or bad.   
>5) Cross-promotion of, or links to, forums competitive to this forum in 
>signatures are prohibited.   NOTE : Don't ever post personal or confidential 
>data in a workbook. Forum owners and members are not responsible for any loss. 
>  
>--
> To post to this group, send email to excel-macros@googlegroups.com
>-- FORUM RULES (934+ members already BANNED for violation)   1) Use concise, 
>accurate thread titles. Poor thread titles, like Please Help, Urgent, Need 
>Help, Formula Problem, Code Problem, and Need Advice will not get quick 
>attention or may not be answered.   2) Don't post a question in the thread of 
>another member.   3) Don't post questions regarding breaking 

Re: $$Excel-Macros$$ 10 Ways to Use Magical INDIRECT Function

[David Lanne]

Thanks for the guide, I'm trying to do something similiar to example 3 but I 
can't seem to get my =getphoto cell (C3) to be a picture. Result comes up 0. I 
can't seem to get my C3 to accept/format the pic. 
 
My formula is
=indirect("Logos!B"&match('newspaper headlines'!$F$3,Logos!$A$:$A$,0)) My pics 
are in col b of Logos and the Text to match is in col A. 


From: NOORAIN ANSARI 
To: excel-macros@googlegroups.com
Sent: Monday, November 14, 2011 10:04 PM
Subject: Re: $$Excel-Macros$$ 10 Ways to Use Magical INDIRECT Function

Thanks Don,

I have removed all external name range link from file which were showing ref 
error.

Aside to Nikhil : In Example 9 Form's Controls has used,which are not in excel 
2003 so it is showing error.-- 
Thanks & regards,
Noorain Ansari
http://excelmacroworld.blogspot.com/
http://noorain-ansari.blogspot.com/
On Tue, Nov 15, 2011 at 12:55 AM, dguillett1  wrote: 
That example is using an external file so the defined name shows ref
>
>Don GuillettSalesAid softwaredguille...@gmail.com
>
>From: Nikhil Shah 
>Sent: Monday, November 14, 2011 12:43 PM
>To: excel-macros@googlegroups.com 
>Subject: Re: $$Excel-Macros$$ 10 Ways to Use Magical INDIRECT Function
>
>Dear Noorain 
>
>Excellent Help.
>
>Example 9 - Sheet is showing some error...Can you rectify ?
>
>I am using Office Excel 2003. 
>
>Thanks in advance
>
>Nikhil
>
>On Mon, Nov 14, 2011 at 11:58 PM, NOORAIN ANSARI  
>wrote: 
>Dear Group,
>>
>>Please find attached Sheet to use 10 Simple way to use Indirect Function 
>>example..
>>
>>if any one have more examples Kindly share with group.
>>
>>The Excel INDIRECT function takes a text string and converts this into a cell 
>>reference. 
>>Excel does not understand the text string "B1" to mean a reference to the 
>>cell B1. Therefore, if you extract or build up a reference to a cell or range 
>>using text, you will need to use the INDIRECT function to convert this into a 
>>reference that Excel can understand. 
>>The format of the function is : 
>>INDIRECT( Ref_text, A1 )
>>
>>Where the arguments are as follows : 
>>Ref_text - The text describing the reference 
>>A1 - An optional logical argument that defines the style of the Ref_text 
>>reference.
>>This can be either :
>>
>>  * True - to denote that the reference is in A1 style 
>>  * False - to denote that the reference is in R1C1 styleIf this argument 
>> is omitted, it takes on the default value "True"  -- 
>>Thanks & regards,
>>Noorain Ansari
>>http://excelmacroworld.blogspot.com/
>>http://noorain-ansari.blogspot.com/
>>-- 
>>FORUM RULES (934+ members already BANNED for violation)
>> 
>>1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
>>Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not 
>>get quick attention or may not be answered.
>> 
>>2) Don't post a question in the thread of another member.
>> 
>>3) Don't post questions regarding breaking or bypassing any security measure.
>> 
>>4) Acknowledge the responses you receive, good or bad.
>> 
>>5) Cross-promotion of, or links to, forums competitive to this forum in 
>>signatures are prohibited. 
>> 
>>NOTE : Don't ever post personal or confidential data in a workbook. Forum 
>>owners and members are not responsible for any loss.
>> 
>>--
>>To post to this group, send email to excel-macros@googlegroups.com
>>
>-- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, 
>accurate thread titles. Poor thread titles, like Please Help, Urgent, Need 
>Help, Formula Problem, Code Problem, and Need Advice will not get quick 
>attention or may not be answered. 2) Don't post a question in the thread of 
>another member. 3) Don't post questions regarding breaking or bypassing any 
>security measure. 4) Acknowledge the responses you receive, good or bad. 5) 
>Cross-promotion of, or links to, forums competitive to this forum in 
>signatures are prohibited.  NOTE : Don't ever post personal or confidential 
>data in a workbook. Forum owners and members are not responsible for any 
>loss. --To
> post to this group, send email to excel-macros@googlegroups.com
>-- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, 
>accurate thread titles. Poor thread titles, like Please Help, Urgent, Need 
>Help, Formula Problem, Code Problem, and Need Advice will not get quick 
>attention or may not be answered. 2) Don't post a question in the thread of 
>another member. 3) Don't post questions regarding breaking or bypassing any 
>security measure. 4) Acknowledge the responses you receive, good or bad. 5) 
>Cross-promotion of, or links to, forums competitive to this forum in 
>signatures are prohibited.  NOTE : Don't ever post personal or confidential 
>data in a workbook. Forum owners a

Re: $$Excel-Macros$$ 10 Ways to Use Magical INDIRECT Function

[NOORAIN ANSARI]

Thanks JP,

Currently i m working on below mentioned formula with various live examples

Thanks & regards,
Noorain Ansari
 *http://excelmacroworld.blogspot.com/*
*http://noorain-ansari.blogspot.com/* 
On Tue, Nov 15, 2011 at 10:17 AM, Jayaprakash S
wrote:

> Hey Noorain,
>
> Superb Job!!!
>
> When ever you find time & who ever knows on this can help us out on :
> Address, Index, Match,Offset, Rows & Columns formulas the same stuff as you
> did now!!
>
> Cheers
>
> JP.
>
>
> On Mon, Nov 14, 2011 at 11:58 PM, NOORAIN ANSARI  > wrote:
>
>> Dear Group,
>>
>> Please find attached Sheet to use 10 Simple way to use Indirect Function
>> example..
>>
>> if any one have more examples Kindly share with group.
>>
>> The Excel INDIRECT function takes a text string and converts this into a
>> cell reference.
>>
>> Excel does not understand the text string "B1" to mean a reference to the
>> cell B1. Therefore, if you extract or build up a reference to a cell or
>> range using text, you will need to use the INDIRECT function to convert
>> this into a reference that Excel can understand.
>>
>> The format of the function is :
>> INDIRECT( *Ref_text*, *A1* )
>>
>> Where the arguments are as follows :
>>   *Ref_text* - The text describing the reference *A1* - An optional
>> logical argument that defines the style of the *Ref_text* reference.
>> This can be either :
>>
>>- True - to denote that the reference is in A1 style
>>- False - to denote that the reference is in R1C1 style
>>
>> If this argument is omitted, it takes on the default value "True"
>>
>> --
>>
>> --
>> FORUM RULES (934+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>
>
>
> --
> Regards, Jayaprakash. S (JAYAPRAKASH. S.) Adaptability is the most
> desirable habit for success - Swamy Vivekananda. This message is for
> the designated recipient only and may contain privileged, proprietary,
> or otherwise private information. If you have received it in error,
> please notify the sender immediately and delete the original. Any other
> use of the email by you is prohibited.
>
> --
> FORUM RULES (934+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>



-- 
Thanks & regards,
Noorain Ansari
 *http://excelmacroworld.blogspot.com/*
*http://noorain-ansari.blogspot.com/* 

-- 
FORUM RULES (934+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

$$Excel-Macros$$ Query on dd-mm & mm-yy format

[Suyog Kulkarni]

Hello Friends,

Find attached excel file for ref.

I'm using one software which list out required material for structure in
excel. Output of that excel file converts some length of "Ft-In" format in
"mm-dd-yy or mm-yy" format.
Ex: For Length 10-11, excel shows Nov-11 & For length 11-10, excel shows
10/11/11.

Somehow I need to keep all length either in text format or in Ft-inch
format. I'm not importing file into excel so I can't fix the "text type"
for particular column.

Manual edition will be tedious as there are more than 75 pages (Each have
more than 1000 rows), If anybody can suggest any easy way to save time.

Thanks & regards,
-- 
*Suyog Kulkarni*
Mailto:-suyog.kulka...@yahoo.com
   suyog.kulka...@hotmail.com
Ph:-( +91 ) 9890123539

-- 
FORUM RULES (934+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com


3042.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Re: $$Excel-Macros$$ 10 Ways to Use Magical INDIRECT Function

[Jayaprakash S]

Hey Noorain,

Superb Job!!!

When ever you find time & who ever knows on this can help us out on :
Address, Index, Match,Offset, Rows & Columns formulas the same stuff as you
did now!!

Cheers

JP.


On Mon, Nov 14, 2011 at 11:58 PM, NOORAIN ANSARI
wrote:

> Dear Group,
>
> Please find attached Sheet to use 10 Simple way to use Indirect Function
> example..
>
> if any one have more examples Kindly share with group.
>
> The Excel INDIRECT function takes a text string and converts this into a
> cell reference.
>
> Excel does not understand the text string "B1" to mean a reference to the
> cell B1. Therefore, if you extract or build up a reference to a cell or
> range using text, you will need to use the INDIRECT function to convert
> this into a reference that Excel can understand.
>
> The format of the function is :
> INDIRECT( *Ref_text*, *A1* )
>
> Where the arguments are as follows :
>   *Ref_text* - The text describing the reference *A1* - An optional
> logical argument that defines the style of the *Ref_text* reference.
> This can be either :
>
>- True - to denote that the reference is in A1 style
>- False - to denote that the reference is in R1C1 style
>
> If this argument is omitted, it takes on the default value "True"
>
> --
> Thanks & regards,
> Noorain Ansari
>  *http://excelmacroworld.blogspot.com/*
> *http://noorain-ansari.blogspot.com/*
>
> --
> FORUM RULES (934+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>



-- 
Regards, Jayaprakash. S (JAYAPRAKASH. S.) Adaptability is the most
desirable habit for success - Swamy Vivekananda. This message is for
the designated recipient only and may contain privileged, proprietary,
or otherwise private information. If you have received it in error,
please notify the sender immediately and delete the original. Any other
use of the email by you is prohibited.

-- 
FORUM RULES (934+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ Need help on Micro Button!!!!!!!!!!!!!!!!!!!

[jocky Beta]

Hey Thanks Sam It's working..

*
*
*Regards,*
*Jocky*

On Mon, Nov 14, 2011 at 8:30 PM, Sam Mathai Chacko wrote:

> Use this code in Sheet1 VBA code module
>
> Private Sub CommandButton1_Click()
> ActiveSheet.Range("B4:B32").EntireRow.Hidden = Not
> ActiveSheet.Range("B4:B32").EntireRow.Hidden
>
> End Sub
> Private Sub CommandButton2_Click()
> ActiveSheet.Range("B35:B50").EntireRow.Hidden = Not
> ActiveSheet.Range("B35:B50").EntireRow.Hidden
>
> End Sub
> Private Sub CommandButton3_Click()
> ActiveSheet.Range("B53:B69").EntireRow.Hidden = Not
> ActiveSheet.Range("B53:B69").EntireRow.Hidden
>
> End Sub
> Private Sub CommandButton4_Click()
> ActiveSheet.Range("B72:B88").EntireRow.Hidden = Not
> ActiveSheet.Range("B72:B88").EntireRow.Hidden
>
> End Sub
>
> Regards,
> Sam
>
> On Mon, Nov 14, 2011 at 4:17 PM, jocky Beta  wrote:
>
>>
>> HI Team,
>>
>>I had created one sheet in which  i made the Groups Now i want to link
>> the Buttons which i created in the sheet (When i click the Button it should
>> expand the group and wen again click the button it needs to be close).
>>
>> Please help me on this
>>
>> *
>> *
>> *Regards,*
>> *Jocky*
>>
>> --
>> FORUM RULES (934+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>
>
>
> --
> Sam Mathai Chacko
>
>  --
> FORUM RULES (934+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>

-- 
FORUM RULES (934+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ 10 Ways to Use Magical INDIRECT Function

[Nikhil Shah]

Dear Noorain

Pl tell me following formula - Highlight ( Example 9 - Sheet )

=*_xlfn.*
IFERROR(VLOOKUP($E$10,$AF$2:$AW$40,MATCH($A$26,$AF$1:$AW$1,0)+1,0),"0")

again error in E10 , E14 , E16 , E18 . seems you have linked with another
sheet.

you have linked with Leave_calcualtor(1).xls with Example 9..

Pl tell me how to remove..

Thanks

Nikhil
On Tue, Nov 15, 2011 at 8:34 AM, NOORAIN ANSARI wrote:

> Thanks Don,
>
> I have removed all external name range link from file which were showing
> ref error.
>
> Aside to Nikhil : In Example 9 Form's Controls has used,which are not in
> excel 2003 so it is showing error.
>
>
> --
> Thanks & regards,
> Noorain Ansari
>  *http://excelmacroworld.blogspot.com/*
> *http://noorain-ansari.blogspot.com/*
> On Tue, Nov 15, 2011 at 12:55 AM, dguillett1  wrote:
>
>>   That example is using an external file so the defined name shows ref
>>
>> Don Guillett
>> SalesAid Software
>> dguille...@gmail.com
>>
>>  *From:* Nikhil Shah 
>> *Sent:* Monday, November 14, 2011 12:43 PM
>> *To:* excel-macros@googlegroups.com
>> *Subject:* Re: $$Excel-Macros$$ 10 Ways to Use Magical INDIRECT Function
>>
>>   Dear Noorain
>>
>> Excellent Help.
>>
>> Example 9 - Sheet is showing some error...Can you rectify ?
>>
>> I am using Office Excel 2003.
>>
>> Thanks in advance
>>
>> Nikhil
>>
>>
>>
>> On Mon, Nov 14, 2011 at 11:58 PM, NOORAIN ANSARI <
>> noorain.ans...@gmail.com> wrote:
>>
>>> Dear Group,
>>>
>>> Please find attached Sheet to use 10 Simple way to use Indirect Function
>>> example..
>>>
>>> if any one have more examples Kindly share with group.
>>>
>>> The Excel INDIRECT function takes a text string and converts this into a
>>> cell reference.
>>>
>>> Excel does not understand the text string "B1" to mean a reference to
>>> the cell B1. Therefore, if you extract or build up a reference to a cell or
>>> range using text, you will need to use the INDIRECT function to convert
>>> this into a reference that Excel can understand.
>>>
>>> The format of the function is :
>>> INDIRECT( *Ref_text*, *A1* )
>>>
>>> Where the arguments are as follows :
>>>   *Ref_text* - The text describing the reference  *A1* - An optional
>>> logical argument that defines the style of the *Ref_text* reference.
>>> This can be either :
>>>
>>>- True - to denote that the reference is in A1 style
>>>- False - to denote that the reference is in R1C1 style
>>>
>>> If this argument is omitted, it takes on the default value "True"
>>>
>>> --
>>> Thanks & regards,
>>> Noorain Ansari
>>>  
>>> *http://excelmacroworld.blogspot.com/*
>>> *http://noorain-ansari.blogspot.com/*
>>>
>>> --
>>> FORUM RULES (934+ members already BANNED for violation)
>>>
>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>>> will not get quick attention or may not be answered.
>>>
>>> 2) Don't post a question in the thread of another member.
>>>
>>> 3) Don't post questions regarding breaking or bypassing any security
>>> measure.
>>>
>>> 4) Acknowledge the responses you receive, good or bad.
>>>
>>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>>> signatures are prohibited.
>>>
>>> NOTE : Don't ever post personal or confidential data in a workbook.
>>> Forum owners and members are not responsible for any loss.
>>>
>>>
>>> --
>>> To post to this group, send email to excel-macros@googlegroups.com
>>>
>>
>> --
>> FORUM RULES (934+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> --
>> FORUM RULES (934+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regard

Re: $$Excel-Macros$$ 10 Ways to Use Magical INDIRECT Function

[dguillett1]

That example is using an external file so the defined name shows ref

Don Guillett
SalesAid Software
dguille...@gmail.com

From: Nikhil Shah 
Sent: Monday, November 14, 2011 12:43 PM
To: excel-macros@googlegroups.com 
Subject: Re: $$Excel-Macros$$ 10 Ways to Use Magical INDIRECT Function

Dear Noorain 

Excellent Help.

Example 9 - Sheet is showing some error...Can you rectify ?

I am using Office Excel 2003. 

Thanks in advance

Nikhil




On Mon, Nov 14, 2011 at 11:58 PM, NOORAIN ANSARI  
wrote:

  Dear Group,

  Please find attached Sheet to use 10 Simple way to use Indirect Function 
example..

  if any one have more examples Kindly share with group.

  The Excel INDIRECT function takes a text string and converts this into a cell 
reference. 
  Excel does not understand the text string "B1" to mean a reference to the 
cell B1. Therefore, if you extract or build up a reference to a cell or range 
using text, you will need to use the INDIRECT function to convert this into a 
reference that Excel can understand. 

  The format of the function is : 

  INDIRECT( Ref_text, A1 )


  Where the arguments are as follows : 

Ref_text - The text describing the reference 
A1 - An optional logical argument that defines the style of the 
Ref_text reference.
This can be either :

  a.. True - to denote that the reference is in A1 style 
  b.. False - to denote that the reference is in R1C1 style
If this argument is omitted, it takes on the default value "True"  


  -- 

  Thanks & regards,
  Noorain Ansari
  http://excelmacroworld.blogspot.com/
  http://noorain-ansari.blogspot.com/

  -- 
  FORUM RULES (934+ members already BANNED for violation)
   
  1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
   
  2) Don't post a question in the thread of another member.
   
  3) Don't post questions regarding breaking or bypassing any security measure.
   
  4) Acknowledge the responses you receive, good or bad.
   
  5) Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 
   
  NOTE : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
   
  
--
  To post to this group, send email to excel-macros@googlegroups.com


-- 
FORUM RULES (934+ members already BANNED for violation)
 
1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
 
2) Don't post a question in the thread of another member.
 
3) Don't post questions regarding breaking or bypassing any security measure.
 
4) Acknowledge the responses you receive, good or bad.
 
5) Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
 
--
To post to this group, send email to excel-macros@googlegroups.com

-- 
FORUM RULES (934+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ 10 Ways to Use Magical INDIRECT Function

[Nikhil Shah]

Dear Noorain

Excellent Help.

Example 9 - Sheet is showing some error...Can you rectify ?

I am using Office Excel 2003.

Thanks in advance

Nikhil



On Mon, Nov 14, 2011 at 11:58 PM, NOORAIN ANSARI
wrote:

> Dear Group,
>
> Please find attached Sheet to use 10 Simple way to use Indirect Function
> example..
>
> if any one have more examples Kindly share with group.
>
> The Excel INDIRECT function takes a text string and converts this into a
> cell reference.
>
> Excel does not understand the text string "B1" to mean a reference to the
> cell B1. Therefore, if you extract or build up a reference to a cell or
> range using text, you will need to use the INDIRECT function to convert
> this into a reference that Excel can understand.
>
> The format of the function is :
> INDIRECT( *Ref_text*, *A1* )
>
> Where the arguments are as follows :
>   *Ref_text* - The text describing the reference  *A1* - An optional
> logical argument that defines the style of the *Ref_text* reference.
> This can be either :
>
>- True - to denote that the reference is in A1 style
>- False - to denote that the reference is in R1C1 style
>
> If this argument is omitted, it takes on the default value "True"
>
> --
> Thanks & regards,
> Noorain Ansari
>  *http://excelmacroworld.blogspot.com/*
> *http://noorain-ansari.blogspot.com/*
>
>  --
> FORUM RULES (934+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>

-- 
FORUM RULES (934+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ Abridged summary of excel-macros@googlegroups.com - 20 Messages in 7 Topics

[Sam Mathai Chacko]

Here's a link that is on the same lines

http://www.excelfox.com/forum/f2/excel-template-macro-sending-mails-attahment-thru-outlook-142/

Regards

Sam Mathai Chacko

On Mon, Nov 14, 2011 at 8:33 PM, NOORAIN ANSARI wrote:

> Dear Sanju,
>
> Please see attached Sheet, I hope it will help to u.
>
> Sub maildata()
> Dim a As Workbook
> Dim data As Range
> Set data = ThisWorkbook.Sheets(1).Range("a1:f27")
> data.Copy
> Set a = Workbooks.Add
> a.Sheets(1).Cells(1, 1).Select
> ActiveSheet.Paste
> MsgBox ThisWorkbook.Path
> a.SaveAs ThisWorkbook.Path & "D:\MIS_Noorain\Personal\Automatic Email
> through Out Look.xls"
> a.Close
> Dim olApp As Outlook.Application
> Dim olMail As MailItem
> Dim SigString As String
> Dim Signature As String
> Application.ScreenUpdating = False
> Set olApp = New Outlook.Application
> Set olMail = olApp.CreateItem(olMailItem)
> With olMail
> .To = "noorain.ans...@gmail.com"
> .CC = "noorain.ans...@one97.net"
>  .Subject = "Incoming Status!"
> .Body = "Messages " & vbCrLf & vbCrLf & " Thanks " & vbCrLf & "Regards" &
> vbCrLf & " Ashish Koul"
> .Attachments.Add ThisWorkbook.Path & "D:\MIS_Noorain\Personal\Automatic
> Email through Out Look.xls"
> .Send
>  End With
> Set olMail = Nothing
> 'Kill ThisWorkbook.Path & "\abc1.xls"
> End Sub
>
>
> On Mon, Nov 14, 2011 at 6:19 PM, sanju kanery wrote:
>
>> Hi,
>>
>> Can anybody help me with macros for mass mailing from given list of email
>> id's with select data from data sheet.
>>
>> Rgds
>>
>> Sanju Kanery
>>
>> On Mon, Nov 14, 2011 at 5:12 AM,  wrote:
>>
>>>   Today's Topic Summary
>>>
>>> Group: http://groups.google.com/group/excel-macros/topics
>>>
>>>- Listing name of worksheet & renaming 
>>> them[7
>>>  Updates]
>>>- PDF to 
>>> Excel[2
>>>  Updates]
>>>- To Set Dropdownlist in 
>>> Chart[5
>>>  Updates]
>>>- Macro-coding 
>>> required[2
>>>  Updates]
>>>- Import PDF into 
>>> Excel[2
>>>  Updates]
>>>- MS-Excel 
>>> Hanging[1
>>>  Update]
>>>- SUM 
>>> Reg.[1
>>>  Update]
>>>
>>>  Listing name of worksheet & renaming 
>>> them
>>>
>>>"Amit Desai (MERU)"  Nov 13 01:36PM +0530
>>>
>>>Dear Master,
>>>
>>>I have an excel file with sheet names ranging from A to V. However I
>>>want to change its sequence post changing its name.
>>>
>>>Do we have any shortcut?
>>>
>>>Regards,
>>>Amit Desai ...more
>>>
>>>
>>>Aindril De  Nov 13 02:03PM +0530
>>>
>>>Pl chk this,
>>>
>>>http://support.microsoft.com/kb/812386
>>>
>>>Cheers,
>>>Andy
>>>
>>>On Sun, Nov 13, 2011 at 1:36 PM, Amit Desai (MERU)
>>>
>>>--
>>>...more
>>>
>>>
>>>"Amit Desai (MERU)"  Nov 13 02:20PM +0530
>>>
>>>Thanks.. this helped me in arranging it..but how to list & rename
>>>it.. say..Sheet A to become C, R to become S etc...
>>>
>>>Regards,
>>>Amit Desai
>>>AM - MIS Corporate
>>>Meru Cabs Company Pvt.Ltd
>>>Mumbai ...more
>>>
>>>
>>>Sam Mathai Chacko  Nov 13 06:28PM +0530
>>>
>>>Here's how you can do it
>>>
>>>Sub RenameSheetTo()
>>>
>>>Dim lng As Long
>>>For lng = 1 To ActiveSheet.Cells(Rows.Count, 1).End(xlUp).Row
>>>ThisWorkbook.Worksheets(Cells(lng, 1).Value).Name = ...more
>>>
>>>
>>>"Amit Desai (MERU)"  Nov 13 09:34PM +0530
>>>
>>>Thanks...this helps changing the name of sheet all at once...but..I
>>>need 3 things,
>>>
>>>
>>>1) List the names of work sheet in one black sheet of the file,
>>>
>>>2) Change the name of worksheet all ...more
>>>
>>>
>>>Sam Mathai Chacko  Nov 13 11:01PM +0530
>>>
>>>Would it be OK if you had to click 3 buttons for that?
>>>
>>>Macro used
>>>
>>>Option Explicit
>>>
>>>Sub GetListOfSheets()
>>>
>>>Dim lng As Long
>>>For lng = 1 To Sheets.Count
>>>If lng <> ...more
>>>
>>>
>>>"Amit Desai (MERU)"  Nov 14 12:21AM +0530
>>>
>>>Thanks.. but I am getting some error..
>>>
>>>While renaming, I am getting an error "500" & some time "out of
>>>range".
>>>
>>>
>>>Where should I paste the data for newssheet name?
>>>   

Re: $$Excel-Macros$$ Open Worksheet if Filepath verified

[Sam Mathai Chacko]

And for that you could use ENVIRON$("USERNAME")

Regards,
Sam

On Mon, Nov 14, 2011 at 6:58 PM, Paul Schreiner wrote:

> If you want to tie it to the WORKSTATION, then here's what I'd suggest:
>
> First, send him a file that contains the macro:
>
> Sub auto_open()
> If (Sheets(1).Range("A1").Value = "") Then Range("A1").Value =
> Environ$("computername")
> End Sub
>
> and have him save it and return it to you
> (that will give you his workstation "computer name")
>
> then,
>
> in your file, create an Auto_Open macro
> or a Workbook_Open event macro and use something like:
>
> If (Environ$("computername") = "xxx") Then
> Sheets(3).Visible = True
> Sheets(4).Visible = True
> End If
>
> Now, if you want it to run as long as it's HIM, regardless of the
> workstation, then
> you could do something similar with his userid.
>
>
> *Paul*
>
> -
> *“Do all the good you can,
> By all the means you can,
> In all the ways you can,
> In all the places you can,
> At all the times you can,
> To all the people you can,
> As long as ever you can.” - John Wesley
> *-
>
>
>  --
> *From:* TAschefler 
> *To:* MS EXCEL AND VBA MACROS 
> *Sent:* Mon, November 14, 2011 8:49:44 AM
>
> *Subject:* $$Excel-Macros$$ Open Worksheet if Filepath verified
>
> I have an excel file that I want to give to an employee that will only
> run if it is on their computer. I am looking for a macro that would
> show perhaps an introduction page and if the file name/path matches
> maybe a cell on the introduction page then it will unhide the (3
> sheets) that the employees needs.  Any help will be appreciated.
> Thanks.
>
> --
> FORUM RULES (934+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5)  Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE  : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> --
> FORUM RULES (934+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>



-- 
Sam Mathai Chacko

-- 
FORUM RULES (934+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ Open Worksheet if Filepath verified

[Paul Schreiner]

If you want to tie it to the WORKSTATION, then here's what I'd suggest:

First, send him a file that contains the macro:

Sub auto_open()
    If (Sheets(1).Range("A1").Value = "") Then Range("A1").Value = 
Environ$("computername")
End Sub

and have him save it and return it to you
(that will give you his workstation "computer name")

then,

in your file, create an Auto_Open macro
or a Workbook_Open event macro and use something like:

If (Environ$("computername") = "xxx") Then
    Sheets(3).Visible = True
    Sheets(4).Visible = True
End If


Now, if you want it to run as long as it's HIM, regardless of the workstation, 
then
you could do something similar with his userid.

Paul
-
“Do all the good you can,
By all the means you can,
In all the ways you can,
In all the places you can,
At all the times you can,
To all the people you can,
As long as ever you can.” - John Wesley
-





From: TAschefler 
To: MS EXCEL AND VBA MACROS 
Sent: Mon, November 14, 2011 8:49:44 AM
Subject: $$Excel-Macros$$ Open Worksheet if Filepath verified

I have an excel file that I want to give to an employee that will only
run if it is on their computer. I am looking for a macro that would
show perhaps an introduction page and if the file name/path matches
maybe a cell on the introduction page then it will unhide the (3
sheets) that the employees needs.  Any help will be appreciated.
Thanks.

-- 
FORUM RULES (934+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 


NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--

To post to this group, send email to excel-macros@googlegroups.com

-- 
FORUM RULES (934+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ Open Worksheet if Filepath verified

[dguillett1]

Be advised that this approach would only prevent "Aggies" or people who 
don't know how to use excel, from seeing all sheets even if protected with 
VERYhidden thru code. Suggest each have their own workbook and you get data 
as needed from it thru a macro.




Don Guillett
SalesAid Software
dguille...@gmail.com
-Original Message- 
From: TAschefler

Sent: Monday, November 14, 2011 7:49 AM
To: MS EXCEL AND VBA MACROS
Subject: $$Excel-Macros$$ Open Worksheet if Filepath verified

I have an excel file that I want to give to an employee that will only
run if it is on their computer. I am looking for a macro that would
show perhaps an introduction page and if the file name/path matches
maybe a cell on the introduction page then it will unhide the (3
sheets) that the employees needs.  Any help will be appreciated.
Thanks.

--
FORUM RULES (934+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please 
Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will 
not get quick attention or may not be answered.


2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security 
measure.


4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited.


NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.


--
To post to this group, send email to excel-macros@googlegroups.com 


--
FORUM RULES (934+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 


NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ Abridged summary of excel-macros@googlegroups.com - 20 Messages in 7 Topics

[sanju kanery]

Hi,

Can anybody help me with macros for mass mailing from given list of email
id's with select data from data sheet.

Rgds

Sanju Kanery

On Mon, Nov 14, 2011 at 5:12 AM,  wrote:

>   Today's Topic Summary
>
> Group: http://groups.google.com/group/excel-macros/topics
>
>- Listing name of worksheet & renaming 
> them<#1339f4f3fa0b83ff_group_thread_0>[7 Updates]
>- PDF to Excel <#1339f4f3fa0b83ff_group_thread_1> [2 Updates]
>- To Set Dropdownlist in Chart <#1339f4f3fa0b83ff_group_thread_2> [5
>Updates]
>- Macro-coding required <#1339f4f3fa0b83ff_group_thread_3> [2 Updates]
>- Import PDF into Excel <#1339f4f3fa0b83ff_group_thread_4> [2 Updates]
>- MS-Excel Hanging <#1339f4f3fa0b83ff_group_thread_5> [1 Update]
>- SUM Reg. <#1339f4f3fa0b83ff_group_thread_6> [1 Update]
>
>   Listing name of worksheet & renaming 
> them
>
>"Amit Desai (MERU)"  Nov 13 01:36PM +0530
>
>Dear Master,
>
>I have an excel file with sheet names ranging from A to V. However I
>want to change its sequence post changing its name.
>
>Do we have any shortcut?
>
>Regards,
>Amit Desai ...more
>
>
>Aindril De  Nov 13 02:03PM +0530
>
>Pl chk this,
>
>http://support.microsoft.com/kb/812386
>
>Cheers,
>Andy
>
>On Sun, Nov 13, 2011 at 1:36 PM, Amit Desai (MERU)
>
>--
>...more
>
>
>"Amit Desai (MERU)"  Nov 13 02:20PM +0530
>
>Thanks.. this helped me in arranging it..but how to list & rename it..
>say..Sheet A to become C, R to become S etc...
>
>Regards,
>Amit Desai
>AM - MIS Corporate
>Meru Cabs Company Pvt.Ltd
>Mumbai ...more
>
>
>Sam Mathai Chacko  Nov 13 06:28PM +0530
>
>Here's how you can do it
>
>Sub RenameSheetTo()
>
>Dim lng As Long
>For lng = 1 To ActiveSheet.Cells(Rows.Count, 1).End(xlUp).Row
>ThisWorkbook.Worksheets(Cells(lng, 1).Value).Name = ...more
>
>
>"Amit Desai (MERU)"  Nov 13 09:34PM +0530
>
>Thanks...this helps changing the name of sheet all at once...but..I
>need 3 things,
>
>
>1) List the names of work sheet in one black sheet of the file,
>
>2) Change the name of worksheet all ...more
>
>
>Sam Mathai Chacko  Nov 13 11:01PM +0530
>
>Would it be OK if you had to click 3 buttons for that?
>
>Macro used
>
>Option Explicit
>
>Sub GetListOfSheets()
>
>Dim lng As Long
>For lng = 1 To Sheets.Count
>If lng <> ...more
>
>
>"Amit Desai (MERU)"  Nov 14 12:21AM +0530
>
>Thanks.. but I am getting some error..
>
>While renaming, I am getting an error "500" & some time "out of range".
>
>
>Where should I paste the data for newssheet name?
>...more
>
>   PDF to Excel
>
>sharad jain  Nov 13 09:14PM +0530
>
>Hi All,
>
>I have PDF containing record of more 200 companies and running into 35
>pages into the form of table.
>
>I am using the free version of PDF.
>
>Is there any way that I can import the table ...more
>
>
>Sam Mathai Chacko  Nov 13 09:25PM +0530
>
>If it is not for very many pdf files, a converter could be used like
>the
>one here
>
>http://www.pdftoexcelonline.com/
>
>Regards,
>
>Sam
>
>
>--
>Sam Mathai Chacko
>...more
>
>   To Set Dropdownlist in 
> Chart
>
>kurikkal padinjarappalla  Nov 13 01:07PM
>+0300
>
>Dear All,
>
>Could somebody help me by setting a drop down list for creating chart,
>as
>if I select a particular client name in drop down list it should
>appear the
>chart of that particular client.
>...more
>
>
>Sam Mathai Chacko  Nov 13 07:30PM +0530
>
>Can be done using named ranges. Hit CTRL+F3 to find out how I named two
>dynamic ranges for your data.
>
>The ClientData for example was made like so..
>...more
>
>
>"dguillett1"  Nov 13 08:35AM -0600
>
>See attached
>
>Don Guillett
>SalesAid Software
>dguille...@gmail.com
>
>From: kurikkal padinjarappalla
>Sent: Sunday, November 13, 2011 4:07 AM
>To: excel-macros@googlegroups.com ...more
>
>
>Sam Mathai Chacko  Nov 13 08:43PM +0530
>
>I'd recommend keeping the method safe by relying only on the source
>data.
>From that echelon, I'd suggest using COUNTA to pass the column index
>in the
>VLOOKUP argument, instead of referring to ...more
>
>
>kurikkal padinjarappalla  Nov 13 06:30PM
>+0300
>
>Excellent,
>
>Thanks you so much both of you,
>
>I am little confused about Mr.Sam's first solution due to its named
>ranges,
>its a new knowledge to me, I will try to understand.
>
>...more
>
>   Macro-coding 
> required
>
>santosh subudhi  Nov 13 01:36PM +0530
>
>Hi Group,
>
>Please help me with the coding i

$$Excel-Macros$$ Open Worksheet if Filepath verified

[TAschefler]

I have an excel file that I want to give to an employee that will only
run if it is on their computer. I am looking for a macro that would
show perhaps an introduction page and if the file name/path matches
maybe a cell on the introduction page then it will unhide the (3
sheets) that the employees needs.  Any help will be appreciated.
Thanks.

-- 
FORUM RULES (934+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ Excel VBA professional needed for a Project Work

[Divaker Pandey]

Hi Satish

Here is Divaker, you can contact to me on 9582060233.

Divaker pandey

On Mon, Oct 31, 2011 at 1:55 PM, satish
wrote:

> Dear Excel Gurus,
>
> I am free lance data analyst, I have set of excel templates to
> calculate the Savings and Overcharges. I would like to auto-maize the
> whole process using VBA and Macro. I would like to know the
> professional who can create the package ( Excel along with VBA  and
> Macro. Please leave your contact details along with
> Name
> Address
> Contact number
> Email Id etc.
> I will send you the full description of the project work along with
> Tender list. Please quote your fee & duration for developing  the
> project
> work.
> You can send you contact details in below email id.
> skanda...@hotmail.com
> Kind Regards
> SATISH KUMAR.
>
> --
> FORUM RULES (925+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5)  Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE  : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>

-- 
FORUM RULES (934+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ get all the datas or selected datas in different work sheets in to one sheet

[dguillett1]

You can also use this
‘===
option explicit
Sub copyallsheetstoonesheet()
Dim sc As Long
Dim i As Long
sc = Sheets.Count
Sheets.Add after:=Sheets(sc)
ActiveSheet.Name = "Summary"
For i = 1 To k
Sheets(i).UsedRange.Offset(1).Copy Cells(Rows.Count, 1).End(xlUp).Offset(1)
Next i
Columns.AutoFit
End Sub
‘==
Don Guillett
SalesAid Software
dguille...@gmail.com

From: NOORAIN ANSARI 
Sent: Monday, November 14, 2011 10:21 AM
To: excel-macros@googlegroups.com 
Subject: Re: $$Excel-Macros$$ get all the datas or selected datas in different 
work sheets in to one sheet

Dear Smitha,

try through below Code...

Sub Merge_Data()
Dim i, j, k As Long
k = Sheets.Count
Sheets.Add after:=Sheets(Sheets.Count)
For i = 1 To k
Sheets(i).Select
j = 2
l = Sheets(i).Range("A65536").End(xlUp).Row
Rows(j & ":" & l).Copy
Sheets(Sheets.Count).Select
Sheets(Sheets.Count).Range("A65536").End(xlUp).Offset(1, 0).Select
ActiveSheet.Paste
Next i
End Sub



On Mon, Nov 14, 2011 at 1:47 PM, smitha.kumari  
wrote:

  I need help on:



  Want to get all the datas or selected datas in different work sheets in to 
one sheet in the same work book.

  Please suggest any formula.



  Regards

  Smitha 



  -- 
  FORUM RULES (934+ members already BANNED for violation)
   
  1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
   
  2) Don't post a question in the thread of another member.
   
  3) Don't post questions regarding breaking or bypassing any security measure.
   
  4) Acknowledge the responses you receive, good or bad.
   
  5) Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 
   
  NOTE : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
   
  
--
  To post to this group, send email to excel-macros@googlegroups.com




-- 

Thanks & regards,
Noorain Ansari
http://excelmacroworld.blogspot.com/
http://noorain-ansari.blogspot.com/

-- 
FORUM RULES (934+ members already BANNED for violation)
 
1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
 
2) Don't post a question in the thread of another member.
 
3) Don't post questions regarding breaking or bypassing any security measure.
 
4) Acknowledge the responses you receive, good or bad.
 
5) Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
 
--
To post to this group, send email to excel-macros@googlegroups.com

-- 
FORUM RULES (934+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

$$Excel-Macros$$ !!!JOB!!

[NOORAIN ANSARI]

  **


   *Experience:* 2 - 7 Years
*Location:* Gurgaon
*Education:* UG - Any Graduate - Any Specialization PG - Any PG Course -
Any Specialization
*Industry Type:* BPO/ITES
*Role:* Associate/Sr. Associate -(NonTechnical)
*Functional Area:*

ITES/BPO/KPO, Customer Service, Ops.
*Posted Date:* 11 Nov
 Job Description

•This is a workforce management position responsible exclusively for MIS
Team

•The candidate would be expected to train new hires at Band 4 on excel

•The candidate would be expected to automate reports by designing macros
and work with Band 6 to optimize the WFM MIS Team

•The candidate would be expected to become backup of Team Leader

•The candidate would be expected to stretch for meeting business
requirements


*Keywords:* WFM,work force management
Desired Candidate Profile

•Strong interpersonal skills, verbal and written communication skills.

•Excellent numerical and analytical ability.

•Excellent knowledge of Avaya CMS, Excel, Powerpoint, Scripting and Macros.

•Knowledge of HTML and Software Development is desired.


Company Profile
IBM Global Process Services (formerly IBM Daksh)provide solutions across
various verticals such as Banking, Insurance, Travel,
Telecom, Technology, Distribution, and Utilities. Our core expertise lies
in Customer Relationship Management (CRM),Finance &
Administration (F&A), Procurement & Supply Chain Outsourcing,Human
Resources Outsourcing, and Industry-specific Back Office and
Analytics services. Contact Details
 *Company Name:* IBM Daksh Business Process Services (P) Ltd.
*Website:* Not Mentioned
*Executive Name:* Prachi Bagade
*Address:*

IBM Daksh Business Process Services (P) Ltd
'D1' Manyata Embassy Business Park Block D, Off
Indranagar Koramanagala Intermediate Ring Road
BANGALORE,Karnataka,India 560071
*Email Address:* prachibagad...@in.daksh.com
*Telephone:* 91-80-41774000
*Reference ID:* SME WFM


-- 
Thanks & regards,
Noorain Ansari
 *http://excelmacroworld.blogspot.com/*
*http://noorain-ansari.blogspot.com/* 

-- 
FORUM RULES (934+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ Calling multiple type subroutines

[Jack]

Thank you for the reply.

I guess I do have a bit of a wrench in the whole system. It does in
fact have a formula in B3 because it is pulling the answer from
another worksheet. It is a simple IF THEN statement, but nonetheless,
it is a formula. Is there a completely different approach I should be
trying?

Regards,

Jack

On Nov 11, 1:16 pm, "Asa Rossoff"  wrote:
> Hi Jack,
>
> Glad to help.
>
> Here's a corrected version of your Worksheet_Change event.  As you have it
> now, I don't see how it will ever hide/unhide rows, as that If statement
> will always test as False.  (Since Target.Address won't be exactly "B3" no
> matter what).  Your Worksheet_Calculate routine has nothing to do with that,
> at least.
>
> Private Sub Worksheet_Change(ByVal Target As Range)
>
> With Range("B3")
>
>     If Not Application.Intersect(.Cells, Target) Is Nothing Then
>
>         Select Case .Value
>
>         Case Is = "DSL-Cleaner"
>
>             Rows("1:156").Hidden = False
>
>             Rows("157:208").Hidden = True
>
>             Rows("209:256").Hidden = False
>
>         Case Is = "DSN-DSL Cleaner"
>
>             Rows("1:256").Hidden = False
>
>         End Select
>
>     End If
>
> End With
>
> End Sub
>
> Be aware that VBA is case-sensitive by default, so the value in cell B3 will
> have to have the upper and lower case exactly as you specified.  If that's a
> problem, you could use:
>
> Select Case LCase(.Value)
>
> Case Is = "dsl-cleaner"
>
>     . . . .
>
> Case Is = "dsn-dsl cleaner"
>
>     . . . .
>
> End Select
>
> As written, the only way rows 157:208 will be unhidden by this routine is if
> the value changes to "DSN-DSL Cleaner".  If it changes to anything else,
> those rows will remain hidden since your routine does nothing for values
> other than these two.  If you want something to happen for all other values,
> you can use
>
> Case Else
>
> In your Select.Case statement.
>
> 
>
> Again, though, be aware that this code will not work as expected if cell B3
> contains a formula.  Worksheet_Change does not respond to formulas changing
> values.
>
> It's confusing that you have two event routines dependent on the value of
> cell B3.  One, Worksheet_Change, can only work if there is not a formula in
> B3, and the other, Worksheet_Calculate, will only happen at the time of a
> change of value in cell B3 if B3 DOES contain a formula.
>
> If you want both of these things to happen when the value of cell B3
> changes, both routines need to be in the same event; the Calculate event if
> it's a formula, or the Change event otherwise.
>
> Asa
>
>
>
>
>
>
>
> -Original Message-
> From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
>
> On Behalf Of Jack
> Sent: Friday, November 11, 2011 8:54 AM
> To: MS EXCEL AND VBA MACROS
> Subject: Re: $$Excel-Macros$$ Calling multiple type subroutines
>
> Thanks for the replying guys.
>
> Asa
>
> I'm still slightly confused on how to deploy the Select Case Range
>
> option that you suggested.
>
> Sam
>
> Great effort. However, due the fact that the picture subroutine was
>
> written in a Worksheet_Change routine, the Worksheet Calculate negates
>
> it ability to change the pictures. So none of my pictures appeared. Am
>
> I missing anything else to make this execute?
>
> Regards,
>
> Jack
>
> On Nov 11, 10:16 am, Sam Mathai Chacko  wrote:
>
> > I believe you can merge it like this
>
> > Private Sub Worksheet_Change(ByVal Target As Range)
>
> >     Dim oPic As Picture
>
> >     If Target.Address = "B3" Then
>
> >         Select Case Target.Value
>
> >             Case Is = "DSL-Cleaner"
>
> >                 Rows("1:156").Hidden = False
>
> >                 Rows("157:208").Hidden = True
>
> >                 Rows("209:256").Hidden = False
>
> >             Case Is = "DSN-DSL Cleaner"
>
> >                 Rows("1:256").Hidden = False
>
> >         End Select
>
> >         Me.Pictures.Visible = False
>
> >         With Target
>
> >             For Each oPic In Me.Pictures
>
> >                 If oPic.Name = .Text Then
>
> >                     oPic.Visible = True
>
> >                     oPic.Top = .Top
>
> >                     oPic.Left = .Left
>
> >                     Exit For
>
> >                 End If
>
> >             Next oPic
>
> >         End With
>
> >     End If
>
> > End Sub
>
> > Regards,
>
> > Sam Mathai Chacko
>
> > On Fri, Nov 11, 2011 at 1:57 PM, Asa Rossoff  wrote:
>
> > > Hi Jack,
>
> > > ** **
>
> > > Does cell B3 contain a formula or are you entering a value directly?
>
> > > ** **
>
> > > The Worksheet_Change event is triggered by changes that result from
> direct
>
> > > entry.
>
> > > The Worksheet_Calculate event is triggered by worksheet calculation.  If
>
> > > there is a formula in B3, it will never be the "Target" in a
>
> > > Worksheet_Change event, although any time it's resultant value changes
> (and
>
> > > even more often than that, most likely), you would get a
>
> > > Worksheet_Calcu

Re: $$Excel-Macros$$ Listing name of worksheet & renaming them

[Sam Mathai Chacko]

Amit, I do not know which file you are using it on, so I cannot be sure,
but the code should work if you can MOVE the entire Sorter sheet from my
attachment to your workbook, and ideally make it the very first sheet. If
you are still not able to get it to work, you might have to share your
actual workbook.

Regards,
Sam

On Mon, Nov 14, 2011 at 6:17 AM, Amit Desai (MERU)
wrote:

> Dear Sam,
>
> Its working in the excel file attached..but its not working in other file
> how should I do..
>
> The modified script is as below, is it correct?
>
> Sub GetListOfSheets()
>
>Dim lng As Long
> Worksheets("..Sorter..").UsedRange.ClearContents
> For lng = 1 To Sheets.Count
>If lng <> Worksheets("..Sorter..").Index Then
>Cells(lng, 1).Value = Sheets(lng).Name
>End If
>Next lng
>
> End Sub
>
> -Original Message-
> From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
> On Behalf Of Sam Mathai Chacko
> Sent: 14 November 2011 07:00
> To: excel-macros@googlegroups.com
> Subject: Re: $$Excel-Macros$$ Listing name of worksheet & renaming them
>
> There is a sheet by the name ..Sorter..
> In the first column of the sheet you can get the list of all sheets in
> the workbook by clicking on the first button. in the next column, you
> have to type the new names of those sheets. then click on the 2nd and
> 3rd buttons.
>
> I could have added a line in the first routine to clear all cells in
> the sorter sheet just to ensure there are no names of sheets the do
> not exist. you can add that line in the first sub-routine
>
> Worksheets("..Sorter..").UsedRange.ClearContents
>
> Sam
>
> On 14/11/2011, Amit Desai (MERU)  wrote:
> > Thanks.. but I am getting some error..
> >
> > While renaming, I am getting an error "500" & some time "out of range".
> >
> >
> > Where should I paste the data for newssheet name?
> >
> > From: excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com]
> > On Behalf Of Sam Mathai Chacko
> > Sent: 13 November 2011 23:02
> > To: excel-macros@googlegroups.com
> > Subject: Re: $$Excel-Macros$$ Listing name of worksheet & renaming them
> >
> > Would it be OK if you had to click 3 buttons for that?
> >
> > Macro used
> >
> > Option Explicit
> >
> > Sub GetListOfSheets()
> >
> > Dim lng As Long
> > For lng = 1 To Sheets.Count
> > If lng <> Worksheets("..Sorter..").Index Then
> > Cells(lng, 1).Value = Sheets(lng).Name
> > End If
> > Next lng
> >
> > End Sub
> >
> > Sub RenameSheetTo()
> >
> > Dim lng As Long
> > For lng = 1 To ActiveSheet.Cells(Rows.Count, 1).End(xlUp).Row
> > If Trim(Cells(lng, 1).Value) <> "" And lng <>
> > Worksheets("..Sorter..").Index Then
> > ThisWorkbook.Sheets(CStr(Cells(lng, 1).Value)).Name =
> > Left(Cells(lng, 2).Value, 31)
> > End If
> > Next lng
> >
> > End Sub
> >
> > Sub SortSheets()
> >
> > Dim lCount As Long, lCounted As Long, lCount2 As Long
> > Dim lShtLast As Long
> > Dim lReply As Long
> >
> > lReply = MsgBox("To sort Worksheets ascending, select 'Yes'. To sort
> > Worksheets descending select 'No'", vbYesNoCancel, "Ozgrid Sheet Sort")
> > If lReply = vbCancel Then Exit Sub
> > lShtLast = Sheets.Count
> > If lReply = vbYes Then 'Sort ascending
> > For lCount = 1 To lShtLast
> > For lCount2 = lCount To lShtLast
> > If UCase(Sheets(lCount2).Name) <
> UCase(Sheets(lCount).Name)
> > Then
> > Sheets(lCount2).Move Before:=Sheets(lCount)
> > End If
> > Next lCount2
> > Next lCount
> > Else 'Sort descending
> >  For lCount = 1 To lShtLast
> > For lCount2 = lCount To lShtLast
> > If UCase(Sheets(lCount2).Name) >
> UCase(Sheets(lCount).Name)
> > Then
> > Sheets(lCount2).Move Before:=Sheets(lCount)
> > End If
> > Next lCount2
> > Next lCount
> > End If
> >
> > End Sub
> >
> > The Sort macro was copied from Ozgrid
> > http://www.ozgrid.com/VBA/sort-sheets.htm
> >
> > Regards,
> > Sam Mathai Chacko
> > On Sun, Nov 13, 2011 at 9:34 PM, Amit Desai (MERU)
> > mailto:amit.de...@merucabs.com>> wrote:
> > Thanks...this helps changing the name of sheet all at once...but..I need
> 3
> > things,
> >
> >
> > 1)  List the names of work sheet in one black sheet of the file,
> >
> > 2)  Change the name of worksheet all at once (have a macro),
> >
> > 3)  Arrange the worksheet either alphabetically or as needed (have a
> > macro)...
> >
> > Can you all please provide one in all macro for all above task?
> >
> > From: excel-macros@googlegroups.com >
> >
> [mailto:excel-macros@googlegroups.com >]
> > On Behalf Of Sam Mathai Chacko
> > Sent: 13 November 2011 18:29
> >
> > To: excel-macros@googlegroups.com
> 

Re: $$Excel-Macros$$ Need help on Micro Button!!!!!!!!!!!!!!!!!!!

[Sam Mathai Chacko]

Use this code in Sheet1 VBA code module

Private Sub CommandButton1_Click()
ActiveSheet.Range("B4:B32").EntireRow.Hidden = Not
ActiveSheet.Range("B4:B32").EntireRow.Hidden

End Sub
Private Sub CommandButton2_Click()
ActiveSheet.Range("B35:B50").EntireRow.Hidden = Not
ActiveSheet.Range("B35:B50").EntireRow.Hidden

End Sub
Private Sub CommandButton3_Click()
ActiveSheet.Range("B53:B69").EntireRow.Hidden = Not
ActiveSheet.Range("B53:B69").EntireRow.Hidden

End Sub
Private Sub CommandButton4_Click()
ActiveSheet.Range("B72:B88").EntireRow.Hidden = Not
ActiveSheet.Range("B72:B88").EntireRow.Hidden

End Sub

Regards,
Sam

On Mon, Nov 14, 2011 at 4:17 PM, jocky Beta  wrote:

>
> HI Team,
>
>I had created one sheet in which  i made the Groups Now i want to link
> the Buttons which i created in the sheet (When i click the Button it should
> expand the group and wen again click the button it needs to be close).
>
> Please help me on this
>
> *
> *
> *Regards,*
> *Jocky*
>
> --
> FORUM RULES (934+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>



-- 
Sam Mathai Chacko

-- 
FORUM RULES (934+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com


Toggle Range Hide Unhide.xlsm
Description: Binary data

$$Excel-Macros$$ Need help on Micro Button!!!!!!!!!!!!!!!!!!!

[jocky Beta]

HI Team,

   I had created one sheet in which  i made the Groups Now i want to link
the Buttons which i created in the sheet (When i click the Button it should
expand the group and wen again click the button it needs to be close).

Please help me on this

*
*
*Regards,*
*Jocky*

-- 
FORUM RULES (934+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com


Micor Button.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Re: $$Excel-Macros$$ get all the datas or selected datas in different work sheets in to one sheet

[dguillett1]

More detail and/or attach file(s)

Don Guillett
SalesAid Software
dguille...@gmail.com

From: smitha.kumari 
Sent: Monday, November 14, 2011 2:17 AM
To: excel-macros@googlegroups.com 
Subject: $$Excel-Macros$$ get all the datas or selected datas in different work 
sheets in to one sheet

I need help on:

 

Want to get all the datas or selected datas in different work sheets in to one 
sheet in the same work book.

Please suggest any formula.

 

Regards

Smitha 

 

-- 
FORUM RULES (934+ members already BANNED for violation)
 
1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
 
2) Don't post a question in the thread of another member.
 
3) Don't post questions regarding breaking or bypassing any security measure.
 
4) Acknowledge the responses you receive, good or bad.
 
5) Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
 
--
To post to this group, send email to excel-macros@googlegroups.com

-- 
FORUM RULES (934+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ Required Progres bar / Status bar while macro runinng....

[dguillett1]

Attach your file with a reply to this msg.

Don Guillett
SalesAid Software
dguille...@gmail.com

From: maulik desai 
Sent: Sunday, November 13, 2011 10:31 AM
To: excel-macros@googlegroups.com 
Subject: $$Excel-Macros$$ Required Progres bar / Status bar while macro 
runinng

Hi Team,

I having 1 excel sheet in that i have apply below Sumproduct macro code 72 
times to get output on my database (This code is provided by Daniel of this 
group ) my But my problem is it take about 20 to 30 mins to run the code total 
550 row(not fixed) x 72 columns ) what I want that can i get a progress bar 
which shows me status like " 3 outof 72 columns completed" or 10%,15% ,30% 
completed like that

also if can help to reduce the code size to work faster 
Please find below code provided by Mr.Daniel of this group.

Thanks in advance
 

Here is an example to replace sheet Batch column K with a macro:



Sub test()

'sheet Batch column K

With Sheets("Batch")

For Each c In .Range(.[A7], .[A65536].End(xlUp))

.Cells(c.Row, 11) = Evaluate("sumproduct((DB!$A$2:$A$46803=Batch!$A" & c.Row & 
")*(DB!$AP$2:$AP$46803=""Yes""))")

Next c

End With

End Sub



You should run the macro each time you change, add or delete a value in column 
A; place the following macro in the sheet module :

Private Sub Worksheet_Change(ByVal Target As Range)

If Target.Column = 1 And Target.Row > 6 Then

Cells(Target.Row, 11) = Evaluate("sumproduct((DB!$A$2:$A$46803=Batch!$A" _

& Target.Row & ")*(DB!$AP$2:$AP$46803=""Yes""))")

End If

End Sub



You’ll have to do the same for others formulas.

Regards.

Daniel



De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De la 
part de maulik desai
Envoyé : mardi 22 février 2011 18:55
À : excel-macros@googlegroups.com
Objet : $$Excel-Macros$$ How to use sumproduct Formula in Macro



I having Database with 4Sheets and i have used Sumproduct Formula in many 
Columns in my database. i have apply the formulas on every columns but the 
prolem is the file becomes very heavy & it take to much time to give the output

is there any way to use the samproduct function with the help of macro 



sample file attached i am having large database 



Request you to kindly provide the solution for the same

-- 
Thanks & Regards,
Maulik Desai
9967363926

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

To post to this group, send email to excel-macros@googlegroups.com
 
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

To post to this group, send email to excel-macros@googlegroups.com
 
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel




-- 
Thanks & Regards,
Maulik Desai
9967363926
-- 
FORUM RULES (934+ members already BANNED for violation)
 
1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
 
2) Don't post a question in the thread of another member.
 
3) Don't post questions regarding breaking or bypassing any security measure.
 
4) Acknowledge the responses you receive, good or bad.
 
5) Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
 
--
To post to this group, send email to excel-macros@googlegroups.com

-- 
FORUM RULES (934+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receiv

Re: $$Excel-Macros$$ How to embed an Outlook mail into excel

[deepu]

Well, I don't think you're on right way..If you'll look at the code
which I'd posted earlier, you'll find it is very easy to do so...

Previous Code..

Sheets("Sheet1").OLEObjects.Add(Filename:="C:\Sample.oft",
DisplayAsIcon:=True, IconFileName:="packager.exe", IconIndex:=0,
IconLabel:="Sample").Select

You can just provide the application path of the Outlook in
IconFileName...Also you can change the IconIndex number, because this
exe file contains more than 1 icons...Look at the following code...

Sheets("Sheet1").OLEObjects.Add(Filename:="C:\Sample.oft",
DisplayAsIcon:=True, IconFileName:="C:\Program Files\Microsoft Office
\Office12\OUTLOOK.EXE", IconIndex:=0,
IconLabel:="Sample").Select

Regards
Deepak


On Nov 14, 5:06 pm, "sreejith k.s"  wrote:
> hi friend,
>
> i dont think that you can insert the outlook email icon while
> inserting it as an object, rather you can insert in the form of an
> object.
>
> for that follow these steps.
>
> Select Insert
>           object
>          Create from file .
>
> Check the box ' Display as icon'
>
> hope you would get an better solution than this.
>
> regards
> Sreejit
>
> On 11/14/11, Prathap  wrote:
>
>
>
> > HI All,
>
> > I`m trying to embed the Outlook mail into a cell in Microsoft excel (2010)
> > through Insert object. However after embedding, object is not showing the
> > outlook icon   rather than dispalying as blank object. Attached is the
> > sample file.
>
> > Best Regards,
> > PRATHAP D
>
> > --
> > FORUM RULES (934+ members already BANNED for violation)
>
> > 1) Use concise, accurate thread titles. Poor thread titles, like Please
> > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
> > not get quick attention or may not be answered.
>
> > 2) Don't post a question in the thread of another member.
>
> > 3) Don't post questions regarding breaking or bypassing any security
> > measure.
>
> > 4) Acknowledge the responses you receive, good or bad.
>
> > 5)  Cross-promotion of, or links to, forums competitive to this forum in
> > signatures are prohibited.
>
> > NOTE  : Don't ever post personal or confidential data in a workbook. Forum
> > owners and members are not responsible for any loss.
>
> > ---­---
> > To post to this group, send email to excel-macros@googlegroups.com- Hide 
> > quoted text -
>
> - Show quoted text -

-- 
FORUM RULES (934+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ How to embed an Outlook mail into excel

[sreejith k.s]

hi friend,


i dont think that you can insert the outlook email icon while
inserting it as an object, rather you can insert in the form of an
object.

for that follow these steps.

Select Insert
  object
 Create from file .

Check the box ' Display as icon'


hope you would get an better solution than this.

regards
Sreejit


On 11/14/11, Prathap  wrote:
> HI All,
>
> I`m trying to embed the Outlook mail into a cell in Microsoft excel (2010)
> through Insert object. However after embedding, object is not showing the
> outlook icon   rather than dispalying as blank object. Attached is the
> sample file.
>
>
> Best Regards,
> PRATHAP D
>
> --
> FORUM RULES (934+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
> not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5)  Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE  : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>

-- 
FORUM RULES (934+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

$$Excel-Macros$$ get all the datas or selected datas in different work sheets in to one sheet

[smitha.kumari]

Hi, 

 

I need help on:

 

Want to get all the datas or selected datas in different work sheets in to
one sheet in the same work book.

Please suggest any formula.

 

Regards

Smitha 

 

-- 
FORUM RULES (934+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

$$Excel-Macros$$ Re: How to embed an Outlook mail into excel

[deepu]

Hi Prathap,

You can use the following code to embedd emails in an excel worksheet
as object...

Sheets("Sheet1").OLEObjects.Add(Filename:="C:\Sample.oft",
DisplayAsIcon:=True, IconFileName:="packager.exe", IconIndex:=0,
IconLabel:="Sample").Select

Regards
Deepak

On Nov 14, 2:59 pm, Prathap  wrote:
> HI All,
>
> I`m trying to embed the Outlook mail into a cell in Microsoft excel (2010)
> through Insert object. However after embedding, object is not showing the
> outlook icon   rather than dispalying as blank object. Attached is the
> sample file.
>
> Best Regards,
> PRATHAP D
>
>  Sample.xlsx
> 25KViewDownload

-- 
FORUM RULES (934+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

$$Excel-Macros$$ Re: Email Macro required for mail Boday

[deepu]

Hi Maulik,

Below is the code that you're looking for...
Insert a module in your workbook and paste the following code and run
it...

---
Dim MyArray() As Variant, ListArray() As Variant
Dim R As Long, C As Integer, LastRow As Long, i As Long
Dim OutObj As Object, EmailObj As Object, EmailBody As String, RecAdd
As String
Sub PrepareData()
'Assigning values to MyArray
LastRow = Sheet1.Range("A6").End(xlUp).Row
MyArray = Sheet1.Range("A7:G" & LastRow).Value

'Assigning values to ListArray
LastRow = Sheet1.Range("K6").End(xlUp).Row
ListArray = Sheet1.Range("K7:M" & LastRow).Value

For i = LBound(ListArray) To UBound(ListArray)
RecAdd = ListArray(i, 3)
EmailBody = "Hi " &
Application.WorksheetFunction.Proper(ListArray(i, 2)) & ",FYI..." & _
"" & _
"Customer Name" & _
"Location" & _
"Date" & _
"Site" & _
"Status" & _
""

For R = LBound(MyArray) To UBound(MyArray)
If ListArray(i, 1) = MyArray(R, 6) Then
For C = 1 To 5
EmailBody = EmailBody & "" & _
"" & MyArray(R, 1) & "" & _
"" & MyArray(R, 2) & "" & _
"" & MyArray(R, 3) & "" & _
"" & MyArray(R, 4) & "" & _
"" & MyArray(R, 5) & "" & _
""
Next C
End If
Next R
Call SendEmail(RecAdd, EmailBody)
Next i
End Sub

Sub SendEmail(ReceiptAdd As String, EBody As String)
Set OutObj = CreateObject("Outlook.Application.12")
Set EmailObj = OutObj.CreateItem(0)

EmailBody = EmailBody & "" & _
"RegardsXYZ"

With EmailObj
.To = ReceiptAdd
.Subject = "Your Channels Data"
.HTMLBody = EmailBody
.Send
End With

End Sub
---

Hope you'd like it.. Kindly contact to me if you face any problem...

Regards
Deepak

On Nov 13, 10:00 pm, maulik desai  wrote:
> Hi Team,
>
> I am having 1 excel sheet in that i have to prepare Chennel wise detail
> report on a every week & i have to send that information to respective
> chennel heads wia email ,
> Manually i need to do filter the data base on chennal name & then copy data
> from sheet & need to paste on mail body then i have to send the data to
> that chennel head based on chennel name.
>
> My problem is i have to do same excerside many times as chennel name are
> approxly 80
>
> Request you to kindly provide me the macro code witch can directly send the
> email based on chennel name (mail body format given in attched file ,sheet
> 2)
> Thanks in advance.
> --
> Thanks & Regards,
> Maulik Desai
> 9967363926
>
>  Customer Info.xls
> 33KViewDownload

-- 
FORUM RULES (934+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

$$Excel-Macros$$ How to embed an Outlook mail into excel

[Prathap]

HI All,

I`m trying to embed the Outlook mail into a cell in Microsoft excel (2010)
through Insert object. However after embedding, object is not showing the
outlook icon   rather than dispalying as blank object. Attached is the
sample file.


Best Regards,
PRATHAP D

-- 
FORUM RULES (934+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com


Sample.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Re: $$Excel-Macros$$ Indirect Formula - Need Advise

[Jayaprakash S]

Thanks Noorain,

sorry i had missed out your response...

for the first time i'm using this Indirect formula & with Adress or
other criterian... will you advise me bit more about Indirect & Adress
formulas usage ??with few exmples so that i can learn in detail ???

cheers

JP


On Fri, Nov 11, 2011 at 9:49 PM, NOORAIN ANSARI
 wrote:
> Dear JP,
>
> Please find attached sheet, I hope it will help to u..
> try..
>
> =VLOOKUP($A2,INDIRECT($G$3&"!A:D"),MATCH(B$1,AN!$A$1:$D$1,0),0)
> --
> Thanks & regards,
> Noorain Ansari
> http://excelmacroworld.blogspot.com/
> http://noorain-ansari.blogspot.com/
> On Fri, Nov 11, 2011 at 2:32 PM, Jayaprakash S 
> wrote:
>>
>> Dear Experts,
>>
>> To make a Summary, i'm using indirect formula and need your help &
>> advise to complete the same..
>>
>> Here with enclosed the example along with the issue.
>>
>> thank you.
>>
>> Jp
>>
>> --
>> FORUM RULES (934+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
>> not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5)  Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE  : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>
>
>
>
> --
> FORUM RULES (934+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
> not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>



-- 
Regards, Jayaprakash. S (JAYAPRAKASH. S.) Adaptability is the most
desirable habit for success - Swamy Vivekananda. This message is for
the designated recipient only and may contain privileged, proprietary,
or otherwise private information. If you have received it in error,
please notify the sender immediately and delete the original. Any other
use of the email by you is prohibited.

-- 
FORUM RULES (934+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ Seeking help small letters to capital letters

[Sanjib Chatterjee]

=UPPER(A1)


2011/11/10 ♥.•:*¨¨*:•.♥.•:V.Kiran Kumar :•.♥.•:*¨¨*:•.♥ <
vadnalaki...@gmail.com>

> Hi
>
> Anybody can help me out
> how to make small letter to capital letter in Ms excel
>
> V.Kiran
>
>
>  --
> FORUM RULES (934+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>



-- 
-

-- 
FORUM RULES (934+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

$$Excel-Macros$$ get all the datas or selected datas in different work sheets in to one sheet

[smitha.kumari]

I need help on:

 

Want to get all the datas or selected datas in different work sheets in to
one sheet in the same work book.

Please suggest any formula.

 

Regards

Smitha 

 

-- 
FORUM RULES (934+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com