Export As A Fixed Format Excel 2007

I have been assigned the task of developing a excel document that whole office will use. The user will click a button and the macro will export the file as a PDF to a shared folder. I wrote this code and tested this code using excel 2010. People that have excel 2007 where getting an error message saying "Run Time Error 1004 Document not saved. This document may be open, or an error may have been encountered when saving." I looked into the problem a little bit and found that excel 2007 needed an add-in update, so I installed it on their computers. I also checked to see if they have adobe on their computers and they do. They are still having the problem and I am unsure of what to do. Any help would be greatly appreciated!

Here is my code

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Does this do anything for you? I notice you're using a date in the filename. Your date doesn't contain any invalid filename characters does it? For example, 1/1/2014 will not work because / is an invalid filename character

Hello and thank you for your help,

No unfortunately this code did not work. I know that the date is not the problem it worked before I added the ExportAsAFixedFormat

You're sure the file isn't already open? How about permission issues? I've seen this before when a user was trying to replace a file that another user created. We had permissions set up to not allow this so the code would error every time someone tried to replace a file someone else created