Save as PDF in VBA

S

shades

In Excel after selecting Print, there is an option for Save as PDF. However,
someone has noticed that there doesn't seem to be any way to access that
option in VBA.

Does anyone know if it is supported in VBA? And if so, how to access it?

Thanks
 
R

Richard Garber

I've been trying to figure this out for the last few days and from
what I can see in Excel VBA Help it is not supported for VBA on on the
Mac. I would be interested in knowing if alternatively there is a way
to save as pdf in Applescript - or can Realbasic save as pdf?

Richard
 
P

Paul Berkowitz

I've been trying to figure this out for the last few days and from
what I can see in Excel VBA Help it is not supported for VBA on on the
Mac. I would be interested in knowing if alternatively there is a way
to save as pdf in Applescript - or can Realbasic save as pdf?
Click to expand...

"Save as PDF" is really part of Mac OS X's Print dialog - nothing to do with
Word's object model, even on the Mac. I've tried to do it by "GUI Scripting"
but, as is not uncommon, that doesn't work.

I, for one, have requested "Save to PDF" as an AppleScript feature (it's
probably more likely to get added to AS at the moment than to VBA). You
should also make a feature request via the Help menu/Send Feedback. The more
people request it, the more likely it will come to pass. Or perhaps it's
something that Apple will make scriptable for all apps.

At the moment, you might indeed want to check out RealBasic and see if it
can do it.

--
Paul Berkowitz
MVP MacOffice
Entourage FAQ Page: <http://www.entourage.mvps.org/faq/index.html>
AppleScripts for Entourage: <http://macscripter.net/scriptbuilders/>

Please "Reply To Newsgroup" to reply to this message. Emails will be
ignored.

PLEASE always state which version of Microsoft Office you are using -
**2004**, X or 2001. It's often impossible to answer your questions
otherwise.
 
N

Natasha_Microsoft

I have made sure that this information has been added to our feature
suggestion list. Thank you very much for sending the information.

Natasha Bishop
Microsoft Employee
 
Top