Search found 4 matches

by SmokeyTBear
03 Dec 2016, 16:11
Forum: Tutorials
Topic: MS Office COM Basics
Replies: 110
Views: 81528

Re: MS Office COM Basics

Kon: You are the guru on the mountain! I cant say enough how much I appreciate this! The code so far works well, I thank you! I have a few questions: How should I approach setting up the body of the email with either the pivot table itself, or a block of text that is the warnings array, with warning...
by SmokeyTBear
02 Dec 2016, 10:41
Forum: Tutorials
Topic: MS Office COM Basics
Replies: 110
Views: 81528

Re: MS Office COM Basics

Kon: Thank you so much! I have been stuck on this longer then I care to admit. The VBA output of what I need to do to the chart still is: Sub Macro1() ' ' Macro1 Macro ' ' ActiveChart.PivotLayout.PivotTable.PivotFields("Time").Orientation = xlHidden With ActiveChart.PivotLayout.PivotTable.PivotField...
by SmokeyTBear
29 Nov 2016, 07:56
Forum: Tutorials
Topic: MS Office COM Basics
Replies: 110
Views: 81528

Re: MS Office COM Basics

I wrote the code below to parse a system generated email, create a chart, and email the chart and formatted data to recipient, Got it to the point(sloppy im sure) that the chart gets created, the only things im missing is adding "warning" to the legend field in the pivot table, and changing Axis(cat...
by SmokeyTBear
27 Nov 2016, 07:46
Forum: Ask For Help
Topic: Creating Pivot table and chart In Excel COM
Replies: 2
Views: 898

Creating Pivot table and chart In Excel COM

I am trying to create a pivot table, and then a pivot chart from ahk for embedding into an email. I am a total noob, so please forgive my code quality. I am having trouble getting my pivot table set up right, and cannot get a chart to appear for the life of me. I have included references to what pos...

Go to advanced search