Hi,

i have amacro that saves the excel sheet as pdf. I am able to do it manually in excel 2013 but when i try to do it using VBA. excel stops automatically. dont know whats wrong.

here is the VBA :

sht_output.ExportAsFixedFormat xlTypePDF, sItem & "/" & filename, xlQualityStandard

sItem contains path and filename contains name of the file.

Can anyone help.

This is working fine in excel 2007 and 2010. giving problem in excel 2013.

Please help this is very urgent..

Thanks