LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #8   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 131
Default close pdf file before closing excel

"James Barrass" wrote:

I had a look this morning you might not need the sdk, have a look under
toolsreferences and see if you have the adobe acrobat type library.

All the references and code snippets i found for this were for Visual Studio

Set PDFApp = CreateObject("AcroExch.App")
created an error "ActiveX Componant can't create object"

"urkec" wrote:

"James Barrass" wrote:

The Adobe SDK is free and Contains an AVDOC object representing a pdf document
This has IsValid and Close which might be helpful in this case,
Sorry I haven't tested this


That would be the best way to do this, but I haven't be able to make it
work. I found some samples, but all for the full version of Acrobat, none of
them worked with Acrobat Reader, it seems they have different object model.
If you have any samples or links that would be great. I will also need to
check the Adobe site for the SDK.

--
urkec


Problem is, I don't have the full version of Acrobat. I loaded acrord32.dll
into the object browser and tried creating Acrobat.AcroApp but no luck. I
also looked under HKEY_CLASSES_ROOT in the registry and there are several
AcroExch keys but not AcroExch.App. And, as you mention, all samples I could
find use that. All I could find was the information that Acrobat Reader
object model is different than Acrobat, nothing more. Too bad, it would be
nice to be able to automate working with pdf files.

--
urkec
 
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
automatically close form before closing Horatio J. Bilge, Jr. Excel Discussion (Misc queries) 0 September 19th 08 08:26 PM
Everytime i close an excel file, it creates a new backup file p Excel Discussion (Misc queries) 3 November 22nd 07 08:13 AM
close workbooks without closing excel ? Clute Excel Discussion (Misc queries) 2 August 5th 06 09:50 PM
How do I close excell worksheet without closing others still open John Excel Worksheet Functions 2 July 20th 06 06:17 PM
close workbook without closing excel and stop recursive function chris Excel Discussion (Misc queries) 3 July 10th 06 08:23 PM


All times are GMT +1. The time now is 11:16 AM.

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"