topic-14726

Board index FiveWin for Harbour/xHarbour Excel 2007 question - SOLVED

Posts: 933

Joined: Sun Oct 09, 2005 01:05 PM

Excel 2007 question - SOLVED
Posted: Thu Feb 26, 2009 05:58 PM

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?

Thanks,

Jeff Barnes

(FWH 16.11, xHarbour 1.2.3, Bcc730)

Jeff Barnes

Posts: 933

Joined: Sun Oct 09, 2005 01:05 PM

Re: Excel 2007 question
Posted: Thu Feb 26, 2009 07:43 PM

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

Code (fw): Select all Collapse

    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?

Thanks,

Jeff Barnes

(FWH 16.11, xHarbour 1.2.3, Bcc730)

Jeff Barnes

Posts: 933

Joined: Sun Oct 09, 2005 01:05 PM

Re: Excel 2007 question - SOLVED
Posted: Wed Mar 04, 2009 01:54 PM

I have found the solution...

Code (fw): Select all Collapse

oSheet:ExportAsFixedFormat( 0, cFilename )

Thanks,

Jeff Barnes

(FWH 16.11, xHarbour 1.2.3, Bcc730)

FiveTech Support Forums

Continue the discussion