This is an automatic process to generate pdf reports for all employees and works great in excel 2007, 2010. My macro basically copies the data from data_sheet and pastes them in report and then save the report as pdf. Details of these n employees are stored in a separate sheet (say data_sheet). This report is being produced for n no of employees. Anonymous Hi Joe, The reason i am using a macro to save sheet as pdf is because i have a report with Emp Name, Address, phone No etc details. I will highly appreciate a solution to this problem. I am able to export as pdf manually but the VBA in excel 2013 is giving that error. It says Excel has stopped working: sht_Output.ExportAsFixedFormat xlTypePDF, sItem & '/' & filename, xlQualityStandard I am not sure what the problem is. Everything is fine but as soon as the below line is executed. Code is working perfect for 2007, 2010 but creating problem in 2013. I have a macro that exports a worksheet as pdf. YES IT'S FRUSTRATED! Anonymous Hi Jo, none worked for me. Hi Friends, Like you, I faced this problem after I upgraded my MS Office 2010 to MS Office 2013 and spent plenty amount of hours trying to fix it. Microsoft PowerPoint has stopped working.
0 Comments
Leave a Reply. |