Excel to Powerpoint macro for Office 2003

Microsoft Office 2007 enterprise
May 6, 2010 at 21:41:15
Specs: Windows Vista
Hello, I am currently encountering a problem
with a macro I made previously using Excel
2007 shown in this post:

When I saved the workbook as an Excel 97-
2003 file and ran the macro, the graphs that
were pasted onto the ppt no longer followed
the preset dimensions in the macro. I already
enabled the MS Powerpoint Object 11.0
Library in the Visual Basic (2003 version)
before running the macro. Would any of you
know how to go about this?

See More: Excel to Powerpoint macro for Office 2003

May 9, 2010 at 03:31:04

I am not sure about what is actually causing your problem, but try adding this line before you set the size in the macro:

.LockAspectRatio = msoFalse


Report •

May 12, 2010 at 01:26:35
Humar, you are a genius. Thank you, that really worked. Strange
though that 2003 is preset to Lock Aspect Ratio.

Thank you!

Report •
Related Solutions

Ask Question