Hello All,
I am having issues with a really simple task. I have a chart worksheet and am trying to save it to PDF. I tried to define the chart in two ways as worksheet chart and as an chart object.
Dim chrt As Chart
Set chrt = sourcewb.Sheets("CommodityUsageChart") ' Worksheet is a chart
Set myOBJChart = Sourceworkbook.Charts(1) 'chart as an object
Here is the real issue, when I try different variations of export as fixed format I always get syntax errors. Obviously my line construct is incorrect. Any help world be greatly appreciated.
chrt.ExportAsFixedFormat(type:=xlTypePDF, Filename:=ComUsagecHARTPDFFname ,Quality:=xlQualityStandard ,OpenAfterPublish:=True
I am having issues with a really simple task. I have a chart worksheet and am trying to save it to PDF. I tried to define the chart in two ways as worksheet chart and as an chart object.
Dim chrt As Chart
Set chrt = sourcewb.Sheets("CommodityUsageChart") ' Worksheet is a chart
Set myOBJChart = Sourceworkbook.Charts(1) 'chart as an object
Here is the real issue, when I try different variations of export as fixed format I always get syntax errors. Obviously my line construct is incorrect. Any help world be greatly appreciated.
chrt.ExportAsFixedFormat(type:=xlTypePDF, Filename:=ComUsagecHARTPDFFname ,Quality:=xlQualityStandard ,OpenAfterPublish:=True