Export to Word Document

**Bunximo** · 08-07-2010, 05:17 AM

Hello,

Sorry about this, I have searched the forum but can't find what I need. (I'm not very conversant with Excel at all I'm afraid).

I've created a very basic database in Excel which is absolutely superb for my needs. I wanted the first column to be a unique reference number which increases by one and I'd hoped that Excel would generate this automatically, every time I started a new line but I can't find anything to do that. Never mind, it's still very good.

I have a Word document called 'progress sheet' which I print out and put on the front of a folder when I've created the entry in the database. It contains data which I've already put into the database such as 'name', 'reference number', 'date received' etc. and it would be most helpful if it was possible to be able to transfer selected elements of the database entry across into the progress sheet.

I've put what I think used to be called power fields into the Word document and I complete these, print the form out and close it without saving.

Is it possible to do this? Sorry for rambling on and thanks for any help you can give.

Bunximo.

**Richard Buttrey** · 08-07-2010, 05:28 AM

Hi, and welcome to the forum.

It's possible but why not design your progress sheet in the same Excel workbook as your database - on a separate sheet. You should be able to get exactly the same look and feel as the word document. Doing it this way enables you to easily link cells between the two rather than having to write VBA code to interact with Word.

You'll also need a simple VBA macro to update your unique reference number every time a new line is added.

I suggest you design your progress sheet in the Excel workbook and then upload it so that we can advise on the other aspects.

HTH

**snb** · 08-07-2010, 05:52 AM

Your unique reference number:

If row 1 has been used for 'fieldnames'

Put in cell A2 the formula"=row()-1" and copy down in columnA.

**Bunximo** · 08-08-2010, 12:48 PM

Thanks very much for your help, it never occurred to me to do the progress sheet in Excel. I'll have a crack at it and get back to you.

I put that formula in the cell but I think I must have done something wrong because the formula just sits in the cell.

Thanks again for your help, it's much appreciated.

Bunximo

**Bunximo** · 08-08-2010, 01:00 PM

I've created the progress sheet by copying it from Word and pasting it to sheet two in the database. I think I've managed to upload it it. Please could you have a look and tell me what you think?

Many thanks,

Bunximo.

**Richard Buttrey** · 08-08-2010, 02:17 PM

Hi,

I've assumed that it's the OCIS reference in C5 of sheet 2 that you want to use as the key to pick up data from the database. I've named "C5 OCIS_ref" and you can see as examples in C4 and K5 how I've used formulae to populate the cells with the relevant data from the database.

Just follow the same logic for other cells.

HTH