Automate PDF from Excel tabs

Save each tab in the workbook to a PDF with the same name as the tab. A file with tabs: (Hours, Expenses, Invoice) will produce [login to view URL] [login to view URL] [login to view URL] in the same directory as the original excel file ## Deliverables ====================== Test Conditions ====================== Filename: "invoice & [login to view URL]" File crated with excel 2007 ===================== Requirements ===================== 1. Execution: Completes all of the actions (requirements) below with: - Running a single program (double click) or clicking a button within the excel file on any one tab 2. Works with excel 2007 document (must have) 3. Works with excel 2003 document (nice to have) 4. Input filename is variable (not hardcoded) 5. Save each tab in the workbook to a PDF with the same name as the tab. A file with tabs: (Hours, Expenses, Invoice) will produce [login to view URL], [login to view URL], [login to view URL] in the same directory as the original excel file 6. Configurable output filename genterated from additional data contained in the spreadsheet. For example Cells D34 & D35 contain the invoice number and invoice date. Cell Data (example): D34 = 2011.10.17 D35 = 100.43 Generated Files: 2011.10.17 - 100.43 - [login to view URL] 2011.10.17 - 100.43 - [login to view URL] 2011.10.17 - 100.43 - [login to view URL] 7. What is required to make this functionality work on other machines if the document were emailed to someone? - installation of X components on the host machine? - VBA code with the excel document? 8. All deliverables must contain a working demo. Any custom code must be included and the results to generate the working product must be reproducable by the customer. ===================== Deliverables ===================== Given there are many possible paths to arrive at a finished working product, your proposal should include details for intermediate details which are not fully described here. The end product shall be a working product which only requires a one-time installation, or inclusion of code to an existing excel document.