by shivakumar (3 Submissions)
Category: Microsoft Office Apps/VBA
Compatability: Visual Basic 5.0
Difficulty: Intermediate
Date Added: Wed 3rd February 2021
Rating: 
(4 Votes)
It creates an Excel graph [using Excel] and converts the graph to an WebPage.
Inputs
chartTitle As Variant, categoryAxisTitle As Variant, valueAxisTitle As Variant, seriesTitleA As Variant, categoryAxis As Variant, seriesDataA As Variant, seriesDataB As Variant, folderPathForWebPage As String, fileNameForWebPage As String
Assumes
You have a project named [WebPageCreation] and have a command button to execute the process, in that you will construct the params needed to create an excel graph and the path to store the result as WebPage.
And also you have an Excel Sheet named [ExcelChart] in that you have a macro named [DrawBarChart] and a method that saves the graph as WebPage [CreateWebPage].
Code Returns
As Boolean
Side Effects
-
API Declarations-
Download ExcelGraphAsWebpage (14 KB)
VBcoders