Referencing Cells in Outlook Form based on Excel Document

[Grippen]

Hello,

I have an Outlook "Office Document" Form collecting data from people. The "Office Document" form is based on Excel. Does anyone know how to write data to cells in the form from data in another Form.

Putting it another way, I want to do as the code below does, but the data is now in a "Office Document" form not an Excel Spreadsheet.

Sub Export data
Set oExcel = Item.Application.CreateObject("Excel.Application&quot
oExcel.Workbooks.open(C:\Data.xls&quot
oExcel.Visible = True
oExcel.Workbooks.Add
Set oSheet = oExcel.Workbooks(1).Worksheets("Sheet1&quot
oSheet.Activate
set oCellData = oSheet.Range("A1&quot
oCellDat.Value = "Data I want to put in"

 

[Databaseguy]

Maybe I'm missing something here, but, assuming your form is open:

oCellDat.Value = me.YourControl Tyrone Lumley
augerinn@gte.net

http://server105.hypermart.net/databaseguy