![]() ![]() Make sure you place and size the object on your PowerPoint slide to exactly the size and position you need before running the macro! It will return a message box with the dimensions of the object. You need to paste this code into PowerPoint VBA and run it there. I cant take credit for the code but it works. I've been trying to do the same thing and found a useful piece of code from Retrieve The Dimensions Of A Shape In PowerPoint - The Spreadsheet Guru ![]() 'Step 5: Paste the picture and adjust its position 'Step 3: Add new slide as slide 1 and set focus to it 'Step 2: Open PowerPoint and create new presentation I'm very new to VBA so any help, however simple, would be very appreciated. However the table is way oversized and I would like to try and define specific height and widths for each table to eliminate manual resizing.Ĭan anyone suggest an update to the below code to implement height and width to ensure the table fits in the presentation as required? I have created a module in my excel spreadsheet and running the macro sends a copy of the table in excel to powerpoint. Hi I found the below VBA code online (the 'for dummies' website).
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |