Solved

Run-time Error '438'

Posted on 2014-10-01
3
394 Views
Last Modified: 2014-10-01
Hi Experts,

I have built a model in Excel 2010 but have to accommodate 2003 users... My code generally works but I'm getting a run-time error 438 (object doesn't support this property or method) when I run the following in 2003.:

ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, FileName:=FileNamePDFcatch, _
            Quality:=xlQualityStandard, IncludeDocProperties:=False, _
            IgnorePrintAreas:=False, OpenAfterPublish:=False

I assume it's because the syntax required to create the pdf has changed between 2003 & 2010.

Can anyone help me get the 2003 syntax?
I'm hoping that would still work in 2010...

Thanks
0
Comment
Question by:martywal
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 45

Accepted Solution

by:
aikimark earned 250 total points
ID: 40356171
PDF creation was not an option in Office 2003 products.  I had a similar situation at one of my client sites and had to add code that would 'print' to a PDF creating virtual printer (in this case, Bullzip) if the application version was below version 12 (2007).
0
 
LVL 33

Assisted Solution

by:Norie
Norie earned 250 total points
ID: 40356175
There is no ExportAsFixedFormat in Excel 2003, it was introduced in 2007.

You'll need to use a third party PDF tool for Excel 2003, Adobe Acrobat is one option but is costly, however there are other, free options, eg CutePDF.
0
 

Author Closing Comment

by:martywal
ID: 40356233
I was hoping that this wasn't the case :-(
Thanks for your responses.
Good improvement MS Excel! :-)
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Deploying a Microsoft Access application in a Citrix environment is not difficult but takes a few steps. However, Citrix system people are often of little help, as they typically know next to nothing about Access. The script provided here will take …
Technology opened people to different means of presenting information, but PowerPoint remains to be above competition. Know why PPT still works today.
Viewers will learn the different options available in the Backstage view in Excel 2013.
The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…

749 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question