Go Back  Xtreme Visual Basic Talk > Legacy Visual Basic (VB 4/5/6) > VBA / Office Integration > Excel > Getting charts to .pdf or MSWord


Reply
 
Thread Tools Display Modes
  #1  
Old 06-21-2006, 07:11 AM
BBauer42's Avatar
BBauer42 BBauer42 is offline
Contributor
 
Join Date: Dec 2005
Location: CT, USA
Posts: 448
Default Getting charts to .pdf or MSWord


I have an Excel workbook with about 50 sheets. One of the sheets has about 50 charts on it. I would like to send all of these charts to a client, possibly in a .pdf. I am having trouble getting them in a format that is small enough to send via email.

I would prefer to crop them out of Excel and send them in either Word or some other app. What is the best way to do this (quickest and keeping file size in mind)?

Thanks in advance.
__________________
www.sportsloon.com
Reply With Quote
  #2  
Old 06-21-2006, 09:47 AM
NateO's Avatar
NateO NateO is offline
Excellent…

Forum Leader
* Expert *
 
Join Date: Jun 2004
Location: Minneapolis MN - deceased
Posts: 2,483
Default

Hello,

Aren't PDFs generally quite fat?

You could probably just copy and paste to word, or send out some JPGs or GIFs...

The following should be open source for converting to images:

http://j-walk.com/ss/excel/files/charttools.htm

Or, if you want Word, you should be able to generate most of the copy/paste syntax with the recorders, in each App.
__________________
Regards,
Nate Oliver
Microsoft Excel MVP
Reply With Quote
  #3  
Old 06-23-2006, 07:37 AM
BBauer42's Avatar
BBauer42 BBauer42 is offline
Contributor
 
Join Date: Dec 2005
Location: CT, USA
Posts: 448
Default j-walk chart tool

The J-Walk tool is very nice. Thanks!!
__________________
www.sportsloon.com
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Forum Jump

Advertisement:





Free Publications
The ASP.NET 2.0 Anthology
101 Essential Tips, Tricks & Hacks - Free 156 Page Preview. Learn the most practical features and best approaches for ASP.NET.
subscribe
Programmers Heaven C# School Book -Free 338 Page eBook
The Programmers Heaven C# School book covers the .NET framework and the C# language.
subscribe
Build Your Own ASP.NET 3.5 Web Site Using C# & VB, 3rd Edition - Free 219 Page Preview!
This comprehensive step-by-step guide will help get your database-driven ASP.NET web site up and running in no time..
subscribe
 
 
-->