Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 06-11-2011, 05:52 PM
vbapptnew123 vbapptnew123 is offline Help with reducing pptm file size Windows 7 64bit Help with reducing pptm file size Office 2007
Novice
Help with reducing pptm file size
 
Join Date: Jun 2011
Posts: 2
vbapptnew123 is on a distinguished road
Default Help with reducing pptm file size

I wrote a vba macro code to copy paste multiple xlsm data sheets and charts into an existing powerpoint file, with the slides being cleared so as not to overwrite the existing slides. The powerpoint file is then saved. There are about 80 slides that need to be copied out of 140 slides.



The original powerpoint file is in .pptx format. The macro saves the file as .pptm format.

I took some piece of the code from another code and improvised upon it. I am not sure why the file is originally saved as a .pptm but could this be causing a large file size? However the copy paste vba code works perfectly fine except that we cannot send the huge file (25MB) as an e-mail attachment. The original file size is 4MB. All we are doing is deleting some slides and copy / pasting the ones from the ,xlsm file. Is there a way we can reduce the file size?

Should I have used the .pptx instead?


Sub Copy2PowerPoint2()
Application.ScreenUpdating = False
Dim slidenum As Integer
Dim PPTM As PowerPoint.Application
Set PPTM = New PowerPoint.Application
PPTM.Visible = True
PPTM.Presentations.Open Filename:="F:\Focus\Myfolder\Copy Paste Project\OnePagers_Templates\OriginationsMonitorPac kage.pptm"
Reply With Quote
  #2  
Old 06-11-2011, 06:24 PM
vbapptnew123 vbapptnew123 is offline Help with reducing pptm file size Windows 7 64bit Help with reducing pptm file size Office 2007
Novice
Help with reducing pptm file size
 
Join Date: Jun 2011
Posts: 2
vbapptnew123 is on a distinguished road
Default

I tried saving the original file as .pptx. I modified the code to use .PPTX instead. The original ppt file size was 305 KB with 4 blank slides. I tried from a small file of 11 slides and pasted 4 slides and saved the file. The file size increased to 586 KB.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Help with reducing pptm file size what is the maximum size (in MB) the word file can take? Jamal NUMAN Word 1 04-20-2011 04:56 AM
Word file size increases with Save Hollister Word 3 11-08-2010 01:14 PM
word file size Jimbir Word 5 11-08-2010 07:59 AM
My file size has grown to 65 meg BobHewson Drawing and Graphics 6 06-07-2010 07:23 AM
Exporting to PDF and keeping file size down CloudandBanner Word 0 08-24-2009 09:29 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:09 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft