crop

Hi there, My goal is to delete the cropped space of images that is currently unused. That is, after an image has been cropped, I want to use "compress picture" function in excel/word/powerpoint to batch process this over multiple files. My problem is that I can do this just fine in excel...

Hello All, I'm working on a first in first out orders vs inventory spreadsheet. <tbody>#DAE7F5[/URL] "] A B C D E F G 1 Crop Item Qty Item Order Date Qty 2 1 A 10 #000000[/URL] , align: center"] A 1/1/2019 50 3 4 A 20 #000000[/URL] , align: center"] A 1/2/2019 30 4 6 A 30...

Hello! I am attempting to follow the advice found in a blog by the fine people at PowerPivotPro (https://powerpivotpro.com/2018/01/star-schema-switch-drill-income-statement-design/) and have most things in place, with exception of the header sort sequence. Below is the header table that is...

Hi, I am using the code: <!-- BEGIN TEMPLATE: bbcode_code --> <code>ppApp.ActiveWindow.Selection.ShapeRange.PictureFormat.CropRight = 10</code> <!-- END TEMPLATE: bbcode_code -->to crop the image on the slide, however it gives the possibility to crop by fixed size (10). Is it possible...

Hello, I am attempting to use VBA to crop images to a 1:1 aspect ratio. Here is the code that I am using currently: With shp Width = .Width Height = .Height TCrop = Width - Height Hcrop = TCrop / 2 End With With .PictureFormat .CropLeft = Hcrop .CropTop = 0 .CropBottom = 0 .CropRight = Hcrop...

Hello, I have searched the internet and these forums pretty extensively trying to come up with an answer to my question. Essentially, I am trying to take an image with an aspect ratio other than 1:1 and crop it to an 8 inch by 8 inch size. I have found that 72 points should correspond to 1...

Good Afternoon Community! I have been helped countless times thru all of the posts on this forum (THANK YOU!) but I'm truly stuck this time. I don't have any experience with VBA so I'm trying to accomplish this all using formulas. Here's the problem: Problem: I'm trying to set up a Time in...

Hi I wonder if anyone could help , I can not get the Horizontal format Image (Jpeg Photos) menu to appear which allow me to crop or to set transparent backgrounds.. I only can see the vertical menu of the Format Picture in which these options are missing. I can not set transparent back ground...

Hello Excel gurus! My code is: Sub Insertwinds1() ppath = "winds.webimage.url" With ActiveSheet.pictures.insert(ppath) .left = Range("A2").left .top = Range("A2").top .ShapeRange.PictureFormat.CropRight = 70 .ShapeRange.PictureFormat.Cropleft = 130 .ShapeRange.PictureFormat.CropTop = 300...

Hi all, I have a macro below that inserts an image from my C drive into an excel sheet an although this works nicely for what I need, I now need to get it to crop and move back to the right place when it has been cropped. does anyone know what i need to add to the code to get this to work? Sub...

Hello, I insert an AutoCad object like I always do and it simply won't let me convert it to an image and resizee and/or rotate the image. There is another computer with Office 2007 (the 1 prior to 2010) and it works perfectly. Your help is appreciate. Thank you, Mr. Alexander