• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

How can I extract selected data from an excel workbook with multiple sheets to a word doc/PDF with specified formatting conditions.

A

akshaynmims16

New Member
I have a excel model with data on multiple sheets, my task is to use VBA to automate word doc/PDF creation by selecting data on excel and put it in specific format in a word doc/pdf
 
Last edited:
As Excel can't create Word document but Word can import data from different sources like an Excel workbook​
just using the Word Mail Merge feature, even a Word beginner user can achieve this manually without any code …​
​
To code from Excel that needs at least a crystal clear explanation of the context, step by step in order there is nothing to guess.​
According to your guessing challenge you have to ask first on a Word forum.​
​
 
A must read in particular the « How to get the Best Results » section :​

Site Rules - New Users - Please Read

Hi all, Welcome to the Chandoo.org Forums. Posting Rules & Etiquette The Chandoo.org Forums is a collaborative and happy place to learn and expand your Excel knowledge. The Chandoo.org Forums consist of several Sub-Forums based on the type of question/area of Excel you are interested in...
chandoo.org
 
You must log in or register to reply here.
Back
Top