Hi,
We are automating manual process of copy and paste from xls to powerpoint using vba code.
I have used vba macro code to copy and paste data ranges and charts to power point. The vba code exists in .xlsm files.
The Powerpoint files is in .pptm. The original power point file is in .pptx with a file size of 4MB.
The file size for the powerpoint file created with the vba code is 6 times greater, about 25 MB.
The file needs to be sent as an attachment via e-mail and we want to know how to reduce the file size. We tried saving as a .pptx but the size did not change.
Any ideas?
Thanks for your help.
We are automating manual process of copy and paste from xls to powerpoint using vba code.
I have used vba macro code to copy and paste data ranges and charts to power point. The vba code exists in .xlsm files.
The Powerpoint files is in .pptm. The original power point file is in .pptx with a file size of 4MB.
The file size for the powerpoint file created with the vba code is 6 times greater, about 25 MB.
The file needs to be sent as an attachment via e-mail and we want to know how to reduce the file size. We tried saving as a .pptx but the size did not change.
Any ideas?
Thanks for your help.