Help: converting new sheets to word document

[Vaughan.jamie]

Hi

is there a way to create a macro to automatically save new sheets as a Word document in a specific file

also i have another code that may need help on

ARowbot helped me yesterday with this code which I got to say with his fast response to my post i was very pleased with his/her help and can't say thank you enough

Please Login or Register  to view this content.

i have attached a example document of my spreadsheet with the above code added

Example2015 (1).xlsm
but i need to add to it so it copys names and addresses from another sheet at the same time as copying the data from summary is this possible

[ARowbot]

I have replied to this via private message as I didn't realise you had posted on the forum aswell. Here is the code that exported each sheet to pdf. Unfortunately I didn't know a way to save it to Word Doc.

Please Login or Register  to view this content.

If you wish to put the address etc in then I recommend setting out a box for that on your template before we help import the correct data to it.

[Vaughan.jamie]

Hi ARowbot

once again being a legend :-)

any chance you have an idea for the code for the bottom question?

thank you in advance :-)

[ARowbot]

Create a space on the template where you would like each line of the address to go so that you're happy with the format when you export it and print it out and then upload that workbook and I will happily put the code in for you to transfer the addresses automatically.

[Vaughan.jamie]

Example2015 (1).xlsm

Hi ARowbot

Please find attached the example sheet

i have put where i need them going on the new template layout

thank you so much for helping me with this

[ARowbot]

You're very welcome. Hope this does what you want it to do!

Please Login or Register  to view this content.

[ARowbot]

Try not to post in 2 different threads! In regards to your latest question on http://www.excelforum.com/excel-prog...-included.html. This macro currently creates a sheet for every school in the summary sheet. It won't update the sheets. The easiest way is to probably delete existing sheets first and then just run this macro.

[Vaughan.jamie]

Hi ok

thats fine ARowbot

that is what i am doing at the moment so will keep it to that

cheers for all your help

i will mark this as solved now