 news.only-4-geeks.com Forum Index » PowerPoint | Goto page 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34 Next |
|  | Insert excel data | | |
| | | server |  |
|  Posted: Mon May 26, 2008 6:16 am Post subject: Insert excel data |  |
| |
| | | John Wilson | |
| | Posted: Mon May 26, 2008 6:17 am Post subject: RE: Insert excel data | |
Are you using a version before 2002?
LINK
--
-------------------------------------------
Amazing PPT Hints, Tips and Tutorials
LINK
LINK
email john AT technologytrish.co.uk
"ec17" wrote:
| Quote: | I need to insert excel data into a powerpoint slide, however it keeps getting
cut off.
(Roughly A:30 to J:30)
I have tried copying and pasting, inserting an object, inserting a file,
double clicking on the data once inserted, however the last row of text (row
J) is missing from my presentation.
When I try and resize the item, it just stretches the current selection
until it is out of proportion. Can I nominate the selected cells I want
copied into the powerpoint slide?
I'm stumped! Any suggestions? |
|
| |
| | | John Wilson | |
| | Posted: Mon May 26, 2008 6:21 am Post subject: RE: Can't see Slide Show when on AC power | |
A common reason for invisble slide shows is that in Slide Show > Set Up Show
you have the show set to play on a (non existant) second monitor. I can't see
how battery power could possibly fix that but it's maybe worth a look.
Regards
John
--
-------------------------------------------
Amazing PPT Hints, Tips and Tutorials
LINK
LINK
email john AT technologytrish.co.uk
"chemguy" wrote:
| Quote: | Why can't I see Slide Shows when my laptop is on AC power? They play fine
when on battery power. Running Power Point 2003. |
|
| |
| | | Prasant | |
| | Posted: Mon May 26, 2008 7:38 am Post subject: RE: Tabs for bullets inside table | |
| |  | |
OOPS...sorry to miss that...I'm using 2003.
Prasant
---------
"John Wilson" wrote:
| Quote: | You'd probably want to mention which version of PPT this is for Prasant.
--
-------------------------------------------
Amazing PPT Hints, Tips and Tutorials
LINK
LINK
email john AT technologytrish.co.uk
"Prasant" wrote:
Hi there,
Looking for something which I believe can't get. But still have hope as
experts are in here...
We will be having many tables with bullet points. Indenting bullets is a big
problem. We need to go inside each cell give indent for each and every cell
which takes lot of time. Copy and Paste formatting still needs indenting.
Copying bullet and copying text as unformatted text is also a laborious. Is
it possible to create a macro with a button (or shortcut key will be great)
which captures the first indent given and applies to all other cells in the
entire table?
I tried recording but it is not working. Simply what I need is, if I give
indent to one cell, it should apply to the entire table either through a
macro or any alternate procedure but in seconds.
Your ideas are appreciated with respect.
Thanks |
|
| |
| | | John Wilson | |
| | Posted: Mon May 26, 2008 8:18 am Post subject: RE: Tabs for bullets inside table | |
| | | |
Prasant
This is "top of my head" code but it should get you close
Sub formattable()
'reads indent from cell 1,1 and transfers to all
Dim otbl As Table
Dim Irow As Integer
Dim Icol As Integer
Dim Ibullet As Integer
Dim lngFirst As Long
Dim lngLeft As Long
Dim boolBullet As Boolean
' ignore error is no selection or not table
On Error Resume Next
Set otbl = ActiveWindow.Selection.ShapeRange(1).Table
With otbl.Cell(1, 1).Shape.TextFrame
lngLeft = .Ruler.Levels(1).LeftMargin
lngFirst = .Ruler.Levels(1).FirstMargin
End With
For Irow = 1 To otbl.Rows.Count
For Icol = 1 To otbl.Columns.Count
With otbl.Cell(Irow, Icol).Shape.TextFrame
..TextRange.ParagraphFormat.Bullet.Type = ppBulletUnnumbered
..Ruler.Levels(1).LeftMargin = lngLeft
..Ruler.Levels(1).FirstMargin = lngFirst
End With
Next Icol
Next Irow
End Sub
Set the first cell as required, select the table and run code.
--
-------------------------------------------
Amazing PPT Hints, Tips and Tutorials
LINK
LINK
email john AT technologytrish.co.uk
"Prasant" wrote:
| Quote: | OOPS...sorry to miss that...I'm using 2003.
Prasant
---------
"John Wilson" wrote:
You'd probably want to mention which version of PPT this is for Prasant.
--
-------------------------------------------
Amazing PPT Hints, Tips and Tutorials
LINK
LINK
email john AT technologytrish.co.uk
"Prasant" wrote:
Hi there,
Looking for something which I believe can't get. But still have hope as
experts are in here...
We will be having many tables with bullet points. Indenting bullets is a big
problem. We need to go inside each cell give indent for each and every cell
which takes lot of time. Copy and Paste formatting still needs indenting.
Copying bullet and copying text as unformatted text is also a laborious. Is
it possible to create a macro with a button (or shortcut key will be great)
which captures the first indent given and applies to all other cells in the
entire table?
I tried recording but it is not working. Simply what I need is, if I give
indent to one cell, it should apply to the entire table either through a
macro or any alternate procedure but in seconds.
Your ideas are appreciated with respect.
Thanks |
|
| |
| | | rich2764 | |
| | Posted: Mon May 26, 2008 10:17 am Post subject: RE: Database in powerpoint? | |
Hi John,
Could I possibly try your add in? It sounds like it will do the trick.
Does it come with a help file?
"John Wilson" wrote:
| Quote: | I can't remember whether PPTMerge can do this. If it doesn't do what you need
drop us a line we have an in house Add In that we use for quizes that may
help you.
PPTMerge is a great program anyway and well worth having!
--
-------------------------------------------
Amazing PPT Hints, Tips and Tutorials
LINK
LINK
email john AT technologytrish.co.uk
"rich2764" wrote:
Does anyone know if this is possible? I have created a presentation with
questions and answers. Is there a way of running a database or getting data
from an excel spreadsheet so that I don't need to keep highlighting the
relevant text and then do ctrl-c ctrl-h and ctrl-v for each question to be
changed etc? At the moment I keep having to change the text and then save as
but it is so long winded. |
|
| |
| | | rich2764 | |
| | Posted: Mon May 26, 2008 10:18 am Post subject: RE: Database in powerpoint? | |
"John Wilson" wrote:
| Quote: | I can't remember whether PPTMerge can do this. If it doesn't do what you need
drop us a line we have an in house Add In that we use for quizes that may
help you.
PPTMerge is a great program anyway and well worth having!
--
-------------------------------------------
Amazing PPT Hints, Tips and Tutorials
LINK
LINK
email john AT technologytrish.co.uk
"rich2764" wrote:
Does anyone know if this is possible? I have created a presentation with
questions and answers. Is there a way of running a database or getting data
from an excel spreadsheet so that I don't need to keep highlighting the
relevant text and then do ctrl-c ctrl-h and ctrl-v for each question to be
changed etc? At the moment I keep having to change the text and then save as
but it is so long winded. |
|
| |
| | | Echo S | |
| | Posted: Mon May 26, 2008 10:55 am Post subject: Re: Enlarging/reducing object size | |
| | | |
Well, if you were going to search in the Help file, what search terms would
you use? Maybe we can get a Help file entry on it.
I'm thinking "resize text," maybe. There are probably others.
--
Echo [MS PPT MVP] LINK
What's new in PPT 2007? LINK
Fixing PowerPoint Annoyances LINK
PowerPoint 2007 Complete Makeover Kit LINK
"Carl" <acj1@itconnect.net.au> wrote in message
news:u6XGGDvvIHA.4492@TK2MSFTNGP02.phx.gbl...
| Quote: | Thanks Lucy and Echo
I went on the net, and quite by accident I came across a posting of Echo's
that explained it all perfectly.
I tested it all out and it seems to work fine.
In conclusion, why the hell didn't MS make this (important) information
easily available?
/carl
"Lucy Thomson" <lucy@NOSPAManeasiertomorrow.com.au> wrote in message
news:ut$A49uvIHA.4492@TK2MSFTNGP02.phx.gbl...
Nice catch Echo - I'm always losing that transform option :-)
Lucy
--
Lucy Thomson
PowerPoint MVP
MOS Master Instructor
LINK
"Echo S" <msnewsgroups@echosvoiceUGHSPAM.com> wrote in message
news:8C817761-AD2A-4AF3-80D9-020E22C32203@microsoft.com...
You have to "transform" the text so that PPT knows it's "wordart" (a
graphical element) and not just text.
Select the text, then Drawing Tools Format | Text Effects | Transform,
choose Square. Now you can size using the sizing handles.
--
Echo [MS PPT MVP] LINK
What's new in PPT 2007? LINK
Fixing PowerPoint Annoyances LINK
PowerPoint 2007 Complete Makeover Kit LINK
"Carl" <acj1@itconnect.net.au> wrote in message
news:ug0LMcuvIHA.3564@TK2MSFTNGP03.phx.gbl...
Hi Lucy
Yes, works for certain things -- but I can't get it to work on this new
"thing" they call WordArt ... yuk!
/carl
"Carl" <acj1@itconnect.net.au> wrote in message
news:Oa%23RnSuvIHA.5620@TK2MSFTNGP04.phx.gbl...
I sould have been more specific ... I cannot get this to work on
"WordArt"
/carl
"Carl" <acj1@itconnect.net.au> wrote in message
news:OqPI4GuvIHA.5288@TK2MSFTNGP06.phx.gbl...
Greetings from Downunder
In PPT versions up to 2003, in order to increase/decrease an object's
size you could select the object, grab a corner handle, left-click
and drag the mouse and the object would enlarge/decrease from the
centre. How can this be achieved in PPT 2007?
All help always appreciated
/carl
|
|
| |
| | | Prasant | |
| | Posted: Mon May 26, 2008 2:22 pm Post subject: RE: Tabs for bullets inside table | |
| | | |
Hey John
GREAT...it worked....You are GOD!!!
---------------------
"John Wilson" wrote:
| Quote: | Prasant
This is "top of my head" code but it should get you close
Sub formattable()
'reads indent from cell 1,1 and transfers to all
Dim otbl As Table
Dim Irow As Integer
Dim Icol As Integer
Dim Ibullet As Integer
Dim lngFirst As Long
Dim lngLeft As Long
Dim boolBullet As Boolean
' ignore error is no selection or not table
On Error Resume Next
Set otbl = ActiveWindow.Selection.ShapeRange(1).Table
With otbl.Cell(1, 1).Shape.TextFrame
lngLeft = .Ruler.Levels(1).LeftMargin
lngFirst = .Ruler.Levels(1).FirstMargin
End With
For Irow = 1 To otbl.Rows.Count
For Icol = 1 To otbl.Columns.Count
With otbl.Cell(Irow, Icol).Shape.TextFrame
.TextRange.ParagraphFormat.Bullet.Type = ppBulletUnnumbered
.Ruler.Levels(1).LeftMargin = lngLeft
.Ruler.Levels(1).FirstMargin = lngFirst
End With
Next Icol
Next Irow
End Sub
Set the first cell as required, select the table and run code.
--
-------------------------------------------
Amazing PPT Hints, Tips and Tutorials
LINK
LINK
email john AT technologytrish.co.uk
"Prasant" wrote:
OOPS...sorry to miss that...I'm using 2003.
Prasant
---------
"John Wilson" wrote:
You'd probably want to mention which version of PPT this is for Prasant.
--
-------------------------------------------
Amazing PPT Hints, Tips and Tutorials
LINK
LINK
email john AT technologytrish.co.uk
"Prasant" wrote:
Hi there,
Looking for something which I believe can't get. But still have hope as
experts are in here...
We will be having many tables with bullet points. Indenting bullets is a big
problem. We need to go inside each cell give indent for each and every cell
which takes lot of time. Copy and Paste formatting still needs indenting.
Copying bullet and copying text as unformatted text is also a laborious. Is
it possible to create a macro with a button (or shortcut key will be great)
which captures the first indent given and applies to all other cells in the
entire table?
I tried recording but it is not working. Simply what I need is, if I give
indent to one cell, it should apply to the entire table either through a
macro or any alternate procedure but in seconds.
Your ideas are appreciated with respect.
Thanks |
|
| |
| | | Prasant | |
| | Posted: Mon May 26, 2008 2:27 pm Post subject: RE: Tabs for bullets inside table | |
| | | |
Desires will never stop....
Can you give me any code to assign a particular macro to a keyboard function
or shortcutkey? I created some macros which I want to assign important ones
to a keyboard.
-------
"John Wilson" wrote:
| Quote: | Prasant
This is "top of my head" code but it should get you close
Sub formattable()
'reads indent from cell 1,1 and transfers to all
Dim otbl As Table
Dim Irow As Integer
Dim Icol As Integer
Dim Ibullet As Integer
Dim lngFirst As Long
Dim lngLeft As Long
Dim boolBullet As Boolean
' ignore error is no selection or not table
On Error Resume Next
Set otbl = ActiveWindow.Selection.ShapeRange(1).Table
With otbl.Cell(1, 1).Shape.TextFrame
lngLeft = .Ruler.Levels(1).LeftMargin
lngFirst = .Ruler.Levels(1).FirstMargin
End With
For Irow = 1 To otbl.Rows.Count
For Icol = 1 To otbl.Columns.Count
With otbl.Cell(Irow, Icol).Shape.TextFrame
.TextRange.ParagraphFormat.Bullet.Type = ppBulletUnnumbered
.Ruler.Levels(1).LeftMargin = lngLeft
.Ruler.Levels(1).FirstMargin = lngFirst
End With
Next Icol
Next Irow
End Sub
Set the first cell as required, select the table and run code.
--
-------------------------------------------
Amazing PPT Hints, Tips and Tutorials
LINK
LINK
email john AT technologytrish.co.uk
"Prasant" wrote:
OOPS...sorry to miss that...I'm using 2003.
Prasant
---------
"John Wilson" wrote:
You'd probably want to mention which version of PPT this is for Prasant.
--
-------------------------------------------
Amazing PPT Hints, Tips and Tutorials
LINK
LINK
email john AT technologytrish.co.uk
"Prasant" wrote:
Hi there,
Looking for something which I believe can't get. But still have hope as
experts are in here...
We will be having many tables with bullet points. Indenting bullets is a big
problem. We need to go inside each cell give indent for each and every cell
which takes lot of time. Copy and Paste formatting still needs indenting.
Copying bullet and copying text as unformatted text is also a laborious. Is
it possible to create a macro with a button (or shortcut key will be great)
which captures the first indent given and applies to all other cells in the
entire table?
I tried recording but it is not working. Simply what I need is, if I give
indent to one cell, it should apply to the entire table either through a
macro or any alternate procedure but in seconds.
Your ideas are appreciated with respect.
Thanks |
|
| |
| Page 1 of 34 .:. Goto page 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34 Next | |
|
|
