how to copy data based on user inout and paste in another worksheet automatically.

Team,

I have a request for you all.
i have a database.xls file .What i need is
1.popup a input box for user selection of cells .(added the code in database.xls )
2.once selected by user, copy and paste data in another workbook called letter.xls.
3.convert it to word document or pdf to print.(added the code to convert it to word document)
4. prompt for saveas option to save the file.

i know its a length request,still i believe you guys can crack it soon.

thanks in advance

1. Application.InputBox method

2. Range.Copy method with Destination

3. ExportAsFixedFormat method for pdf file

4. GetSaveAsFilename method

All are in VBA inner help …

Hi Marc,

May I please know whether i need to search with the points mentioned in the advanced search tool for related posts?

thanks