Convert an Excel file into a PowerPoint file with one click of a button

[GaryDrummSr]

Part of a new assignment is to create an EIS Report for management.
EIS is an acronym fro Executive Information Summary.

We are a factory that makes multiple products, and we endeavor to keep track of the frequency of errors, and the hours of production lost in the process, once every 24 hours.

I pull the data and make an Excel spreadsheet, with charts in Excel to show trends, etc.

I must then convert the whole thing into a PowerPoint presentation, which gets posted on a board by the machine.

We probably have over 100 machines, but I am only responsible for about 1/2 of that getting done.

Is there a way to automated the conversion of Excel files (sheets at the bottom of one page)?

I am vaguely familiar with Macros, but I'm hoping there is something already in place that we just,don't know about.

I use Excel 2016.

Thanks,
Gary

 

[GaryDrummSr]

Re: When I tried to save it it said I cannot save it in a Macro Free zone.Re: Convert an Excel file into a PowerPoint file with one click of a button

gravanoc,

I heard back from IT, and their position is that they don't support Macros.
Partly for the security reasons, but more so because the creator is usually someone who must be on hand to troubleshoot it
If that person leaves the company etc., then there is no one around who knows how to fix it etc.

I've have now turned the decision to pursue or not pursue over to my boss.
Hopefully I will have a reply by Monday.

Thanks for your willingness to help.
Its a shame that the IT techs of the world can't be more supportive, but I understand their position.

I appreciate your efforts.
Gary

 

[gravanoc]

Re: When I tried to save it it said I cannot save it in a Macro Free zone.Re: Convert an Excel file into a PowerPoint file with one click of a button

No problem. I'll be around if needed.

 

[GaryDrummSr]

Re: When I tried to save it it said I cannot save it in a Macro Free zone.Re: Convert an Excel file into a PowerPoint file with one click of a button

No problem. I'll be around if needed.

Thank you sir,
Have a great weekend

GAry