Excel VBA 2003 2010 Compatibility with ExportAsFixedFormat

**Max_Taylor** · 12-14-2012, 01:31 PM

The code below runs great in Excel 2010, but hangs with a "Object doesn't support this property or method" error on the line with the ExportAsFixedFormat statement near the bottom. Is this a syntax issue or does ExportAsFixedFormat really not exist in Office 2003 objects?

I searched for this for a while, but then remembered that the people here generally explain things much better than the MS reference sites.

Sorry for the long sub but posting the whole thing seems to be best.

Thanks.

Please Login or Register  to view this content.

**Norie** · 12-14-2012, 01:42 PM

It really doesn't exist in 2003, it was added in 2007.

**Max_Taylor** · 12-14-2012, 02:01 PM

Thank you. Does 2003 have a similar method of outputting a PDF?

**Norie** · 12-14-2012, 02:06 PM

Not that I know of.

I think you might need to use some sort of PDF creator add-in, or if you have the right drivers you can print to PDF.

**Max_Taylor** · 12-14-2012, 06:30 PM

Thanks Norie.

When I put this code in I get a "Named argument not found" error, and Filename is highlighted. This code came from a Word 2003 macro recording so I don't understand the error. PDFFileName is defined as a string, but even if I change it to a variant I get the same error.

Any idea why?

Please Login or Register  to view this content.

**Max_Taylor** · 12-14-2012, 06:34 PM

My apologies. This is the code I am using in 2003. The code above is from 2010.

Please Login or Register  to view this content.

**Norie** · 12-14-2012, 06:57 PM

If that code is from Word you can't use it in Excel.

**Max_Taylor** · 12-14-2012, 07:06 PM

Understood. I thought I should get it from Word since I am using in a "With" statement referring to a Word object, and I guess I thoguht the object methods were the same throughout an Office suite. Rookie mistake no doubt. Will try it through Excel. Thanks.