mitsuirows
New member
- Joined
- Jan 20, 2019
- Messages
- 3
- Reaction score
- 0
- Points
- 0
- Excel Version(s)
- 2013
Hey guys,
I'm creating a simple web dashboard. Basically, twice a day, I need to submit a quick update. I automated a lot of this already through a series of vlookups, and grabbing external datas. The most manual part is having to save images of about 10-15 charts, resize, then upload them.
What I would like:
A way to build a macro that can take all charts on a sheet or workbook and output them as PNG or JPG directly to a remote destination. Ideally: it can also create the charts with the same styling (currently thinking about creating charts with "source" styling and copy + special paste format onto generated charts).
The biggest roadblock I have right now is getting Excel to authenticate and remote into server.
Company is not using Sharepoint so I cannot use it as an intermediary.
Has anyone done anything similar to this or can point me to a resource?
I'm creating a simple web dashboard. Basically, twice a day, I need to submit a quick update. I automated a lot of this already through a series of vlookups, and grabbing external datas. The most manual part is having to save images of about 10-15 charts, resize, then upload them.
What I would like:
A way to build a macro that can take all charts on a sheet or workbook and output them as PNG or JPG directly to a remote destination. Ideally: it can also create the charts with the same styling (currently thinking about creating charts with "source" styling and copy + special paste format onto generated charts).
The biggest roadblock I have right now is getting Excel to authenticate and remote into server.
Company is not using Sharepoint so I cannot use it as an intermediary.
Has anyone done anything similar to this or can point me to a resource?