VBA to export sheet to word and save

[freud1]

Hi Guys,

I have found a few similar codes online but none of them seem to fit the bill.

I need a VBA code that will Export the contents of 'Sheet 1' to a word document and save the word document as the value in cell A1 which holds the title.

It sounds simple but i cant even begin to get this working.

Any help is appreciated!

Many thanks!

[stojko89]

You could upload an example workbook.
Is the sheet small enough to fit on one word page? or how will it look like?

[freud1]

Hi stojko89,

The data will be variable but sometimes will extend onto more than one page.

Example attached.

Thanks for any help you can give!

Regards

[stojko89]

Ok here goes:

Please Login or Register  to view this content.

Just change the fLoc to the folder you want the file to be saved and the wrdDoc to the file you want opend when you copy stuff to word.
Then run the macro Excel to word.
It counts till the last used row in column A so everything will be copyed that is found.

---------- Post added at 02:02 PM ---------- Previous post was at 02:00 PM ----------

When in Excel hit Alt+F11 and go to Tools/References and tick the word 12 library. so you'll be able to use this

[freud1]

Stojko! This is absolutely perfect!

I have applied this to my spreadsheet and it works EXACTLY as i wanted it to.

Thank you so much for your advice with this! It has really saved me a lot of time!

Many thanks

F

[stojko89]

Happy to help

[dcminus]

stojko89: I used your solution, and it is working great.

Just wondering if you could help me to amend it i would need to do two simple things:

1. copy B1 and set it bold & centered:

Please Login or Register  to view this content.

2. i need to center the rest of the text

Would be great if you could help me to figure this out.

Thanks in advance,

DC