Paste named range from Excel to Powerpoint into named shape - VBA



I want to build a macro that connects our Excel-Data-Sheet with our Reporting-Powerpoint-Presentation.
So I have this named Range ("A") selected and copied.
Then I want to paste the data into a shape in Powerpoint which has the same name as my Range ("A").


Sub SyncWithPPT()
Dim pptApp As PowerPoint.Application
Dim pptPres As PowerPoint.Presentation
Dim pptShape As PowerPoint.Shape
Set pptApp = New PowerPoint.Application
pptApp.Visible = msoTrue
Set pptPres = pptApp.presentations.Open("workingPath")
ActiveWorkbook.Names("A").RefersToRange.Select
Selection.Copy
Set pptShape = pptPr

View Replies

Related to : Paste named range from Excel to Powerpoint into named shape - VBA


Excel "Named Range" Manager - To edit BOTH the Named Range - PLUS the VBA Code References to them?
Category : Excel
Hi,
I'm hoping for good news on this question...
Does anyone have a Named Range Manager Tool that changes the VBA Code at the same time as you change the Named Range in the workbook?
I have about 200 named ranges I have to edit, and I also have CODE attached to every one of them!!!!

View Replies


Export to named range in excel with named ranges within the data
Category : Access
Hiya,
I'm having a bit of fun getting my exports to work!!
I'm exporting a few queries to populate up a nice pretty excel report.
From the excel perspective, there's the 'Data' range, a couple of 'Lookup' tables & the control date (month the report is for)
I've got the D

View Replies


Excel VBA loop named range paste non blank cells to Summary Sheet
Category : Excel
Dear All,
I have made an extract of main file. There are multiple tabs called UK and UK1
Name Range
<TABLE style="WIDTH: 187pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=249><COLGROUP><COL style="WIDTH: 88pt; mso-width-source:

View Replies


Macro to paste to a named range but paste ONLY IN NON BLANK cells in said range
Category : Excel
Is it possible to build a macro which copies from a range and pastes these copied values to a NAMED range but only paste in empty or blank cells in said named range ??
So far I have built this code but any new entries I wish to NOT overwrite older entries when macro had been used at an earlier

View Replies


[Word] Copy/Paste data from Excel named range to a Word bookmark
Category : VB & VBnet
Is it possible to take the data from a named range and paste it at a bookmark inside a table within a Word document? I'm struggling to even call Excel from Word at the moment :(
I know I could use mailmerge but that is causing me problems and so am trying to come up with a work around.
Or

View Replies


check several named range then cells inside the chose named range
Category : Excel
Hi everyone,
I would need some help with a code I'm writing.
I get from a form several data : vehicule , txtdepart, txtfin
vehicle is the choice made from a combobox among the list of all vehicles
txtdepart is the starting date
txtfin is the finishing date
In 1 sheet &q

View Replies


Linking to PowerPoint: Named Range Mystery
Category : Excel
Hi
Thanks in advance for the help with this. It's driving me crazy.
I'm having a problem linking my named ranges in an Excel worksheet to PowerPoint.
I select the named range in Excel
Copy it
Switch to PowerPoint
Double-click into a Chart
Click Edit > Paste Li

View Replies


Copy values from a range and paste into next open row in a predefined named range via VBA
Category : Excel
I have a range of cells that get updated on a weekly basis by pulling data using SUMPRODUCT. I have defined a named range for this 'weekly summary' data aptly called "SourceData". What I need to be able to do is 'archive' these weekly counts by copying and pasting (I need to transpose and

View Replies


How to paste into a Named Range in VBA?
Category : Excel
Hi folks,
So im trying to copy data from one named range into another using the code below:
Code:
        Set WBK = XL.Workbooks.Open(file)
        Di

View Replies


Copy/Paste Named Range
Category : Excel
If I am copying and pasting a named range like the following
Code:
    On Error Resume Next
        wkbDataFile.Worksheets("Preferences").Range("Admin

View Replies


2012 / 2017 Copyrights BigHow , All Rights Reserved .