Selected Excel Range to Power Point Kinda...

**BusDriver2** · 10-07-2008, 01:59 PM

Hi,

I cannot seem to figure this out for the life of me but I am hoping that someone in the forum may be able to help me.

I need to be able to send my selected range of cells (to include: the spreadsheet background, colored cells and all values contained) to Power Point for a daily product.

I found this great VBA online and would like to use it but the problem is I keep getting funny results. It doesn't matter what cells I select I keep getting a extra margin on the left side and top of the pasted product in power point. I then have to crop the results... I have looked at the macro (from my noodie eyes) and cannot seem to find a way to adjust this added on margin.

Does anybody know how I can fix this so that I do not have to crop the results in Power Point every time I use this macro?

Please Login or Register  to view this content.

NOTE: Select any range of cells, Selection is sent to Power Point, Power Point must be active. Due to Excel File size (tiled jpeg background) I was not able to post spreadsheet. But results are attached.

Any help with this would be really great.

Best Regards,

BusDriver2

Please see attached files.

**Leith Ross** · 10-07-2008, 06:07 PM

Hello BusDriver2,

Change the code to paste the image from...

Please Login or Register  to view this content.

To this...

Please Login or Register  to view this content.

Sincerely,
Leith Ross

**BusDriver2** · 10-07-2008, 09:06 PM

Hi Leith,

Thanks for the speedy response to my post.

I tried making the suggested changes to the VBA code but I am still having mixed results. I tried a bunch of different combination's and none seem to work.

The first result (see attached file 1) is using the suggested change, it doesn't matter what I select I always get this as a result.

The second result is (see attached file 2) when I tried to make a bigger selection and I get really strange results.

Any help or thoughts on this would be would be great. Thanks.

Best Regards,

BusDriver2

Please see attached.

**Leith Ross** · 10-07-2008, 10:20 PM

Hello BusDriver2,

I felt certain the code change would work. Since the picture is being tiled on the slide background no matter what alignment is used, there must be some other setting that needs to changed. I will do some more code testing and hopefully have an answer for you.

Sincerely,
Leith Ross

**BusDriver2** · 10-08-2008, 04:06 AM

Leith,

Thanks for your help on this, I will check back again.

Best Regards,

BusDriver2

**BusDriver2** · 10-11-2008, 02:38 PM

Hi Leith,

I haven't heard back from you on the last post so I searched the internet and found a few macros that I was able to sew together and then make it work for my needs. Part of it the macro was authored by A. Pope and the other part was authored by Mr. Peltier.

This is the procedure that worked for me, Copy and paste the first macro in to Excel.

Please Login or Register  to view this content.

Then launch Power Point and copy and paste this macro in to Power Point.

Please Login or Register  to view this content.

Once these macros are installed... both Excel and Power Point must be active/open... from Excel execute the macro, it will take a Screen Capture of the active window and paste it in to Power Point... from Power Point execute that macro and it should trim/crop it to the size of the slide.

Best Regards,

This forum is the BEST... BusDriver2