M
muniz
In my job, I've got to send a report (.xls) by email to the management,
result from a Macro in Excel. But the file must be the most visual as
possible (to please the eyes) and the smallest as possible, so I intend
to send a file only with the graphs created by my Macro, and not the
sheets with the data source (huge).
My problem is that the file to be sent, when opened, asks: "would you
like to update the data in the graph?". If a manager presses "yes", the
graphs won't be able to update (the data source will be in my PC, not in
theirs), and won't show a thing. Obviously, they will start doubting my
skills (the fault is never from the management, always from the slave
worker).
How to avoid this automatic refresh and the question? I was told to
create a Macro to use the open file event, but the file to be sent is
created as a new file, result of my Macro. How can I "infect" this file
with a macro like that? And what would it be like?
(Sorry about my bad english)
result from a Macro in Excel. But the file must be the most visual as
possible (to please the eyes) and the smallest as possible, so I intend
to send a file only with the graphs created by my Macro, and not the
sheets with the data source (huge).
My problem is that the file to be sent, when opened, asks: "would you
like to update the data in the graph?". If a manager presses "yes", the
graphs won't be able to update (the data source will be in my PC, not in
theirs), and won't show a thing. Obviously, they will start doubting my
skills (the fault is never from the management, always from the slave
worker).
How to avoid this automatic refresh and the question? I was told to
create a Macro to use the open file event, but the file to be sent is
created as a new file, result of my Macro. How can I "infect" this file
with a macro like that? And what would it be like?
(Sorry about my bad english)
