Hi, check the below link to write the excel sheet to Word. The code in the article does not satisfy all your requirements, you might want to tweak the code according to your requirements. Also to know the details of saving word to PDF, you might want to check in some PDF forums too. They will have a good idea about the pdf versions and related dlls that you need to reference before writing the macro. http://funwithexcel.blogspot.com/2009/04/writing-excel-contents-into-file-dat.html But definitely you requirements needs some effort. Hope this helps. On Tue, May 19, 2009 at 3:03 PM, prashant kulkarni <hope.pr...@gmail.com>wrote:
> > HI all, > > I have a sheet, from which i have to copy particualr data from the > sheet, then paste it in the fixed place in word and save the file as > *.pdf. there are hundreds of such cases to be dealt with. Is there any > way to have amacro in place to do it in a faster way. > > In short :- > 1) the macro should select the data (some selected rows) and copy it > in the word. > 2) after pasting the data, save the word file as PDF > 3) get the next data. > > Any help would be great. > > Regards, > Prashant > > > > -- http://funwithexcel.blogspot.com/ --~--~---------~--~----~------------~-------~--~----~ ------------------------------------------------------------------------------------- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---
