Save to PDF VBA error when file is transferred from XP to windows 7

I am making an exam sheet on excel and got it fully working in XP but when i transferred it to any windows 7 PC a block of code keeps getting "Runtime Error '5' Invalid Procedure, Call or Argument." The highlighted code is as follows:

ActiveSheet.ExportAsFixedFormat _
FileFormat:=xlTypePDF, _
FileName:="C:\Exam.pdf", _
Quality:=xlQualityStandard, _
IncludeDocProperties:=True, _
IgnorePrintAreas:=False, _
OpenAfterPublish:=True

I have tried using user accounts with full access to the place i am saving. I have also tried recreating the entire thing in windows 7. There is also a timer and several msgbox macros that are working fine, only the print/save to PDF macro is not working.

Try replacing...

Please Login or Register  to view this content.

with

Please Login or Register  to view this content.

Hope this helps!

Sorry i forgot to change the code back when i was fiddling, it was already "Type:=xlTypePDF" in my original so it still doesn't work.

It may have something to do with permissions. Try saving the file in another folder, such as your Documents folder...

Please Login or Register  to view this content.

Hope this helps!

Sorry but it still doesn't work on any folder or any account i use it won't even save as is in the location where the original excel file is.

It worked on Excel 2007 when i used it on XP and doesn't when i use it on Excel 2007 on Windows 7 Professional. I already changed it to "type:=xltypepdf". I'll try using it on excel 2010 as soon as i can since i don't have a computer here with MS Office 2010

Have you installed the additional tools that allow you to export to PDF - I don't think they're included in the standard 2007 install