Excel 2007 question - SOLVED

[Jeff Barnes]

Hi Everybody,

I would like to do a "Save As PDF" in excel 2007 via FWH.
I have installed the excel plugin but need to know how to issue the saveas from within my program to create the PDF file.


Any ideas?

[Jeff Barnes]

this is what I get when I record a macro and edit it....

Code: Select all  Expand view

   ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:= _
        "C:\Documents and Settings\jbarnes\My Documents\Book1.pdf", Quality:= _
        xlQualityStandard, IncludeDocProperties:=True, IgnorePrintAreas:=False, _
        OpenAfterPublish:=False
 

Can someone please help me to translate this to FWH?

[Jeff Barnes]

I have found the solution...

Code: Select all  Expand view

oSheet:ExportAsFixedFormat( 0, cFilename )