LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Creating PDF Files from Multiple Worksheets Using VBA

I can't help but notice that there are a number of questions about this topic
but very few answers. What I need to know is this: is it possible to create
a PDF file for each print area on each worksheet in a workbook solely through
using VBA and without resorting to add-ins.

I work in an environment that is very secure and the use of individual
add-ins to resolve problems is discouraged. I need to know if there is VBA
code that will let me convert an existing print area on a worksheet into a
PDF file and use the sheetname as the name of the PDF file.

Thanks in advance for any help on this.

George
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
merge multiple worksheets from multiple excel files into oneworksheet Shamoun Ilyas Excel Discussion (Misc queries) 5 November 19th 08 09:48 PM
Creating Multiple Worksheets Trinigal Excel Discussion (Misc queries) 2 June 11th 07 07:49 PM
Creating multiple worksheets... Kent K Excel Worksheet Functions 7 May 20th 07 05:21 AM
creating a chart from multiple files SDeam Charts and Charting in Excel 2 April 8th 05 10:01 PM
creating multiple files from a spreadsheet Carol Summa Excel Discussion (Misc queries) 1 March 17th 05 12:07 PM


All times are GMT +1. The time now is 01:59 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"