Merging Excel Files = Formatted Word or PDF Report

[katealicious]

I'm trying to merge two Excel files and output a single, nicely formatted pdf or Word report that combines the two Excel spreadsheets. Could you please tell me if that is possible and if so, how? I'm looking to take the results of an online form (40% of the final report information), that exports results to Excel, merge it with a local Excel file (that is the remaining 40% of the final report information), leaving me with something I can input the last 20% of information into and then export as a Word or PDF finalized report.

Any breadcrumb trail of information on how I can go about achieving this would be awesome.

Kate

 

[JoeMo]

If you are using Excel 2007 or later version, once you have a final Excel sheet, you can SaveAs a PDF document.

Alternatively, if you want to do it via a macro then, with the final sheet active, the key code looks something like this:

ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:= _
    "A file path between these quotes" & ActiveSheet.Name & ".pdf", _
    Quality:=xlQualityStandard, IncludeDocProperties:=True, IgnorePrintAreas _
    :=False, OpenAfterPublish:=True