Go Back   TechArena Community > Software > Software Development
Become a Member!
Forgot your username/password?
Tags Active Topics RSS Search Mark Forums Read

Reply
 
Thread Tools Search this Thread
  #1  
Old 24-01-2009
Member
 
Join Date: Dec 2008
Posts: 42
Save an Excel file into PDF with VBA

Hello,

At the closure of an Excel file, it can record in xls and pdf?

Is there a VBA code for this?

Thank you
Reply With Quote
  #2  
Old 24-01-2009
Member
 
Join Date: Oct 2008
Posts: 77
Re: Save an Excel file into PDF with VBA

I do this all the time using CutePDF.

Try that.
Reply With Quote
  #3  
Old 24-01-2009
Member
 
Join Date: Jan 2008
Posts: 1,515
Re: Save an Excel file into PDF with VBA

Quote:
Originally Posted by wasim View Post

At the closure of an Excel file, it can record in xls and pdf?
aftab1

But you can do a code on the VBA macro
Code:
Private Sub Workbook_BeforeClose (Cancel As Boolean)
that records in PDF, then recorded xls
Reply With Quote
  #4  
Old 24-01-2009
Member
 
Join Date: Dec 2008
Posts: 42
Re: Save an Excel file into PDF with VBA

Hello,

But we must go through mandatory Acrobat? In an Excel spreadsheet when I click "Save as," I do not know what format I have to apply in my Macro, the PDF format does not exist.
Thank you
Reply With Quote
  #5  
Old 24-01-2009
Member
 
Join Date: Mar 2008
Posts: 198
Re: Save an Excel file into PDF with VBA

Hi, if you have Excel 2007 with the inclusion of additional downloadable
http://www.microsoft.com/downloads/d...displaylang=en
And you can also use PDFCreator.
Reply With Quote
Reply

  TechArena Community > Software > Software Development
Tags: , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "Save an Excel file into PDF with VBA"
Thread Thread Starter Forum Replies Last Post
Getting Error Message when I try to save file in Excel Aza MS Office Support 2 23-02-2012 02:08 PM
Excel Takes Long time to save a file (Cowherd) Windows Software 2 21-01-2012 01:44 PM
How to save excel file as Database 3 Aarti C Windows Software 3 08-01-2012 01:54 PM
How to save excel file as pdf? Imtiyaz Tips & Tweaks 5 27-07-2011 01:41 AM
Open Excel file and save as .xlsx using VB code Bisujaksha Software Development 3 11-06-2009 08:06 PM


All times are GMT +5.5. The time now is 08:47 AM.