Copying Selections To Power Point With VBA

Feb 23, 2009

I am trying to write a routine (via two comboboxes) that will enable users to select a choice of charts from one of three possible worksheets and have the charts on the selected sheet copied to PowerPoint. My difficulties are these:

a. I cannot determine how to pass the selections to Excel (see b. as well)

b. In some instances my charts are actually groups of a chart and a picture. how I should reference these? They are obviously not ChartObjects: when I use the macro recorder all I get is a range.

View 9 Replies


ADVERTISEMENT

Copy Tables Into Power Point

Apr 25, 2008

I have a question about coping table from exel into ppt, is this posible or not,

PS: i just need to copy a specific range of cells ex. A1 g17 into a slide in pp.

View 9 Replies View Related

Selected Range To Power Point Kinda...

Oct 7, 2008

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.

View 5 Replies View Related

VBA To Save And Close Power Point Presenation

Oct 16, 2009

I am using the following code to Open a presentation, and run a macro. Everything works fine, but I would like it also to Save the presentation and Close it.

View 7 Replies View Related

Excel 2010 :: How To Get Power-query And Power-pivot

Jun 28, 2014

How to get Power-query and Power-pivot for Excel 2010?

View 9 Replies View Related

Copying Variables In Selections

Jul 19, 2013

I am working on a macro, which should cycle through a column and find all rows with a given value. Then for these rows it should paste values from other columns into another worksheet.

Example:

1 2 3 4 5 6

Find all cells in row 6 with "yes" and paste the value from row 3 into another workbook.

Issue:

I cant seem to get the the value from row 3.

ActiveWorkbook.Worksheets(datasheet).Cells(rowtocopy, 6).Value.Copy has an error. Currently "Object required". Ive tried: .cells().value.copy that gives me a different error.

Script is started in the workbook where the extracted values should go.

Below its called "Template (2)".

