HI
I have created a powerpoint presentation using vab code. I cannot post the code so i am describing the layout of the ppt and the queries I have below:
Layout of the PPT.
a. slide 1 Contains a templated title page from the company with default background of the company.
b. slide 2 contains only the default header and footer colors from slide 1 , but has plane white color as the background.
c. slide 2 has some text boxes, some rectangles, some ole objects that are charts and excel tables pasted using the excel macro.
d. the text boxes in slide2 are updated by pasting the values using cocatenation of two excel cells.
e. from slide 3 till can vary till about 50 slides that need to be determined dynamically. but the background should be the same as slide 2 till the end.
f. there is a default slide as the ending/last slide in the template.
g. tables from excel worksheet are pasted in the slides as ole objects from 3 till last slide determined dynamically.
h. there are some hyperlinks in these tables that should open on clicking it.
i. also based on some criteria some slides should have only 5 rows pasted and some slides can contain the complete table.
below are the questions i have:
1. how can i autoupdatethe values of each of these objects/delete the objects by dynamically identifying them?this is for objects pasted in slide2? currently the code i have written pastes objects on the existing one whenever the macro is executed.
2. how can i dynmically add the slides by using slide 2 as the template for slides 3 to the last slide(except th default last slide from the template). also i will need to delete the existing slides from slide 3 while doing this so that the tables are not pasted on each other when the macro is run.
3. each of these tables has hyperlinks that i am currently unable to open. how can i do this.
4. it will be helpful if i can get the code for query "i" also.
please help me with syntaxes for each of the above. i have tried picking up solutions using different syntaxes but they didn't help.
please help me at the earliest if possible today!!
Thank You very much for th help!!
I have created a powerpoint presentation using vab code. I cannot post the code so i am describing the layout of the ppt and the queries I have below:
Layout of the PPT.
a. slide 1 Contains a templated title page from the company with default background of the company.
b. slide 2 contains only the default header and footer colors from slide 1 , but has plane white color as the background.
c. slide 2 has some text boxes, some rectangles, some ole objects that are charts and excel tables pasted using the excel macro.
d. the text boxes in slide2 are updated by pasting the values using cocatenation of two excel cells.
e. from slide 3 till can vary till about 50 slides that need to be determined dynamically. but the background should be the same as slide 2 till the end.
f. there is a default slide as the ending/last slide in the template.
g. tables from excel worksheet are pasted in the slides as ole objects from 3 till last slide determined dynamically.
h. there are some hyperlinks in these tables that should open on clicking it.
i. also based on some criteria some slides should have only 5 rows pasted and some slides can contain the complete table.
below are the questions i have:
1. how can i autoupdatethe values of each of these objects/delete the objects by dynamically identifying them?this is for objects pasted in slide2? currently the code i have written pastes objects on the existing one whenever the macro is executed.
2. how can i dynmically add the slides by using slide 2 as the template for slides 3 to the last slide(except th default last slide from the template). also i will need to delete the existing slides from slide 3 while doing this so that the tables are not pasted on each other when the macro is run.
3. each of these tables has hyperlinks that i am currently unable to open. how can i do this.
4. it will be helpful if i can get the code for query "i" also.
please help me with syntaxes for each of the above. i have tried picking up solutions using different syntaxes but they didn't help.
please help me at the earliest if possible today!!
Thank You very much for th help!!