Thread: VBA ExportAsFixedFormat Error
11-21-2011, 05:32 PM #1
VBA ExportAsFixedFormat Error
- Member Since
- Nov 21, 2011
Hello Im trying to find a solution to this problem.
I am Using Excel for Mac version 14.1.2
My Operating system is OSX 10.7.2
I am using visual basics to export a sheet to a PDF file.
ActiveSheet.ExportAsFixedFormat pbFixedFormatTypePDF, "pathandfilename.pdf"
This works perfectly every time until i print from excel using the file>print menu button or clicking apple-p. I don't even need to finish the print job. I can click cancel from the print window and it will still cause that function that worked perfectly every time to fail every time.
Any idea why this is happening? and how to fix it?
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
By kevinless in forum Switcher HangoutReplies: 8Last Post: 10-31-2012, 10:56 AM
By MisterMo in forum OS X - Operating SystemReplies: 1Last Post: 05-28-2012, 11:53 PM
By pipeweed in forum Apple NotebooksReplies: 0Last Post: 04-27-2010, 06:31 AM
By j4ymf in forum Switcher HangoutReplies: 7Last Post: 07-25-2009, 12:40 AM
By MacDeac in forum OS X - Apps and GamesReplies: 2Last Post: 01-05-2007, 06:55 PM