Re: $$Excel-Macros$$ Send mail from outlook Every One Hr .

[Jayaprakash S]

Hi Vabs,

Sorry Was on leave...

I do not have any codes, so what ever you had given, i tried with it
and it is asking me to run the macro for sending e-mails... Instead i
want the codes : "When Pivot gets refreshed, Macro should run
automatically and send an e-mail if there is any change in the Pivot
Value (explained with an example in my previous attachement)

any possibility of helping me ??

Thanks in advance!

Cheers
JP.

On Tue, Nov 6, 2012 at 6:00 PM, Vabz  wrote:
> Hi
>
> Send file with your code.
>
> Rgds//Vabs
>
> On Tuesday, November 6, 2012 5:55:23 PM UTC+5:30, Jayaprakash S wrote:
>>
>> Hi Vabz,
>>
>> Nope, not giving the desired result... (attached the sample required
>> file for more info)
>>
>>
>> A) THIS PIVOT WILL GET AUTO REFRESHED (BASED ON GIVEN TIMINGS)
>> B) ANY CHANGES IN THE TOTAL SHOULD SEND E-MAIL @ ONLY ONCE ( EXMPL:
>> REFRESHED @ 9 :00 AM FOUND RAM : 200 AND AGAIN REFRESHED @ 9.20 AM AND
>> OUND RAM : 200 - THEN, MAIL TO BE SENT @ 9: AM BUT NOT @ 9.20 AM)
>> C) E-MAIL SHOULD BE OF AUTO GENERATED ONE WHICH IS BASED ON PIVOT
>> VALUES (TO SEND E-MAIL I SHOULD NOT RUN ANY MACROS OR PRESS ANY BUTTON
>> - AS AND WHEN PIVOT REFRESHES BASED ON ITS VALUE, IT SHOULD SHOOT AN
>> AUTO GENERATED E-MAIL.
>>
>> thank you.
>>
>> JP.
>>
>>
>> On Tue, Nov 6, 2012 at 5:20 PM, Vabz  wrote:
>> > Hi
>> >
>> > I have just tested & it workz..Pl update me form your end!!
>> >
>> > Rgds//Vabs
>> >
>> >
>> > On Tuesday, November 6, 2012 5:15:26 PM UTC+5:30, Vabz wrote:
>> >>
>> >> Hi
>> >>
>> >> Ignore earlier & consider this
>> >>
>> >> Sub email()
>> >> Dim myOutlook As Object
>> >> Dim myMailItem As Object
>> >> Dim FName As String
>> >> Application.Calculate ' Make sure NOW() has been updated
>> >>
>> >> Set otlApp = CreateObject("Outlook.Application")
>> >> Set otlNewMail = otlApp.CreateItem(olMailItem)
>> >> FName = ActiveWorkbook.Path & "\" & ActiveWorkbook.NAME
>> >> With otlNewMail
>> >> .To = "v...@vabs.in"
>> >> .CC = ""
>> >> .Subject = "Test"
>> >> .Body = "Test"
>> >> .Attachments.add FName
>> >> '.DeferredDeliveryTime = Range("A1")
>> >> .Send
>> >> End With
>> >> Application.OnTime Now + TimeValue("00:10:00"), "email"
>> >> Set otlNewMail = Nothing
>> >> Set otlApp = Nothing
>> >> Set otlAttach = Nothing
>> >> Set otlMess = Nothing
>> >> Set otlNSpace = Nothing
>> >> End Sub
>> >>
>> >>
>> >> On Tuesday, November 6, 2012 5:11:56 PM UTC+5:30, Vabz wrote:
>> >>>
>> >>> Hi
>> >>>
>> >>> Try this:
>> >>>
>> >>> Sub email()
>> >>> Dim myOutlook As Object
>> >>> Dim myMailItem As Object
>> >>> Dim FName As String
>> >>> Application.Calculate ' Make sure NOW() has been updated
>> >>>
>> >>> Set otlApp = CreateObject("Outlook.Application")
>> >>> Set otlNewMail = otlApp.CreateItem(olMailItem)
>> >>> FName = ActiveWorkbook.Path & "\" & ActiveWorkbook.NAME
>> >>> With otlNewMail
>> >>> .To = "v...@vabs.in"
>> >>> .CC = ""
>> >>> .Subject = "Test"
>> >>> .Body = "Test"
>> >>> .Attachments.add FName
>> >>> .DeferredDeliveryTime = Range("A1")
>> >>> .Send
>> >>> End With
>> >>> Application.OnTime Now + TimeValue("00:10:00"), "email"
>> >>> Set otlNewMail = Nothing
>> >>> Set otlApp = Nothing
>> >>> Set otlAttach = Nothing
>> >>> Set otlMess = Nothing
>> >>> Set otlNSpace = Nothing
>> >>> End Sub
>> >>>
>> >>>
>> >> This wll sent email every ten minutes
>> >> Rgds//vabs
>> >>
>> >>>
>> >>> On Tuesday, November 6, 2012 5:00:01 PM UTC+5:30, Jayaprakash S wrote:
>> 
>>  Dear Vabs,
>> 
>>  Thank you very much for spending your valuable time on my query...
>> 
>>  It is not giving me the required output... as it fails when :
>> 
>>  say for example :
>> 
>>  a) Refreshed @ 9.00 AM Data found as : 0
>> 
>>  b)Refreshed @ 9.10AM Data found as : Mr.Ram - 2
>> 
>>  c)Refreshed @ 9.20AM Data found as : Mr.Ram - 2
>> 
>>  in the above scence, @ 9 AM No e-mails as no Data and @ 9:10 AM
>>  E-mail
>>  to be sent and @ 9:20 AM again No E-mail as no change in the Value
>>  (also e-mail has already been sent @ 9.10 AM !!)
>> 
>>  Thank you.
>> 
>>  JP
>> 
>>  On Tue, Nov 6, 2012 at 4:13 PM, Vabz  wrote:
>>  > Hi
>>  >
>>  > This will help you:
>>  >
>>  > Sub email()
>>  > Dim myOutlook As Object
>>  > Dim myMailItem As Object
>>  > Dim FName As String
>>  > Set otlApp = CreateObject("Outlook.Application")
>>  > Set otlNewMail = otlApp.CreateItem(olMailItem)
>>  > FName = ActiveWorkbook.Path & "\" & ActiveWorkbook.NAME
>>  > With otlNewMail
>>  > .To = "v...@vabs.in"
>>  > .CC = ""
>>  > .Subject = "Test"
>>  > .Body = "Test"
>>  > .Attachments.add FName
>>  > .DeferredDeliveryTime = Range("A1")
>>  > .Send
>>  > End With
>>  >
>>  > Set otlNewMail = Nothing
>>  > Set otlApp = Nothing
>>  > Set otlAttach = Nothing
>>  > Set otlMess = Nothing
>>  > Set otlNSpace = Nothing
>>  > End Sub
>>  >
>>  >
>> 

