Search results

the above code is not the complete code

Hi, Here is the some additional code for your reference. Sub SlideCopy() Dim newPowerPoint As PowerPoint.Application Dim newpres As PowerPoint.Presentation Dim activeSlide As PowerPoint.slide Dim sr As PowerPoint.ShapeRange Dim ni As PowerPoint.ShapeRange Dim fn As String Dim...

Hi All, Could anyone help me with this code please. Im not sure what im doing wrong here. But what im trying to do is to open a ppt file based on the name of the file. Basically "dept" in the below code is a variable where in the name can be any thing. The challenge is using a wild card. For...

thanks Fred.. will definitely try this...

Hey Fred... What im anticipating is that if the column position changes.. then what im looking at is in the changed table , i would need to first find the column with that particular heading and if it matches then execute the "countifs".. i understand that countif would work as per what you...

Hey Narayan, This is amazing... just what i needed... thanks a ton... Regards, Sam

Hi All, Could anyone help in writing a countifs formula by matching the headings. For ex: The target cell in which im writing the countifs should be able to execute the countifs function by searching for that particular column. Im not sure if im clear. Its more like.. in a table find this...

Sub CreatePowerPoint() Dim newPowerPoint As PowerPoint.Application Dim activeSlide As PowerPoint.slide Dim cht As Excel.ChartObject On Error Resume Next Set newPowerPoint = GetObject(, "PowerPoint.Application") On Error GoTo 0 If newPowerPoint Is Nothing Then Set...

Sub CreatePowerPoint() Dim newPowerPoint As PowerPoint.Application Dim activeSlide As PowerPoint.slide Dim cht As Excel.ChartObject On Error Resume Next Set newPowerPoint = GetObject(, "PowerPoint.Application") On Error GoTo 0 If newPowerPoint Is Nothing Then Set...

Sub CreatePowerPoint() 'Add a reference to the Microsoft PowerPoint Library by: '1. Go to Tools in the VBA menu '2. Click on Reference '3. Scroll down to Microsoft PowerPoint X.0 Object Library, check the box, and press Okay 'First we declare the variables we will be using Dim...

Here is the code... that i have.... i got it from Chandoo.org itself... can anyone tweak it to a copy range... Sub CreatePowerPoint() 'Add a reference to the Microsoft PowerPoint Library by: '1. Go to Tools in the VBA menu '2. Click on Reference '3. Scroll down to Microsoft PowerPoint...

Hi, I need to copy paste a range as a bitmap from excel to ppt. I have a code which copies individual graphs into seperate slides as bitmap images, however would need a code to copy a range. Could any one help. Would you need the code that i have. Regards, Sam

Hi, I have another problem here. There is a file with dyanmic graphs with named ranges which im using. However when i move/copy that worksheet into another excel file, the graph does not work. I've checked the named ranges everything remains the same however the graph just does not work...

well there is one problem again.. im basically using a 3d pie ..when i use the metafile option the the shadow around the pies are showing up as black dots.. since this is a business deck we are trying automate the copy paste action into ppt. also one strange observation is that at a view of 100%...

Hi All, This is Sam. I have kinda basic knowledge in Excel. Im trying to copy a set of pies at once as a single bitmap image from excel to ppt and somehow a part of the pies get greyed out when copying as a bitmap. This problem is occuring when trying to do the action both manually and via a...