Word doc as INPUT FORM to Excel

    I have a data entry form in Word that is familiar to our users.
    How can I smarten it so that when the Word doc is saved it will update a remote spreadsheet by adding the data as a new line in the sheet?
    I am trying to convert a spreadsheet to mimic the Word doc but of course the users would have to run Excel instead of Word and some don't have it installed (!) or are intimidated by using it instead of the old form.
    I have found many links describing embedding Excel into Word, etc. but this must be invisible to the user and only involve Word...
    Hope this makes some sense... TIA

    I am assuming you are using a UserForm. You would need something similar to this


    Dim xlApp As Object
    Set xlApp = CreateObject("Excel.Application")
    xlApp.Visible = False 'do not make the workbook visible if you do not want users to know what is going on
    xlApp.Worksheets("Data").Select

    Columns("A").End(xlDown).Offset(1, 0).Value = txtUserName.Text 'this will look at the data in column a and look for the first empty cell and input the form data there.


    you would do the same or incorporate a loop to enter the data into the desired numer of cells.


    If you care to give a little more insight into your project I may be able to help further.


    HTH


    Bruce
    [email protected]

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!

Register Yourself Login