Export Excel tab to PDF and PPT

[enowapi]

Hello,


I have a model that display regional forecasting information on one summary tab. In the first tab of this model, I created a combox box to allow user to pick which region (from a list of 50 regions) they want to view, then on the summary tab, they would see a chart and a summary table of what the forecast for that region would look like.


On a regular basis, I need to copy and paste the chart and summary table into PPT or PDF for presentation/meeting purposes. I have used a macro to export the entire tab into a PDF before. But I am wondering if there is anyway vba can do all the exporting for the entire list of regions I have in the combo box?


Any help is appreciated!


Enowapi

 

[Debraj]

Hi Enowapi,


Welcome to the forum...


If you have any query.. related to excel, you need to provide us..

Data, Requirement and expected Output. You have provided Requirement and expected Output, but Data part is missing. Can you please attach a sample data file so that we can gives you better answer..

Please go through the below link for attaching a sample file..

http://chandoo.org/forums/topic/posting-a-sample-workbook


For the time being manage this with

[pre]

ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, FileName:= _
ThisWorkbook.Path & "Your Reqired PDF" & ".pdf"

[/pre]
Regards,

Deb

 

[enowapi]

Hi Deb,


Thank you for showing me how to post a sample file, below is a link of my sample model.


https://www.dropbox.com/s/n4k3dgn5lohk9pr/model%20sample.xlsx


What I am trying to accomplish:

1. Pick a region from the combo box on the Title page tab

2. This will automatically update the Summary tab

3. I am wondering if there is a macro that I can run to automatically run through all 50 regions listed in the combo box (in the title page tab) and print out the summary tab for all 50 regions at once.

4. I am hoping to have this printed to both PDF and PPT, if possible


Thank you for your help.

Enowapi

 

[SirJB7]

Hi, enowapi!


Give a look at this file:

https://dl.dropbox.com/u/60558749/Export%20Excel%20tab%20to%20PDF%20and%20PPT%20-%20model%20sample%20%28for%20enowapi%20at%20chandoo.org%29.xlsm


It generates a .PDF for each state and a .PPT with all the charts.


Regards!

 

[Debraj]

Hi, enowapi..


If you want to get a single PDF for all the sheet, you have to combine all PDF's to one or you may copy the edited version of the above file..


https://www.dropbox.com/s/2rr1vkws3xag9f0/Copy%20of%20Export%20Excel%20tab%20to%20PDF%20and%20PPT%20-%20model%20sample%20%28for%20enowapi%20at%20chandoo.org%29.xlsm


Hi JB-007


* I have made some changes in your file, to print all PDF at Once.


* Excel13 gives me error at..

PPsld.Shapes.Paste.Select

but with Excel 07 / 10.. its perfect..

Did any Microsoftical Reason behind it?


* Once you asked me regarding rebaptized, I afraid, as I thought you dont like to bapttized yourself.. If true, then sorry for that...But really.. I admire you..


Regards,

Deb

 

[SirJB7]

@Debraj Roy


Hi!


Checked, liked, saved


When I read this topic, I asked myself why was the user trying to get a PDF printout (I assumed printed on a printer... yes, those things that print, you know...) for each state. I thought it was for delivering and distributing, so, go one by one.

Following your statement, the rest was just the usual stuff, nothing hard.


But when I tried to replicate for PPT, I firstly said "Sh.t! No f.....g export available...". Secondly, I said a PPT for each state doesn't make any sense, if it'd be a presentation, it should include all states, so, go all together.


About the Microsoftical reason behind it, only time will tell us, but since many years ago I stick with this motto: never use a Beta or a Preview or a Release Cantidate Microsoft product at a non-developing machine... or at a machine of mine... until is proved to be enough stable at other instalations (but not mines!). If you ask for actual and truly and objective reasons, well, I'd say that for the last 15/20 years Microsoft didn't checked too much a product before releasing it (and nearly all major software corporations neither do) and as they seem to have the habit of one good program followed by a fiasco, ... so I follow Cat Stevens dixit in Father & Son, just relax, take it easy, you're still young, that's your fault, there's so much you have to know. Aka wait and see, and in the meanwhile Need For Speed, if necessary.


Regards!


PS: my English is just educational and academical, maybe sometimes I miss idioms (in Spanish, giros idiomáticos) or colloquialisms, so I'm afraid I didn't fully get all what you meant about baptism


PS2: thank you very much for your last words... even indeed I do my best to be avoid anything alike... it's so nice to be a little antihero... (a little? hmmm...)


PS3: S..t stands for shot, and F.....g for finding, ...