• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

excel VBA to compile a pdf or PPT based instructions given in an excel table

T

Tetonne

Member
Good evening to all

I am looking for this feature to develop.

Imagine a standard excel file, no matter its content, the number of tabs. There would be graphs, data tables distributed in the tabs ...

In a last tab, a macro to launch (to develop) based on the information table for the construction of a powerpoint or a pdf.

In the table of this last tab the instructions for the creation of the presentation document (ppt or pdf)
we would find :
- in the 1st column the target page
then in the following columns...
- the title of the dia: cell T56 of tab A
- the data range of the table (A3:T17) of tab B
- another data range of another table for example (A3:T17) of the tab C
- graph available in tab ....

in one click on the button, Excel requests PDF or PPT
and then copy and paste the data in values or images (according to a general setting or to the media.

What do you think about it?
Who has this talent
the interest is to have a macro with the tab of instructions that can be put in any excel document...

Thanks for your help
 
Last edited:
Great thanks again for this share
Do you think it will be possible to export graphic
The same way with instructions table?
Have nice day
 
Tetonne
Didn't You test Yourself to add new line to instructions-sheet?
> cell A6 4
> cell B6 graph
> cell C6 Feuil1!$J$16:$O$30 ... or any range, which You would like to get to PDF
Ps There could be other ways too, but with my Excel, this works as I could use it.
 
You must log in or register to reply here.
Back
Top