$$Excel-Macros$$ Required tutorials to learn Basics of DashBoards.

[chhajersandeep]

Dear Excel Gurus,
Recently I have came to know about excel dashboard and its potential while 
presenting reports. Can any one send me some tutorials for the beginners like 
me.
Thanking you in advance.

Sandeep Chhajer.
Sent on my BlackBerry® from Vodafone

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ 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. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.

Re: $$Excel-Macros$$ Sum required from different sheet..

[Manoj Kumar]

Sorry for delay...

yes Pravin..

On Wed, Nov 7, 2012 at 6:42 PM, Pravin Gunjal  wrote:

> *you mean to say that the formula should be changed automatically,
> whenever you create a new sheet?
> *
>
> -- Forwarded message --
> From: Manoj Kumar 
> Date: Wed, Nov 7, 2012 at 2:05 PM
> Subject: Re: $$Excel-Macros$$ Sum required from different sheet..
> To: excel-macros@googlegroups.com
>
>
>
> Hi,
>
> Anybody please help me...
>
>
> Regard
> Manoj
>
>
> On Wed, Nov 7, 2012 at 12:53 PM, Manoj Kumar wrote:
>
>> Dear Expert,
>>
>> Please help me ...when I add new sheet ("3") it should be change like
>> that.."SUM('1:3'!B2)"
>>
>> Regard
>> Manoj
>>
>> --
>> Join official facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES (1120+ 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.
>>
>> 6) Jobs posting is not allowed.
>>
>> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "MS EXCEL AND VBA MACROS" group.
>> To post to this group, send email to excel-macros@googlegroups.com.
>> To unsubscribe from this group, send email to
>> excel-macros+unsubscr...@googlegroups.com.
>> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
>>
>>
>>
>
>  --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES (1120+ 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.
>
> 6) Jobs posting is not allowed.
>
> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
>
>
>
>  --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES (1120+ 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.
>
> 6) Jobs posting is not allowed.
>
> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
>
>
>

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ 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 m

