Need to drill a hole into a bitmap in excel.
Have pasted a "print screen" bitmap into an excel worksheet.
How do I cut a square in the middle of the bitmapped image so that an excell cell is visible.
Why do we look into our handkerchiefs after blowing our nose?
I have an excel spreadsheet inclusive of information and a button. When the button is clicked a 'userform' appears displaying a bitmap (simply a picture pasted into an object box, created in the VBEditor). I want to be able to copy the bitmap so as the end user can paste the image in another document.
I noticed that I can use ALT PrintScrn, but this will display the surrounding borders, i.e. the userform border and title bar at the top with the close 'X' on the right. I would ideally like to be able to just select the image in the userform for save/copy. I know I can use the above mentioned proceedure, then select the copied image and paste it into 'Paint' then select only the areas of the image that I want to use. However I feel for the purpose of my target end users a simple copy and paste procedure would be more beneficial.
I have a simple Excel VBA range copy as bitmap and paste to powerpoint which works fine except. I am using an excel sheet for the user to provide information regarding file name and range to copy/paste. I need the ability for the user to run a macro in the workbook that they are copying from prior to the copy. This macro updates data from an external source.
I think the problem is that, when I run the macro, the copy paste occurs before the range is fully updated. I have tried inserting Application.Waits and saving the file before the copy, but no luck. I use a split screen to watch this, the PowerPoint paste flashes, then the copy cells update. The picture pasted to PowerPoint is the correct size and in the correct postion but is blank.
I don't thinks that this impacts anything, but the contents of the copy cells are graphs. I usually have 12 graphs in the range that copy/pastes.
Workbooks.Open Filename:=strFullName
Set wkbCopy = Workbooks(strFile)
wkbCopy.Activate
If strMacro <> "" Then
Application.Run "'" & strFile & "'!" & strMacro
ActiveWorkbook.Save
End If
'Application.Wait TimeSerial(Hour(Now), Minute(Now), Second(Now + TimeValue("00:00:30")))
wkbCopy.Worksheets(strWksht).Range(strCopyRange).Activate.....................
I'm using Windows 7, Excel 2010 on PC. I have a graph set up based on my teams performance. Below I will attempt to lay out the graph and what I'm looking for. What I'm trying to make happen here, is have my jpeg, or bitmap which is represented by 0 to move as the graph increases or decreases. Example, right now if I input my data and sayJ.P. increases two points I end up with this -------0--. Or if Y.P. decreases by two points I end up with ---- 0. Is there anything I can do to have my picture adjust with the graph?
Name
J.P
-------0--
A.E
----0
Y.P
---- 0
M.K
-----0
H.R.
----0
Points
Attached is the spreadsheet I am working on, log sheet and example sheet. As you can see from the example sheet I have location, Equipment type, equipment id and some others. As you can see on the log sheet, at the moment people select the information from validated cells, but if they select Point Machine from the equipment type list they have to scroll through all the equipment ID’s when they only really need to see 10 equipment ID’s relating to Point Machines. Is there a way to get the validation cells to do this or is there another way. I am very very new to VBA if this is an alternate way to do this.
View 2 Replies View RelatedIs it possible to produce a dynamic bar graph for instance where if I click on a bar it drills down and displays the source data?
View 1 Replies View Relatedit possible to get a drill down of multiple cells from a pivot table into the same sheet easily, as when I use
Range("BE23:BE26").Select
Selection.ShowDetail = True
it only pulls out the first drill down (i.e. the equivalent of double clicking BE23)
I'm sure there's a work around I can write which performs each drill down separately then combine the sheets, but it's probably going to end up fairly longwinded!
When you double click on data in a pivot table this brings up the drill down info. Is it possible for this to appear in a new workbook rather than the active workbook?
Any help if grately appreciated. If you need more information please post what you require and i will reply.
I've just set up a workbook full of pivot tables linked to an access database. The book will be used by several individuals interested in both the statistics presented in the tables and in the details underlying them. My concern is the accumulation of the extraneous sheets generated by drilling down to details. Is there any code I could use that would delete these sheets as soon as the user leaves them?
View 4 Replies View RelatedIs there any way to change the format for pivot table sub data? Or maybe use a marco for it. The data table that appears when you double click any field on the pivot table range.
View 6 Replies View RelatedI want Pivot Table Drill-down result in New excel file. when I have a pivot table, When I double click any data cell, the result comes in the new sheet(Drill-Down) of the same file BUT I want the same result to come in a New Book (a new excel sheet) and not in the same file.
View 3 Replies View RelatedI have a question that is bugging for quite some time, see if you know. Is it possible to insert a data validation drop-down menu to a pivot tables drill down data automatically?
I really do believe that pivot tables should have this option, it would make data validation much more easier. I going to suggest that to the guys developing Office 14, according to them the new Office will more Business roled based. Lets wait and see a !
Attached is a file which shows the problem. I bascially have two headings. The first heading contains the letter "b" 9 times but only has values against two "b"s. When this is entered in a pivot table and the value is drilled down (in this case 3, highlighted in yellow), I only want the numbers attached to the two "b"s to be shown rather than all the 9 b's (thereby omitted all the zeros).
View 3 Replies View Related