The workbook with the rows is called "Datasheet" (which may be "Volume" or "SNiC data" depending on what is written in Worksheets("Template (2)").Range("B4").Value

Code:

Sub copychanges()
'################ EXTRACT ORIGINAL PAYMENT DATA

originaldata:

Dim currentwb As String, SuppXls As Excel.Workbook, datasheet As String, i As Long, targetcolumn As Range, modcorrect As String, fromcolumn As Range, rowtocopy As String
currentwb = ActiveWorkbook.Name
SuppPath = ActiveWorkbook.path & "" 'file path (assuming all file are in the same folder
SuppName = Worksheets("Template (2)").Range("D4").Value 'filename of corrected file

[Code]....

View 2 Replies View Related

Copying Non-adjacent Selections To End Of Range

Jun 21, 2006

I am using code that will copy several formulas in adjacent cells to the end of range; however, when I try to use it to select and copy formulas in non-adjacent cells, I get an error. Tried to modify, but I'm new to VBA...still learning. Here is the code that I currently have.

Dim LastRow As Long
LastRow = Range("A65536").End(xlUp).Row
Range("D3").Formula = "=RC[4]/RC[3]"
Range("F3").Formula = "=RC[-1]*RC[1]"
Range("J3").Formula = "=RC[-1]/RC[-3]"
Range("D3,F3,J3").Copy Range("D3,J" & LastRow)

View 6 Replies View Related

Swap 2 Mouse Click Selections After Resizing Selections

Jul 7, 2013

I am trying to take two random Mouse click selections and swap a set of ranges associated with the cells that are selected. For example if the user clicks on A1 it will resize(3,22) and store the selection as a variable to be swapped with another selection. Here is what I have so far but I keep getting a object required error on rngEmp1.

VB:
Sub SwapGroup()
If Selection.Cells.Count < 8 Then
MsgBox "Please Select two Groups to swap. Press and hold 'Ctrl' in between your selections", , "Swap Groups"

[Code] .....

View 4 Replies View Related

Automatically Change The Point Name To Match The Point Name In Column

Dec 10, 2008

I have a pivot table as shown below which is pretty straight forward however I am trying to create a macro that will automatically change the point name to match the point name in column E then copy that resulting dispaly to another sheet then pick the next point name in line and do the same thing and repeat for 50 rows, so my end result will be 50 pivot tables ready for printing. I can do this manually but I am trying to make it automatic...BTW the point names in column E change everyday but the pivot table supports the name changes.

Option Explicit
Sub PointName()
Dim Ws As Worksheet
Dim Rng As Range, Cel As Range

Set Ws = ActiveSheet
Set Rng = Range(Cells(2, 7), Cells(Rows.Count, 7).End(xlUp))

For Each Cel In Rng
Ws.PivotTables("PivotTable1").PivotFields("Point Name").CurrentPage = Cel & " "

Ws.Columns("A:B").Copy
Sheets.Add
With ActiveSheet
.Paste
.Name = Trim(Cel)
.Range("A1").Select
End With
Next
Ws.Activate
End Sub

I turned it off for a while and when I turned it back on I am getting an error
Unable to set the _Default property of the PivotItem class

Debugger is highlighting

Ws.PivotTables("PivotTable1").PivotFields("Point Name").CurrentPage = Cel & " "

View 9 Replies View Related

Tan To The Power Of Minus 1

Dec 10, 2008

How can i produce "tan to -1 " in excel ?

View 9 Replies View Related

More Sheet Power

Jun 27, 2006

im building a fairly intricate workbook at the minute but it is starting to slow down significantly lately as ive added more fromula's and sheets. I was hoping to make it even bigger but it looks like i might be stoped in my tracks. I have a reasonaby powerful computer and excel 2003. Does anyone know a way i could increase the capacity of this one particular workbook as it will be used by many people to enter data daily.

View 3 Replies View Related

To Find The Power ( I.e. ^ N) When You Have Other Variables

Mar 12, 2009

To find the power ( i.e. ^ n) when you have other variables.

Mathematical Perspective as well as through EXCEL..

Ex: 5^n = 125

We know that 5^3 = 125,

Now if I have been given the value 5 and 125 , then how do i get the answer 3 ( i.e ^ n) value...

I need to solve a slightly complex issue and therefore need help for the above requirement as well as to get the "n" value..

View 14 Replies View Related

Nested IF Formula (If Value In Cell R5 >0 Then Get The Value In Cel X29 On Power 4)

Jan 12, 2010

I am trying to do a nested if formula but I can't get it to work.
The condition is: If value in cell R5 >0 then get the value in cel X29 on power 4.

=IF(R5>0,POWER(X29,4)

View 2 Replies View Related

Type Numbers To The Power Of Number?

Jul 14, 2002

how can I type numbers to the power of something Say 12 to the power of 3. I want the 3 to be smaller and up off the line is that possible

View 3 Replies View Related

Mathematics - Power Trend Lines?

Jan 23, 2014

I am trying to fit a cooling graph with a trendline and I have found the power line to fit the best, as well as corresponding with Newton's law of cooling. However, I am not savvy enough to discuss how similar or dissimilar the two equations are!

the resulting equations from two different curves are as follows:

y=4305 x^-0.87733

y=4025 x^-0.91004

both fits have an R^2 of 0.996.

I am analyzing two scenarios of cooling the same object with three variables, one intended (the extraction of energy using water flow in one case, and no extraction in the other) and the others not under my control: different starting temperatures and different ambient temperatures. I need to understand if these are generally the same curve, or how very different are they? is there any statistical way to represent their relationship?

View 5 Replies View Related

Combination Of Pairs, Power And String

Aug 8, 2006

I have a string of n pairs and want to check various combination of that string.
Example: Pairs 58 78 15
Since I know I have 3 pairs (but it can be 2 or 4), I know the number of combination I want to test, ie 2 power 3 = 8 combinations. How can I program a code creating the various strings, ie 587815, 587851, 588715, 588751, 857815, 857851, 858715, 858751 ?

This is what I have so far (not much):

Public unique_pair 'number of pairs provided by another macro
Public mystring 'provided by another macro
Sub make_guess()

Dim number_of_combination, i
number_of_combination = 0


number_of_combination = 2 ^ unique_pair
For k = 1 To number_of_combination

'how to generate the various string ????

Next k
End Sub

View 9 Replies View Related

Power Pivot Chart With Stacked Column

Jul 30, 2014

I have created a Power Pivot Chart with Stacked Column chart. Made one axis as Secondary Axis and the axis is Clustered Column, but it is overlapped with Stacked bars.

Is there any easy way to solve this issue, apart from creating 2 dummy columns and making it work.

View 3 Replies View Related

Using Power Query To Do Multiple Searches On Website?

Jul 10, 2014

I've been trying to get power query to search a list of parcel numbers on an assessor site: [URL]. The problem I'm getting, every time you put in a different parcel number, you get the same URL for the results. I want to extract just a few pieces of information for each parcel search, but I can't initiate a search through excel. I'm thinking the problem is in the Data source settings. How can just get it to show me the assessors page results for a single parcel search in excel?

View 5 Replies View Related

Suspend/hibernate Sheet To Free Cpu Power

Apr 28, 2007

how to suspend/hibernate some specific sheets in one workbook , to free cpu power?

View 5 Replies View Related

Fill Chess Board Matrix To Power Of 2

Jun 3, 2007

i would like to write vba to fill a "chess Board" Matrix (8X8) With Powers Of 2...
starting with 2^0 and ending with 2^63...
(i suppose, click a button/icon and have the numbers fill in/populate...)

View 2 Replies View Related

How To Use Selections In One Combobox To Filter Selections In Another Combobox

May 8, 2008

I'm trying to use combobox1, say, department, to filter items listed in combobox2, say, employees. I don't want all employees from different departments listed in the combobox2 so as to make the user spend time looking, but only names of a particular department once that department is selected in combobox1.

View 9 Replies View Related

Lower Screens Brightness To Save Power When Desired

Feb 21, 2012

Have a system that runs 8 monitors on one computer. 4 are very large screens. Creates a lot of heat and uses much power.

Is there a way to dim the screens brightness in VBA. Looked all over and can't find any code.

Not really looking for a screensaver as they can cause interrup problems etc if I have programs running for hours. And I can't just turn off some screens as then desktop icons placements get scrambled.

Just want to dim screens with a macro, then undim it. Don't need to have it linked to the mouse movement, but that might be nice too.

I tried a macro that said "Dim MyScreens" but nothing happened.

View 8 Replies View Related

VBA Code To Configure Windows Power Management Settings

Jun 25, 2009

Is it possible to modify the windows power settings in excel vba. I have this example, but it doesn't do anything.

Sub testPOWERCFG()
CreateObject("WScript.Shell").Run "POWERCFG /CREATE Custom1", 0, False
CreateObject("WScript.Shell").Run "POWERCFG /CHANGE Custom1 /monitor-timeout-ac 15", 0, False
CreateObject("WScript.Shell").Run "POWERCFG /CHANGE Custom1 /monitor-timeout-dc 10", 0, False
CreateObject("WScript.Shell").Run "POWERCFG /SETACTIVE Custom1", 0, False
End Sub

I need some code to create and activate a scheme whereby everything is on and also some code to revert back to the default settings on the machine.

View 3 Replies View Related

Excel 2013 :: Power Pivot Summarize Value By Category From Total?

Apr 17, 2014

Using Excel 2013.

Trying to create a Calculated Column in a table to put Expense in 1 of 4 categories

I came up with =CALCULATE(sum([TotalExpense]),FILTER(factExpense,factExpense[ExpnseType]="Sundries"))

But that is returning total instead of a total for each record What did I miss?

This works for the first Calculated column: =CALCULATE(sum([TotalExpense]),FILTER(dimExpense,dimExpense[Type]="Sundries"))

But as soon as I copy the formula to the next column and update the type to "Wines_Spirits" I get

A circular dependency was detected

Found the answer on SQLBI website I added a unique id to each row and in Table Behavior in the Data Model set the Unique_ID as the Row_Identifier

[URL]

View 1 Replies View Related

Excel 2013 :: Power Pivot DistinctCount If Another Field In Table Is Greater Than Zero

Apr 21, 2014

Using Excel 2013.

I am trying to get DistinctCount from a field if another field in the same table is greater than zero.

PowerPivot DAX -COUNTIF

[Code] .....

The count returned includes all not just values greater than zero. How can I get just values greater than zero?

View 1 Replies View Related

Create Report Using Power Pivot While Creating Relationship Between Linked Table?

Apr 24, 2014

I want to create a report using power pivot while creating the relationship between the linked tables, power pivot is throwing error "The relationship cannot be created because each cilumn contains duplicate values. Select at least one column that contains only values"

View 1 Replies View Related

Forcing Excel To Show Numbers In Scientific Notation To A Constant Power?

Mar 8, 2013

I need to have all of my number be "x10^-6", but Excel wants to make them, for instance, 7.66x10^-3, when I need it to read "7660x10^-6". How can I force excel to do this?

View 3 Replies View Related

Listbox Selections

Apr 19, 2006

I have a userform with multiple buttons and a listbox. When any button is clicked on, a listbox is created. The user selects various items on the listbox. Then the user clicks another button and selects other items based on a new list. If user goes back to click the original button, the original list shows up, but the selected items are not highlighted. Is there any way to keep those original selections highlighted (selected)?

View 9 Replies View Related

Pasting Multiple Selections Next To Each Other

Jun 13, 2013

What I'm trying to do is to select multiple groups of cells (say 5x4) which are below each other, but then paste them next to each other

For example, copy cells A1:E4, A8:E11, A15:E18 and paste them to A20:E23, A23:E26, A27:E26

View 2 Replies View Related

Order Selections Contigously

Dec 15, 2008

On one sheet I have a long list of items which I need my users to scroll down and, when needed, fill in a value next to the appropriate item in the list. Most of the list items will not need anything inputting against them. Then on a different sheet I need a nice tidy summary list which only shows those list items which have an input against them.

The bit I can’t do is getting these few items to display (on a separate sheet) in a nice neat all together, contiguous way - ie with no gaps. Also I need to populate this summary list automatically. ie after each entry.

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved