VBA excel sheet as PDF to SharePoint

[msnook]

I am using multiple macros within a spreadsheet to compile reports. When one of these reports are done the macro takes the current sheet and loads it to our SharePoint site as a PDF. I have issues with this, it locks my excel with a blank screen and stalls out my macro. The code I am using is listed below. Is there a better way to save a sheet to SP? I have other sheets saved using the same type of statement and they work fine but not this one. Thanks in advance for any help.


ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:= _
"

http://My

SharePoint address.pdf" _
, Quality:=xlQualityStandard, IncludeDocProperties:=True, IgnorePrintAreas _
:=False, OpenAfterPublish:=False