Hi,
I have the following macro that runs when a button is clicked. It basically creates a PDF of the document, saves it and emails it. However despite the fact I had it working, it appears to have chucked a wobbly, giving me the error:
Runtime error 5 - Invalid Procedure or Call
Here's the code, with the bold text at the point it is failing. Anyone have any suggestions as to what I should check?
Please Login or Register to view this content.
Just as a note!
Avoid to use the word "Print" at the end of your title because the thread takes a printable view and no one is able to reply(i reversed the last 2 words in your title!).
Good luck with your thread!
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
hi Barking_Mad,
As a quess for possible reason:
1. Your Excel does not support that. Check it by manually exporting range to PDF. If I'm not mistaken this method (ExportAsFixedFormat) has appeared in Excel 2007 starting from SP2. Check you version.
2. PDF add-in might not be installed (reason stated by MSDN): http://msdn.microsoft.com/en-us/libr...ffice.12).aspx
On Excel 2010 there is no problem with the code posted.
Fotis! Sorry!
Given that it was working last week - and hasn't been changed maybe a system update to the network has caused it to stop working?
Or 1 or 2 is the problem, is there an alternative way of doing it?
Actually, it seems that the problem is that it is a shared workbook.
it (error) has definitely nothing to do with the code itself ...
......... wrong window
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks