Excel VBA to create Word document

Associate
Joined
18 Oct 2002
Posts
2,055
Location
Southend-on-Sea
I've been googling for the last hour or so but don't seem to be find anything to help me. Basically I have some data in an Excel spreadsheet:

Column A: Ref Number
Column B: Address
Column C: Details
Column D: Status
Column E: Cost
Column F: Contact

There will be several rows of data. I want a user to be able to select a row by clicking any cell in that row, and then to click a button that will create a new Word document with the Excel data added into a template.

I can find guides on how to transfer complete sheets and do basic mail merges but I'm struggling to find info on how to do this.

Can anyone point me in the right direction on where I could find a decent tutorial for this?

Thanks
 
No worries, found a solution now. Typical, spend an hour searching, find nowt, post on here for help and then next search I do I find a solution.
 
Can't find the site now, but it was basically this spreadsheet.

Take a look at the code behind the button, should be self-explanatory. I've just got to work out how to handle cells with carriage returns and I'll be done.
 
Back
Top Bottom