<div>
You can invoke a VB intepreter on a script file containing that using Runtime.exec:<br />
<br />
<a href="http://www.javaworld.com/javaworld/jw-12-2000/jw-1229-traps.html" rel="ugc">http://www.javaworld.com/javaworld/jw-12-2000/jw-1229-traps.html</a>
</div>


You can invoke a VB intepreter on a script file containing that using Runtime.exec:

http://www.javaworld.com/javaworld/jw-12-2000/jw-1229-traps.html [http://www.javaworld.com/javaworld/jw-12-2000/jw-1229-traps.html]

<div>
lots of tools available that allow you to call activex/vb, see here for a summary<br />
<br />
<a href="http://staff.develop.com/halloway/JavaWin32.html" rel="ugc">http://staff.develop.com/halloway/JavaWin32.html</a><br />
<br />

</div>


lots of tools available that allow you to call activex/vb, see here for a summary

http://staff.develop.com/halloway/JavaWin32.html [http://staff.develop.com/halloway/JavaWin32.html]



<div>
<div class="content wysiwyg-content">
How can I execute following VBA using java?<br />
<br />
Sub Macro2()<br />
<br />
&nbsp; &nbsp; ActiveSheet.ExportAsFixedF<wbr />ormat Type:=xlTypePDF, Filename:= _<br />
&nbsp; &nbsp; &nbsp; &nbsp; &quot;C:\Documents and Settings\hjanjua\My Documents\Book1.pdf&quot;, Quality:= _<br />
&nbsp; &nbsp; &nbsp; &nbsp; xlQualityStandard, IncludeDocProperties:=True<wbr />, IgnorePrintAreas:=False, _<br />
&nbsp; &nbsp; &nbsp; &nbsp; OpenAfterPublish:=False<br />
End Sub<br />
<br />
Please supply java code ...<br />
<br />
Regards,
</div>
</div>


How can I execute following VBA using java?

Sub Macro2()

    ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:= _
        "C:\Documents and Settings\hjanjua\My Documents\Book1.pdf", Quality:= _
        xlQualityStandard, IncludeDocProperties:=True, IgnorePrintAreas:=False, _
        OpenAfterPublish:=False
End Sub

Please supply java code ...

Regards,

Save file as pdf

Java is a platform-independent, object-oriented programming language and run-time environment, designed to have as few implementation dependencies as possible such that developers can write one set of code across all platforms using libraries. Most devices will not run Java natively, and require a run-time component to be installed in order to execute a Java program.

Java

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

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.