Solved

Run-time Error '438'

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

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

On Demand Webinar: Networking for the Cloud Era

Ready to improve network connectivity? Watch this webinar to learn how SD-WANs and a one-click instant connect tool can boost provisions, deployment, and management of your cloud connection.

Question has a verified solution.

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

This very simple solution applies to a narrow cross-section of the "needs to close" variety. In this case, the full message in Event Viewer was in applog, Event ID 1000: Faulting application iexplore.exe, version 8.0.6001.18702, faulting module …
This collection of functions covers all the normal rounding methods of just about any numeric value.
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…

688 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