$$Excel-Macros$$ Plz update my new mail id in this group and remove my old(current)id

[santosh subudhi]

Hello Group Manager,

Currently my mail id : santoshkumar.subu...@gmail.com
is registered with this group.

Would request you to remove my above email id and add my new mail id
santoshkumar.subu...@hotmail.com

Once done please let me know above the change.

Regards
Santosh
santoshkumar.subu...@gmail.com

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ 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. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.

$$Excel-Macros$$ Re: Chart stuff

[santosh subudhi]

Hello,

Can the graph in the attchment be modified as per the below table.

If so would request you to please help me with this

Group1  10%
Group2  20%
Group3  30%
Group4  15%
Group5  25%
Total   100%

Regards
Santosh
santoshkumar.subu...@gmail.com

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ 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. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.




ChartStuff(1).xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

$$Excel-Macros$$ Re: Urgent Client Positions ::: .Net Lead / .Net Developer -- Work Location : St. John’s, Newfoundland, Canada

[Ayush Jain]

This member is banned

-Ayush Jain



On Wednesday, 7 November 2012 20:49:35 UTC+5:30, sandeep reddy wrote:
>
> *Hi,*
>
> *This is Sandeep Representing SancroSoft USA Inc.*
>
> We have an urgent requirement as follows:
>
> Please respond with resumes in MS-Word Format with the following details 
> to *sand...@sancrosoftusa.com* 
>
> Full Name :
> Location :
> Contact Number :
> Email :
> Availability :
> Visa Status :
>
>  *Position 1:**
> .Net Lead*
> Work Location : St. John’s, Newfoundland, Canada.
> Position Type : Long-Term
>
> We need resource from Canada only
>
> *Project Leader*
> "Strong experience in architecting, designing & developing .NET, Web 
> Services, VSTS (6+ years in .NET, 2+ years in Web Services on a .NET 
> platform)
> Experience in Silverlight & Expressions blend  and WPF is a strongly 
> desired skill
> Experience in SQL / Queries / Stored Procedures on a SQL Server platform
> Must have led a team of 10-15 people on a .NET project, preferably in US, 
> Canada, Australia or UK
> Strong planning & tracking skills
> Excellent communications skills"
>
>
>
> --
>
> *Position 2:**
> Sr.Net Developer*
> Work Location : St. John’s, Newfoundland, Canada.
> Position Type : Long-Term
>
> We need resource from Canada only
>
>
> "Strong experience in designing & developing .NET applications (ASP.NET, 
> C#) (4+ years)
> Experience using Microsoft Visual Studio Team System 2010 with Team 
> Foundation server
> Can lead & direct 1-2 developers"
>
>   
>
> *Thanks & Regards*
>
>  
>
> *Sandeep *
>
> *[image: Description: Description: Description: Description: Description: 
> Description: Description: cid:image001.jpg@01CD14F0.B169F430] [image: 
> Description: Description: Description: Description: Description: 
> Description: Description: cid:image002.jpg@01CD14F0.B169F430] *
>
> * **The power of focus*
>
>  
>
> *SancroSoft USA INC*
>
> 4944 Sunrise Blvd, Suite B-4 || Fair Oaks, CA 95628
>
> Phone : 916-671-5575 || Fax: 916-200-0305
>
> E-Mail : sand...@sancrosoftusa.com  || www.sancrosoftusa.com
>
> We place professionals in contract, contract-to-hire and full-time 
> employment positions across all IT and Engineering disciplines, nationwide
>
>  
>
> The information contained in this email message is intended only for the 
> personal and confidential use of the recipient(s) named above. The message 
> may be privileged and confidential and protected from disclosure. If the 
> reader of this message is not the intended recipient or an agent 
> responsible for delivering it to the intended recipient, you are hereby 
> notified that you have received this document in error and that any review, 
> dissemination, distribution, copying of this message is strictly 
> prohibited. If you have received this communication in error, please notify 
> us immediately by email and delete the original message.
>  
>  
>

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ 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. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.

