Recent content by jreddy

So I extracted our corporate theme from PowerPoint by saving the presentation as .thmx file. Then created new Page in Excel VBO with a following code: Dim wb as Object = GetWorkbook(handle,workbookname) wb.ApplyTheme(themePath) Where themePath is a Strin with a full path to the theme. It all...

As I mentioned above, Shapes returns a collection of Shape-objects on the slide, thus referencing a single Shape-object from that collection (aka .Shapes(1)) should provide you with a Chart property. I implemented exporting charts from Excel a long time ago and it all works fine there. I just...

Hi VJR, Check this link: https://docs.microsoft.com/en-us/office/vba/api/powerpoint.shape You can see that there is a Chart-proprety under Shape properties. Also it gives me a suggestion in VBA Editor when I start typing it, and no compile errors. Chart pops up in the folder and is totally...

Hi VJR, Chart is a property of a Shape object, which is being returnedfrom a Shapes collection. It turns a generic Shape object into a Chart object, thus I can use an Export method of a Chart object. Here is PowerPoint macro code: ActivePresentation.Slides(1).Shapes.Paste...

It's the address where to save the image, like "C:\Users\username\Documents\chart1.png". Attached the screenshot with inputs for the respective action stage in the process.

Hi VJR, imgPath is a String. See screenshots for details.

Hi, I have to create reports and Charts in Excel and then send them to respective managers. Charts must use our corporate color scheme, which is not available in Excel. Thus I've written a code stage in Existing Excel VBO to copy charts to PPT, where the right color scheme is automatically...

Hi guys, I just wanted to share with you some findings, that I encountered while creating code stage for inserting Pivot Table in Excel. In one case I was getting Type Mismatch error while trying to add a Pivot Table. This was the case only in one document. After some research I found ou that...

Hi @owns thanks for sharing this VBO! Can I also upload files to SharePoint using this VBO? UpdateItem doesn't seem to be meant for that. Can you please advise me on the matter?

Hi @VJR makes sense, double referencing is not quite smart, my newbie mistake :) Thanks for your solution, it works perfectly!

Hi @Aparna How did you set up your Blue Prism then? As I said, I'm using MS SQL Server 2017 Community Edition running on my local machine, if you have some kind of dedicated BP-server, you might not be able to modify databases on it and will have to contact the server administrator. Anywas...

Hi @VJR today I tried adding a pie chart to the worksheet that contains whitespaces in its name and got an error "HRESULT: 0x800A03EC". I suppose that the problem is reference to the name with whitespaces, because it works fine otherwise. Do you have any idea how I can fix that? I already...

Hi @VJR I used your code to create pivot tables, but added the line to create a DataField: new_ws.PivotTables("PivotTable1").AddDataField(new_ws.PivotTables("PivotTable1").PivotFields(valueField), "Anzahl", -4112) I'm trying to create a pivot table, which uses the same column for row fields...

Hi VJR, thanks for your hint, it solved the problem. I forgot about to properly reference the Range object while converting the code [facepalm]. Yes, it was indeed showing a properly constructed chart. I even tried removing the SetSourceData line, leaving only ws.Shapes.AddChart2(262, -4102)...

Hi Aparna, I had the same error. Currently I have Blue Prism running locally on my machine for learning purposes and use MS SQL Server 2017 Community Edition. My problem was, that the database I was using reached a maximum size for Community Edition (around 10GB, have no idea what it was saving...