ExportAsFixedFormat Invalid Procedure Call

Hi.

My PC recently crashed and thus my Excel 2007 was reinstalled. My code below used to work, but now I am receiving Invalid procedure call or argument message. Tried exactly the same exact code to a co-worker's pc and it works fine. Is there any particular setup or configuration in excel to make this work? Thanks for the help. Harold

Please Login or Register  to view this content.

The ExportAsFixedFormat parameters may have changed.

in the code, type a new line
ActiveSheet.ExportAsFixedFormat (space)

once you type the space bar, it should show the parameter list for YOUR version of XL.
(if not, select the Export and click F1 help)