+ Reply to Thread
Results 1 to 9 of 9

Export to Word Document

  1. #1
    Registered User
    Join Date
    08-07-2010
    Location
    Cheshire, England
    MS-Off Ver
    Excel 2007
    Posts
    5

    Export to Word Document

    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.

  2. #2
    Forum Moderator Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    27,952

    Re: Export to Word Document

    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
    Richard Buttrey

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  3. #3
    Forum Expert snb's Avatar
    Join Date
    05-09-2010
    Location
    VBA
    MS-Off Ver
    Redhat
    Posts
    5,646

    Re: Export to Word Document

    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.

  4. #4
    Registered User
    Join Date
    08-07-2010
    Location
    Cheshire, England
    MS-Off Ver
    Excel 2007
    Posts
    5

    Re: Export to Word Document

    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

  5. #5
    Registered User
    Join Date
    08-07-2010
    Location
    Cheshire, England
    MS-Off Ver
    Excel 2007
    Posts
    5

    Re: Export to Word Document

    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.
    Attached Files Attached Files

  6. #6
    Forum Moderator Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    27,952

    Re: Export to Word Document

    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
    Attached Files Attached Files

  7. #7
    Registered User
    Join Date
    08-07-2010
    Location
    Cheshire, England
    MS-Off Ver
    Excel 2007
    Posts
    5

    Re: Export to Word Document

    That's great, thanks very much indeed for your help, I wouldn't have had a clue how to do that.

    Thanks again.

  8. #8
    Registered User
    Join Date
    08-07-2010
    Location
    Cheshire, England
    MS-Off Ver
    Excel 2007
    Posts
    5

    Re: Export to Word Document

    One more question, how do I get the progress sheet to update when I create a new entry on a new row?

    Thanks.

  9. #9
    Registered User
    Join Date
    08-13-2010
    Location
    USA
    MS-Off Ver
    IA
    Posts
    1

    Re: Export to Word Document

    Hey user i just want to know how to do work in ms word for web designing is it helpful?

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1