Shay, whatever you have asked is possible in VBA. I am unable to offer the code
with me right now because of my busy schdeule. May be this weekend I will be
able to send you codes to insert Pivot in power point and to insert chart in
outlook.
Regarding q.3, you can't refresh the charts because the macro i sent
you imports charts as images. You can write another macro to delete
existing charts and import new ones again.
Regarding productivity, TAT etc I have created several small macros which make
my work faster and easier. You can send me your data files and dashboard sample
and I will try to write some code for you.
Regards,
Alokeshwar
9891442001
_________________________________________________________________________________________________
"There are known knowns. These are things we know that we know. There are known
unknowns. That is to say, there are things that we know we don't know. But
there are also unknown unknowns. There are things we don't know we don't know."
________________________________
From: shay shay <shahinarafi...@gmail.com>
To: Alokeshwar Tiwary <alokeshwar.tiw...@yahoo.com>
Sent: Wednesday, 11 March, 2009 8:32:02 PM
Subject: Re: $$Excel-Macros$$ Re: charts to powerpoint
Yes I changed macro security in Powerpoint also. Damit itssss a dammmmmmmmmm
gooddddddd piece of workkkkkkk.
Thanks for making such a macro.
I have few questions.
1. Can I also add a table like a pivot table in powerpoint
2. Is it possible to save the charts directly to outlook mail?
3. and how do u refresh the charts in powerpoint everytime when data is
modified in the excel sheet.
4. can u please guide me the calculation part in excel like how did u derive
productivity, TAT etc as I got similar work but I was unable to complete it and
my clock time is coming to end and i am still not prepared with it
And congrats for winning by providing maximum answers.
Regards,
Shay
On Wed, Mar 11, 2009 at 5:45 PM, Alokeshwar Tiwary
<alokeshwar.tiw...@yahoo.com> wrote:
Did you check macro security in Power Point also? What version of MS Office do
you have? Could you please send me a screen print of your desktop with the
error message?
_________________________________________________________________________________________________
"There are known knowns. These are things we know that we know. There are known
unknowns. That is to say, there are things that we know we don't know. But
there are also unknown unknowns. There are things we don't know we don't know."
________________________________
From: shay shay <shahinarafi...@gmail.com>
To: Alokeshwar Tiwary <alokeshwar.tiw...@yahoo.com>
Sent: Wednesday, 11 March, 2009 5:22:11 PM
Subject: Re: $$Excel-Macros$$ Re: charts to powerpoint
I have checked security in macro as Low but then to its throwing an error as
Macro's in the project are not enabled
On Wed, Mar 11, 2009 at 4:43 PM, Alokeshwar Tiwary
<alokeshwar.tiw...@yahoo.com> wrote:
are you getting any error messages? or can you send me your files?
_________________________________________________________________________________________________
"There are known knowns. These are things we know that we know. There are known
unknowns. That is to say, there are things that we know we don't know. But
there are also unknown unknowns. There are things we don't know we don't know."
________________________________
From: shay shay <shahinarafi...@gmail.com>
To: alokeshwar.tiw...@yahoo.com
Sent: Wednesday, 11 March, 2009 11:06:44 AM
Subject: Re: $$Excel-Macros$$ Re: charts to powerpoint
Macro is not working for me.
On Wed, Mar 11, 2009 at 7:04 AM, Alokeshwar Tiwary
<alokeshwar.tiw...@yahoo.com> wrote:
Dear Hari, Attached zip file contains tow example files for your problem. Unzip
both files in same folder and then open Power Point file and run macro
xlchartpastespecial macro. The macro will copy all charts from excel file to
power point. You may record a macro to change chart position in the slide. Or
you can modify below code to change the position of the chart:
ActiveWindow.Selection.SlideRange.Shapes("Picture 1").Select
With ActiveWindow.Selection.ShapeRange
.IncrementLeft 308.25
.IncrementTop 180.75
End With
_________________________________________________________________________________________________
"There are known knowns. These are things we know that we know. There are known
unknowns. That is to say, there are things that we know we don't know. But
there are also unknown unknowns. There are things we don't know we don't know."
________________________________
From: hari <prekkeh...@gmail.com>
To: excel-macros@googlegroups.com
Sent: Wednesday, 11 March, 2009 11:29:52 AM
Subject: $$Excel-Macros$$ charts to powerpoint
Hi All,
I have a problem of inserting 6 charts from a excel sheet to slide in power
point. The effort is doing for almost 58-60 slides in a similar fashion. I got
the code for getting the charts into a power point slide. Can anyone advise me
with formatting the positioning of the charts in power point thru vba code
excel.
Regards
Hari kumar
________________________________
Add more friends to your messenger and enjoy! Invite them now.
--
Shay
A Thinker tends to use reason and logic
A feeler tends to use values and subjective Judgement.
Be a Thinker in Life.
________________________________
Get perfect Email ID for your Resume. Get before others grab.
--
Shay
A Thinker tends to use reason and logic
A feeler tends to use values and subjective Judgement.
Be a Thinker in Life.
________________________________
Get perfect Email ID for your Resume. Get before others grab.
--
Shay
A Thinker tends to use reason and logic
A feeler tends to use values and subjective Judgement.
Be a Thinker in Life.
Add more friends to your messenger and enjoy! Go to
http://messenger.yahoo.com/invite/
--~--~---------~--~----~------------~-------~--~----~
-------------------------------------------------------------------------------------
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
-------------------------------------------------------------------------------------
-~----------~----~----~----~------~----~------~--~---
