Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Modules / DAO / VBA / May 2007

Tip: Looking for answers? Try searching our database.

Creating a PDF from code

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
TADropik - 31 May 2007 17:40 GMT
Is is possible to open a Word file and save it to a PDF file from within the
code?

I use the following code to open the word file and save it:
Dim objWord As Word.Application
  Set objWord = GetObject("", "word.application")
  objWord.Visible = False
  objWord.Documents.Open sOpenLoc & sOpenFile
  objWord.ActiveDocument.SaveAs sDestLoc & sFile
  objWord.Quit
     
Can I do something like this and save it to a PDF?
Daniel - 31 May 2007 18:45 GMT
MS does not have a save as PDF option.  You need to install a virtual pdf
printer on your pc (PDF Creator, CutePDF Writer,...) and then print the doc
to that printer.  Also, for report from an access db you can also use Lebans
ReportToPDF (http://www.lebans.com/reporttopdf.htm).
Signature

Hope this helps,

Daniel P

> Is is possible to open a Word file and save it to a PDF file from within the
> code?
[quoted text clipped - 8 lines]
>      
> Can I do something like this and save it to a PDF?
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.