Re: $$Excel-Macros$$ Organization Chart

[Paul Schreiner]

can you send me your file?

I need to know what type of object you're using for the Org Chart.
 
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: ANKUR AGGARWAL 
To: "excel-macros@googlegroups.com" 
Cc: Paul Schreiner 
Sent: Wed, November 7, 2012 1:21:01 AM
Subject: Re: $$Excel-Macros$$ Organization Chart


Hi Paul,

Thanks for the reply. Its not allowing to record a macro, and if in case we are 
recording the macro, we cannot edit any node. 

Can you please recheck ?

Warm Regards
Ankur Aggarwal
91-8010614628
Analyst
Mckinsey Knowledge Center
Mckinsey & Co.



From: Paul Schreiner 
To: excel-macros@googlegroups.com 
Sent: Tuesday, 6 November 2012 7:10 PM
Subject: Re: $$Excel-Macros$$ Organization Chart


I took a look at your file.
It seems to have something to do with the type of image that was inserted.

I was able to double-click on the image, and a popup was presented allowing the
image to be converted to a Shape collection.

Once I converted it, I recorded a macro in which I changed the values in the 
Org 
Chart.

I don't know if that will give you the result you're looking for...

??
 
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: ANKUR AGGARWAL 
To: "excel-macros@googlegroups.com" 
Sent: Mon, November 5, 2012 9:43:37 PM
Subject: Re: $$Excel-Macros$$ Organization Chart


Can somebody please help on the same ?

Warm Regards
Ankur Aggarwal
91-8010614628
Analyst
Mckinsey Knowledge Center
Mckinsey & Co.



From: ANKUR AGGARWAL 
To: "noorain.ans...@gmail.com" ; 
"excel-macros@googlegroups.com"  

Sent: Monday, 5 November 2012 6:31 PM
Subject: $$Excel-Macros$$ Organization Chart


Hi team,

Can anyone help me in Shape - Organizational chart in MS Excel. Attached is the 
sample excel file, in Sheet 1 there is an attached Organization chart which I 
am 
creating through VBA code., I want to fill each node of the chart dynamically 
through VBA, but the problem is I am not able to access nodes of the 
organization chart through code. 

Its taking whole organization chart as a shape and not able to access node of 
the organization chart.

Can somebody please help me out. Its very urgent as I have to complete 
something 
by EOD. 

Thanks in advance.

Warm Regards
Ankur Aggarwal
Analyst

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel
 
FORUM RULES (1120+ 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. 

 
6) Jobs posting is not allowed.
 
7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum 
owners 
and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.
 
 


-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel
 
FORUM RULES (1120+ 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. 

 
6) Jobs posting is not allowed.
 
7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum 
owners 
and members are not responsible for any loss.
--- 
You received this mess

Re: $$Excel-Macros$$ Extracting Keywords from String

[Paul Schreiner]

I've modified the subject to provide some meaningful information.

How do you know what parts of the string are important?

I mean, you've started with:
MONEL;  1 1/2 X UNS 1/2 " FBECOATED (1/2  CLAD; 1 1/2 CARBON STEEL, 1 1/2 LOW 
CARBON STEEL  

and have decided that these terms are to be extracted:
MONEL|UNS|FBECOATED|CLAD|CARBON STEEL|LOW CARBON STEEL

So, it looks like the numeric portion is irrelevent, as well as punctuation
and "X".

You can easily split the string based on a "space" as a delimeter.
then skip any single-character and numeric values.
Although, terms like "Low Carbon Steel" will need to be "reassembled".

or, do you have a list of keywords that you're looking for?

otherwise, how do you decide what is a whole "term" and what is not?



 
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: Sayed Abdul Azeem (QFD) 
To: excel-macros@googlegroups.com
Sent: Wed, November 7, 2012 2:50:01 AM
Subject: FW: $$Excel-Macros$$


Dear NOORAIN ANSARI


I am having huge data like attached file DATA sheet, from description column 
selected contains need to copy sheet2 with vba code which is very helpful for 
me, please see attached file sheet Data and sheet2 for your understand.
Thanks in advance
 
 
 
 
Azeem Quraishi
 
From:excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On 
Behalf Of NOORAIN ANSARI
Sent: Wednesday, November 07, 2012 10:37 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$
 
Dear Azeem,

