Solved

Excel VBA error

Posted on 2014-04-26
6
309 Views
Last Modified: 2014-04-26
Sub TestPdf()
    ActiveWorkbook.Sheets("Scorecard").Activate
   
   
    ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, FileName:="\\pmcfs\groups\Accounting\Physician Stats\PhysRpts\Testsc"
       
       
       
End Sub

the above sub routine is giving me the error in Excel 2007:

Invalid Procedure Call or Argument

How can I fix this?

Thanks

Glen
0
Comment
Question by:GPSPOW
  • 3
  • 2
6 Comments
 
LVL 35

Expert Comment

by:Kimputer
ID: 40025058
Export to PDF was introduced in Office 2010. I'm afraid you're using VBA code you picked up meant for Office 2010+.
0
 

Author Comment

by:GPSPOW
ID: 40025062
With all the different version out there now.  Is there a backwards compatability fix to save an Excel sheet as a PDF if the user is using Excel 2003 or 2007?
0
 
LVL 35

Expert Comment

by:Kimputer
ID: 40025067
No, a function will not magically appear in older programs. If this magic happened, no person would ever buy new programs either.

Now you're backup solution might be to check if the version is 2007 or older, then check if PDF creator is installed, then use alternate code to generate it.
0
Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

 

Author Comment

by:GPSPOW
ID: 40025114
I've requested that this question be deleted for the following reason:

Since there is not backwards compatibility between Excel 2010 and v. 2003 & 2007 to create a PDF without external programming, I am dropping the question and will try to figure out another way to do what I need.

Thanks

Glen
0
 
LVL 27

Accepted Solution

by:
MacroShadow earned 500 total points
ID: 40025115
You can use the code you posted in 2007 after you install the SaveAsPDF addin from Microsoft.
0
 

Author Closing Comment

by:GPSPOW
ID: 40025194
Ill try it.

Thanks

Glen
0

Featured Post

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

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

Suggested Solutions

Introduction While answering a recent question (http:/Q_27311462.html), I created an alternative function to the Excel Concatenate() function that you might find useful.  I tested several solutions and share the results in this article as well as t…
Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
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…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

810 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