Macro to get Data from Access, create a Diagram and save as HTML.
Posted by Anders Bengtsson on January 22, 2002 6:18 PM
Can a Excel Macro do what I mention below??
*Check current year+month
*Get DATA from Access corresponding to year+month
*Create a Diagram with the DATA of this month.
*Save the Diagram as HTML (and also name it something like "2002-01.HTML" or "2002Jan.HTML" depending on which year+month it is).
It has to be fully automated and require no manual input. I will call the Macro once/day.
(If someone knows this can more easily be done within MS Access then lemme know;)