Please explain more, what is your exact need.
On Tue, Nov 6, 2012 at 9:08 PM, Sayed Abdul Azeem (QFD)  
wrote:
Dear  Experts 
 
Can somebody please help me out. How to generate in the VBA selected contains 
shift to another column, find attached sample file 

 
 
 
 
 
-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel
 
FORUM RULES (1120+ 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. 

 
6) Jobs posting is not allowed.
 
7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum 
owners 
and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.
 
 



-- 
With Regards,
Noorain Ansari
http://noorainansari.com
http://excelvbaclinic.com 
 
 
-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel
 
FORUM RULES (1120+ 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. 

 
6) Jobs posting is not allowed.
 
7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum 
owners 
and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.
 
 -- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel
 
FORUM RULES (1120+ 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 pos

Re: $$Excel-Macros$$ Organization Chart

[Paul Schreiner]

The 2003 is probably going to be a problem 
since I no longer have access to Excel 2003.

The problem, from what I can see,
is that your sample file doesn't contain 
a typical Org Chart object, but a "picture" of 
a sample Org Chart...

I'm not sure why you cannot find info on the internet.

I googled:
excel org chart template 2003

and received 400,000 hits.
the first ones seem to be free sample Org Chart templates for 2003.

some of these sites also mention an "Organization Chart" toolbar in 2003.

The tools there would probably be helpful increating the chart.

If you start with one of the templates and record a macro in which you
make an entry into one of the "positions",
it should give you an idea of how to modify the org chart.

Once you get that far, you ought to be able to figure out how
to take your personnel list and put it into the chart.

once you have a starting point, I might be able to help further...

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: ANKUR AGGARWAL 
To: "excel-macros@googlegroups.com" 
Sent: Wed, November 7, 2012 4:10:14 AM
Subject: Re: $$Excel-Macros$$ Organization Chart


Hi Paul,

Thanks for the reply. Your method of double clicking and recording the macro 
works well for excel 2007, but its not working for excel 2003, reason being we 
not even getting the pop up for converting it into shape in 2003.

What can be other alternative. Also I have googled but couldn't find any 
relevant info on the web.

Warm Regards
Ankur Aggarwal
Analyst




From: Paul Schreiner 
To: excel-macros@googlegroups.com 
Sent: Tuesday, 6 November 2012 7:21 PM
Subject: Re: $$Excel-Macros$$ Organization Chart


I also Googled "Excel vba Org Chart"
and received 189,000 hits.

Perhaps someone else has already done this?
 
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: Paul Schreiner 
To: excel-macros@googlegroups.com
Sent: Tue, November 6, 2012 8:40:43 AM
Subject: Re: $$Excel-Macros$$ Organization Chart


I took a look at your file.
It seems to have something to do with the type of image that was inserted.

I was able to double-click on the image, and a popup was presented allowing the
image to be converted to a Shape collection.

Once I converted it, I recorded a macro in which I changed the values in the 
Org 
Chart.

I don't know if that will give you the result you're looking for...

??
 
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: ANKUR AGGARWAL 
To: "excel-macros@googlegroups.com" 
Sent: Mon, November 5, 2012 9:43:37 PM
Subject: Re: $$Excel-Macros$$ Organization Chart


Can somebody please help on the same ?

Warm Regards
Ankur Aggarwal
91-8010614628
Analyst
Mckinsey Knowledge Center
Mckinsey & Co.



From: ANKUR AGGARWAL 
To: "noorain.ans...@gmail.com" ; 
"excel-macros@googlegroups.com"  

Sent: Monday, 5 November 2012 6:31 PM
Subject: $$Excel-Macros$$ Organization Chart


Hi team,

Can anyone help me in Shape - Organizational chart in MS Excel. Attached is the 
sample excel file, in Sheet 1 there is an attached Organization chart which I 
am 
creating through VBA code., I want to fill each node of the chart dynamically 
through VBA, but the problem is I am not able to access nodes of the 
organization chart through code. 

Its taking whole organization chart as a shape and not able to access node of 
the organization chart.

Can somebody please help me out. Its very urgent as I have to complete 
something 
by EOD. 

Thanks in advance.

Warm Regards
Ankur Aggarwal
Analyst

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel
 
FORUM RULES (1120+ 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 prohib

Fwd: $$Excel-Macros$$ Sum required from different sheet..

[Pravin Gunjal]

*you mean to say that the formula should be changed automatically, whenever
you create a new sheet?
*
-- Forwarded message --
From: Manoj Kumar 
Date: Wed, Nov 7, 2012 at 2:05 PM
Subject: Re: $$Excel-Macros$$ Sum required from different sheet..
To: excel-macros@googlegroups.com



Hi,

Anybody please help me...


Regard
Manoj


On Wed, Nov 7, 2012 at 12:53 PM, Manoj Kumar  wrote:

> Dear Expert,
>
> Please help me ...when I add new sheet ("3") it should be change like
> that.."SUM('1:3'!B2)"
>
> Regard
> Manoj
>
> --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES (1120+ 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.
>
> 6) Jobs posting is not allowed.
>
> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
>
>
>

 --
Join official facebook page of this forum @
https://www.facebook.com/discussexcel

FORUM RULES (1120+ 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.

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
---
You received this message because you are subscribed to the Google Groups
"MS EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to
excel-macros+unsubscr...@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ 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. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.




sum from different sheet.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Re: $$Excel-Macros$$ Rajan Verma - Most Helpful Member October'12

[Karan Singh]

Congrats dude!!



Karan Singh




On Tue, Nov 6, 2012 at 5:51 PM, neeraj chauhan
wrote:

> congratulation Rajan sir.
>
>
>
> On Tue, Nov 6, 2012 at 5:36 PM, Govind Mori  wrote:
>
>> Congrats Rajan
>>
>> On Mon, Nov 5, 2012 at 10:57 PM, Ayush Jain wrote:
>>
>>>
>>> Dear members,
>>>
>>> Rajan Verma has been selected as 'Most Helpful Member' for the month of
>>> Oct'12. He has posted 66 posts in last month and helped forum members
>>> through his excel expertise.
>>> I truly appreciate his knowledge, consistency and commitment to the
>>> group.
>>> *
>>> Rajan, please find enclosed the award certificate in honor of your
>>> contribution. Congratulations and thanks for your contribution.
>>> *
>>>
>>> Thanks to Ashish, Paul, Manoj, Vabz, Pravin, Noorain and all other folks
>>> for helping excel enthusiasts voluntarily !!
>>> Keep posting.
>>>
>>> Regards,
>>> Ayush Jain
>>> Group Manager
>>>
>>> P.S. If you have any feedback, please share your thoughts by filling the 
>>> survey
>>> form.
>>>
>>>
>>>
>>>  --
>>> Join official facebook page of this forum @
>>> https://www.facebook.com/discussexcel
>>>
>>> FORUM RULES (1120+ 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.
>>>
>>> 6) Jobs posting is not allowed.
>>>
>>> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>>>
>>> NOTE : Don't ever post personal or confidential data in a workbook.
>>> Forum owners and members are not responsible for any loss.
>>> ---
>>> You received this message because you are subscribed to the Google
>>> Groups "MS EXCEL AND VBA MACROS" group.
>>> To post to this group, send email to excel-macros@googlegroups.com.
>>> To unsubscribe from this group, send email to
>>> excel-macros+unsubscr...@googlegroups.com.
>>> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
>>>
>>>
>>>
>>
>>  --
>> Join official facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES (1120+ 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.
>>
>> 6) Jobs posting is not allowed.
>>
>> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "MS EXCEL AND VBA MACROS" group.
>> To post to this group, send email to excel-macros@googlegroups.com.
>> To unsubscribe from this group, send email to
>> excel-macros+unsubscr...@googlegroups.com.
>> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
>>
>>
>>
>
>  --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES (1120+ 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.
>
> 6) Jobs posting is not allowed.
>
> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
> Visit this group at http:/

$$Excel-Macros$$ Re: Sum required from different sheet..

[Prince]

Hi Manoj,

I think we can not do it through formula only we can do it easly through 
VBA. So below is the small code that we generate the same formula as you 
want. 
But it has some limitation eg. your sheets name should be continues like 
[1,2,3.] except the sheet name Report.

   Dim rngCellsAs Range
With ThisWorkbook.Worksheets("Report")
For Each rngCells In 
Intersect(.Range("A1").CurrentRegion.Columns(2), 
.Range("A1").CurrentRegion.Columns(2).Offset(1))
   rngCells.Formula = "=sum('1:" & ThisWorkbook.Sheets.Count - 1 & 
"'!" & Left(rngCells.Address, 4) & ")"
Next
End With

Regards
Prince Dubey.

On Wednesday, November 7, 2012 12:54:00 PM UTC+5:30, Manoj Kumar wrote:
>
> Dear Expert, 
>
> Please help me ...when I add new sheet ("3") it should be change like 
> that.."SUM('1:3'!B2)"
>
> Regard
> Manoj
>

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ 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. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.

Re: $$Excel-Macros$$ Organization Chart

[ANKUR AGGARWAL]

Hi Paul,

Thanks for the reply. Your method of double clicking and recording the macro 
works well for excel 2007, but its not working for excel 2003, reason being we 
not even getting the pop up for converting it into shape in 2003.

What can be other alternative. Also I have googled but couldn't find any 
relevant info on the web.
 
Warm Regards
Ankur Aggarwal
Analyst




 From: Paul Schreiner 
To: excel-macros@googlegroups.com 
Sent: Tuesday, 6 November 2012 7:21 PM
Subject: Re: $$Excel-Macros$$ Organization Chart
 

I also Googled "Excel vba Org Chart"
and received 189,000 hits.
 
Perhaps someone else has already done this?
 
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: Paul Schreiner 
To: excel-macros@googlegroups.com
Sent: Tue, November 6, 2012 8:40:43 AM
Subject: Re: $$Excel-Macros$$ Organization Chart


I took a look at your file.
It seems to have something to do with the type of image that was inserted.
 
I was able to double-click on the image, and a popup was presented allowing the
image to be converted to a Shape collection.
 
Once I converted it, I recorded a macro in which I changed the values in the 
Org Chart.
 
I don't know if that will give you the result you're looking for...
 
??
 
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: ANKUR AGGARWAL 
To: "excel-macros@googlegroups.com" 
Sent: Mon, November 5, 2012 9:43:37 PM
Subject: Re: $$Excel-Macros$$ Organization Chart


Can somebody please help on the same ?
 
Warm Regards
Ankur Aggarwal
91-8010614628
Analyst
Mckinsey Knowledge Center
Mckinsey & Co.



 From: ANKUR AGGARWAL 
To: "noorain.ans...@gmail.com" ; 
"excel-macros@googlegroups.com"  
Sent: Monday, 5 November 2012 6:31 PM
Subject: $$Excel-Macros$$ Organization Chart


Hi team,

Can anyone help me in Shape - Organizational chart in MS Excel. Attached is the 
sample excel file, in Sheet 1 there is an attached Organization chart which I 
am creating through VBA code., I want to fill each node of the chart 
dynamically through VBA, but the problem is I am not able to access nodes of 
the organization chart through code. 

Its taking whole organization chart as a shape and not able to access node of 
the organization chart.

Can somebody please help me out. Its very urgent as I have to complete 
something by EOD. 
 
Thanks in advance.
 
Warm Regards
Ankur Aggarwal
Analyst

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel
 
FORUM RULES (1120+ 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. 
 
6) Jobs posting is not allowed.
 
7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.
 
 


-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel
 
FORUM RULES (1120+ 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. 
 
6) Jobs posting is not allowed.
 
7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
 
NOTE : Don't ever post
 personal or confi

Re: $$Excel-Macros$$ Organization Chart

[ANKUR AGGARWAL]

Thanks for sharing the thread Rajan, but unfortunately code doesn't work in 
Excel 2003 and my client is using excel 2003. Do you have any alternative ?
 
Warm Regards
Ankur Aggarwal
91-8010614628
Analyst
Mckinsey Knowledge Center
Mckinsey & Co.



 From: Rajan_Verma 
To: excel-macros@googlegroups.com 
Sent: Tuesday, 6 November 2012 7:49 PM
Subject: RE: $$Excel-Macros$$ Organization Chart
 

Please have a look here
 
http://www.mrexcel.com/forum/excel-questions/554224-using-visual-basic-applications-smart-art.html
 
 
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
 
From:excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On 
Behalf Of Paul Schreiner
Sent: 06 November 2012 7:21
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Organization Chart
 
I also Googled "Excel vba Org Chart"
and received 189,000 hits.
 
Perhaps someone else has already done this?
 
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:Paul Schreiner 
To: excel-macros@googlegroups.com
Sent: Tue, November 6, 2012 8:40:43 AM
Subject: Re: $$Excel-Macros$$ Organization Chart
I took a look at your file.
It seems to have something to do with the type of image that was inserted.
 
I was able to double-click on the image, and a popup was presented allowing the
image to be converted to a Shape collection.
 
Once I converted it, I recorded a macro in which I changed the values in the 
Org Chart.
 
I don't know if that will give you the result you're looking for...
 
??
 
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:ANKUR AGGARWAL 
To: "excel-macros@googlegroups.com" 
Sent: Mon, November 5, 2012 9:43:37 PM
Subject: Re: $$Excel-Macros$$ Organization Chart
Can somebody please help on the same ?
 
Warm Regards
Ankur Aggarwal
91-8010614628
Analyst
Mckinsey Knowledge Center
Mckinsey & Co.
 



From:ANKUR AGGARWAL 
To: "noorain.ans...@gmail.com" ; 
"excel-macros@googlegroups.com"  
Sent: Monday, 5 November 2012 6:31 PM
Subject: $$Excel-Macros$$ Organization Chart
 
Hi team,
 
Can anyone help me in Shape - Organizational chart in MS Excel. Attached is the 
sample excel file, in Sheet 1 there is an attached Organization chart which I 
am creating through VBA code., I want to fill each node of the chart 
dynamically through VBA, but the problem is I am not able to access nodes of 
the organization chart through code. 
 
Its taking whole organization chart as a shape and not able to access node of 
the organization chart.
 
Can somebody please help me out. Its very urgent as I have to complete 
something by EOD. 
 
Thanks in advance.
 
Warm Regards
Ankur Aggarwal
Analyst
 
-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel
 
FORUM RULES (1120+ 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. 
 
6) Jobs posting is not allowed.
 
7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.
 
 
 
-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel
 
FORUM RULES (1120+ 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 o

Re: $$Excel-Macros$$ Sum required from different sheet..

[Manoj Kumar]

Hi,

Anybody please help me...


Regard
Manoj


On Wed, Nov 7, 2012 at 12:53 PM, Manoj Kumar  wrote:

> Dear Expert,
>
> Please help me ...when I add new sheet ("3") it should be change like
> that.."SUM('1:3'!B2)"
>
> Regard
> Manoj
>
> --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES (1120+ 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.
>
> 6) Jobs posting is not allowed.
>
> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
>
>
>

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ 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. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.




sum from different sheet.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Re: $$Excel-Macros$$ Send email from outlook every 1hr to 24 hrs

[VBA VABZ]

hi

can u send me sample data...

Rgds


On Tue, Nov 6, 2012 at 10:24 PM, veerendra vanam
wrote:

>
>
> On Tue, Nov 6, 2012 at 3:44 PM, veerendra vanam  > wrote:
>
>>
>> Dear all,
>>
>>   i am sending mail particular updated file summary sheet as
>> body, every 1hr like 01:00hr,02:00hr,03:00hr
>>
>>  plz any one send vba code for this work for outlook,
>>
>> --
>>
>> *Thanks&Regards
>>
>> *   *Veerendra.Vanam*
>>   TOC TEAM
>>   Bhagyanagar Electrical & Contractors
>>*H.No-5-9-286/65,Plot No-65
>> Rajiv Gandhi Nagar,Near Andhra Jyothi Press,IE-Kukatpally,*
>> *  Hyderabad-500072,-Andhra Pradesh
>>   +91-9177-444-840*,
>>
>>  --
>> Join official facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES (1120+ 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.
>>
>> 6) Jobs posting is not allowed.
>>
>> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "MS EXCEL AND VBA MACROS" group.
>> To post to this group, send email to excel-macros@googlegroups.com.
>> To unsubscribe from this group, send email to
>> excel-macros+unsubscr...@googlegroups.com.
>> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
>>
>>
>>
>
>
>
> --
>
> *Thanks&Regards
>
> *   *Veerendra.Vanam*
>   TOC TEAM
>   Bhagyanagar Electrical & Contractors
>*H.No-5-9-286/65,Plot No-65
> Rajiv Gandhi Nagar,Near Andhra Jyothi Press,IE-Kukatpally,*
> *  Hyderabad-500072,-Andhra Pradesh
>   +91-9177-444-840*,
>
>  --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES (1120+ 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.
>
> 6) Jobs posting is not allowed.
>
> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
>
>
>

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ 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. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.