• 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.

Convert Excel report to Word (using Macro )

N

Nandakumar

Member
Dear Friends,

Request your kind help converting attached excel file to word either using macro or some other source.

When i tried to copy the same sheet in word its not working fine with format.

Please help.

Thanks in Advance
 

Attachments

This is a quick and painless solution using the Snipping Tool found in Windows Accessories:

upload_2017-3-8_10-47-38.png

The Snipping Tool creates a picture file that you can quickly "snip," copy, and paste into Word.
Did you intend for Word to be able to edit it? If so, this obviously will not work.
 
You asked for a macro help in the Excel formulas forum ! :eek:
At least create thread next time in appropriate VBA Macros forum …

So as it does not work in manual way,
the result of a Copy / Paste by code will be exactly the same ‼ :rolleyes:

So activate under Word its Macro recorder and operate manually
to format data to your convenience : you'll get a code base !
​
 
No Word tutorial here as it's an Excel forum !
But you can easily perform a web search … (as well for a Word forum too)

See icons on Word Developer tab.
And as explained in Word help (just read it !),
you can embed an Excel worksheet (maybe range) …
​
 
You must log in or register to reply here.
Back
Top