Hello:
I have excel sheet which generates a paid receipt.
I like to store this receipt as a pdf file.
The name of the pdf file would need be created by the values in certain cell.
(Remember that values in cell are populated from other part of the worksheet)
I8_E10_E15
Example :
Value in I8 = 14-May-12
Value in E10 = John Doe
Value in E15 = [email protected]
PDF file name need to be :
14-May-12_John [email protected]
Can you please help with this by either having a VB Macro or some other alternatives
Please let me know if any questions.
Thanks in advance for your help.
Riz
Bookmarks