<div>
Thx Babblo<br />
I will look into that solution.<br />
I'll let the question be open yet a while to see if any other solution will come up.<br />
- Benny
</div>


Thx Babblo
I will look into that solution.
I'll let the question be open yet a while to see if any other solution will come up.
- Benny

<div>
Dear broomee9 and Babblo<br />
<br />
It wasn't due to lacyness or anything, just hoped for another solution instead of shell scripting.<br />
I wass hoping it could have been done through VBA macro in Excel og Word.<br />
So it will be fine to accept Babblo's answer.<br />
<br />
thx Benny
</div>


Dear broomee9 and Babblo

It wasn't due to lacyness or anything, just hoped for another solution instead of shell scripting.
I wass hoping it could have been done through VBA macro in Excel og Word.
So it will be fine to accept Babblo's answer.

thx Benny

<div>
This question has been classified as abandoned and is being closed as part of the Cleanup Program. &nbsp;See my comment at the end of the question for more details.
</div>


This question has been classified as abandoned and is being closed as part of the Cleanup Program.  See my comment at the end of the question for more details.

<div>
<div class="content wysiwyg-content">
Hi<br />
<br />
Is there a way to use OpenOffice PDF conversion from VBA in MS Office 2003 apps ?<br />
I don't have the option to install other pdf conversion tools. But I do have both OO and MSO.<br />
I have to use MSO for spreadsheets, docs etc. for now. So the option of using OO is not possible.<br />
Neither is the option to open the docs in OO and use saveas.<br />
<br />
I need a macro that exports/saveas to PDF using OO's PDF conversion tool.<br />
<br />
I have searched all over and cannot find anything.<br />
<br />
Anyone can help?<br />
<br />
Kindest regards<br />
Benny
</div>
</div>


Hi

Is there a way to use OpenOffice PDF conversion from VBA in MS Office 2003 apps ?
I don't have the option to install other pdf conversion tools. But I do have both OO and MSO.
I have to use MSO for spreadsheets, docs etc. for now. So the option of using OO is not possible.
Neither is the option to open the docs in OO and use saveas.

I need a macro that exports/saveas to PDF using OO's PDF conversion tool.

I have searched all over and cannot find anything.

Anyone can help?

Kindest regards
Benny

Use Openoffice pdf-converter in vba (Excel,Word 2003)

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.

Visual Basic Classic

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Microsoft Word is a commercial document editing program that is part of the Microsoft Office suite. It features numerous text-editing tools for creating richly formatted documents, along with tools for the use of macros in Word documents. Word's native file formats are denoted either by a .doc or .docx file extension. Plugins permitting the Windows versions of Word to read and write formats it does not natively support, such as the OpenDocument format (ODF) are available. Word can import and display images in common bitmap formats such as JPG and GIF. It can also be used to create and display simple line-art.