Go Back  Xtreme Visual Basic Talk > Legacy Visual Basic (VB 4/5/6) > VBA / Office Integration > Word, PowerPoint, Outlook, and Other Office Products > Close PDF file from VBA


Reply
 
Thread Tools Display Modes
  #1  
Old 02-19-2004, 05:29 AM
Cyric42 Cyric42 is offline
Newcomer
 
Join Date: Nov 2003
Posts: 5
Default Close PDF file from VBA


Hello

I'm generating some PDF-files using Acrobat Distiller from VBA. When I generate files the PDF-file window is permanently open and i'm unable to generate a new PDF-file with the same name (without closing the PDF-file window). Are there anyway to close a PDF file from the VBA code (or alternativelt a way to drop the showing of the PDF-fiel window when i generate the PDF-file)??

Thx
Reply With Quote
  #2  
Old 02-19-2004, 07:25 AM
MKoslof's Avatar
MKoslof MKoslof is offline
Cum Grano Salis

Retired Moderator
* Guru *
 
Join Date: Jul 2002
Location: Baltimore, Maryland
Posts: 14,636
Default

Are you using code? If you are creating an Acrobat Object (COM object) via code...are you quiting the application after you finish creating the PDF? What are you doing to create the PDF and view it?
__________________
"Artificial Intelligence is no match for natural stupidity." ~unknown
Reply With Quote
  #3  
Old 02-19-2004, 08:19 AM
Cyric42 Cyric42 is offline
Newcomer
 
Join Date: Nov 2003
Posts: 5
Default

Quote:
Originally Posted by MKoslof
Are you using code? If you are creating an Acrobat Object (COM object) via code...are you quiting the application after you finish creating the PDF? What are you doing to create the PDF and view it?



Yes, i'm using code. I'm using Acrobat Distiller to print my .xls file to .pdf. The problem is that the pdf-file window stays 'open' and i cannot create a new file (with the same name) before this window is closed. So the problem is 'simple' How do i close another application/file from VBA?
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

Similar Threads
Thread Thread Starter Forum Replies Last Post
File I/O GavinO Tutors' Corner 5 04-17-2013 01:18 PM
Installation Problem - PLs help urgenlty dpdsouza Installation / Documentation 4 12-02-2004 07:09 PM
Makin a nice little program! Decontain Communications 3 04-11-2003 02:54 AM

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
 
 
-->