Excel VBA Objects: Chart Object (Part 1)

Рет қаралды 2,751

Жыл бұрын

Get the Excel VBA Objects Guide for Intermediate with extended and revised content here: excelmacroclass.blogspot.com/...
Welcome to the Excel VBA Objects Series. In this video we start working with the Chart object, and we learn how to add and format a chart sheet with Excel VBA. We'll also see how to copy charts and look a chart events. In the next video of this series we will work with embedded charts in Excel VBA.
ChartType Enumeration here:
excelmacroclass.blogspot.com/...
Find more content and numerous macro examples and other Excel VBA learning materials in the Excel Macro Class blog under the direct link: excelmacroclass.blogspot.com/
And yet, if you want more, you can find various Excel templates, dashboards, and applications of different nature in the other blogs of the Excel Macro Mania saga:
Excel Macro Fun (excelmacrofun.blogspot.com/)
Excel Macro Business (excelmacrobusiness.blogspot.com/)
Excel Macro Sports (excelmacrosports.blogspot.com/)

Пікірлер: 2

@DanishKhan-sh1fe Жыл бұрын

Hello, I have been following you for a while, and your videos have been helpful in solving complex problems in VBA. Recently, I came across an interesting topic: SSO OAuth2 Authorization in VBA. Many people seem to be struggling with this, but I'm wondering if anyone has managed to solve it. This issue involves interacting with a browser, specifically Internet Explorer, but even after interacting with it, extracting the required API response header seems to be a challenge because using "InternetExplorer.Application" can extract the webpage element not the Network Headers Tokens. I wanted to request a video tutorial on this important Topic, as I believe you an advanced expert could provide a solution. There are likely many others who are also searching for answers in this area. If this goes possible then there will be huge positive Impact on data Analyist People. Thanking you.

@ExcelMacroMania Жыл бұрын

I implemented that a while ago with IE, but that's not working anymore with Edge (requires some sort of browser automation like using Selenium for example). Have a look at this article from desktop liberation, but that's all for IE only: ramblings.mcpher.com/guests-articles-and-postings/oauth2-and-vba/