Solved

Run-time Error '438'

Posted on 2014-10-01
3
364 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
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

Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

Join & Write a Comment

As with any other System Center product, the installation for the Authoring Tool can be quite a pain sometimes. This article serves to help you avoid making these mistakes and hopefully save you a ton of time on troubleshooting :)  Step 1: Make sur…
Many companies are making the switch from Microsoft to Google Apps (https://www.google.com/work/apps/business/). Use this article to learn more about what Google Apps has to offer and to help if you’re planning on migrating to Google Apps. It is …
Viewers will learn how to maximize accessibility options in an Excel workbook for users with accessibility issues.
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…

762 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

Need Help in Real-Time?

Connect with top rated Experts

24 Experts available now in Live!

Get 1:1 Help Now