Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Referencing "Office Document" based form cell data in Outlook

Status
Not open for further replies.
Grippen

Grippen

Technical User
Sep 3, 2001
24
GB
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")
oExcel.Workbooks.open(C:\Data.xls")
oExcel.Visible = True
oExcel.Workbooks.Add
Set oSheet = oExcel.Workbooks(1).Worksheets("Sheet1")
oSheet.Activate
set oCellData = oSheet.Range("A1")
oCellDat.Value = "Data I want to put in"
 
Status
Not open for further replies.

Similar threads

HuronBaloo
  • Locked
  • Question
Outlook Appointment object - yearly recurring (i.e. anniversary)
Replies
0
Views
122
HuronBaloo
HuronBaloo
asel
  • Locked
  • Question
Copy cell data from excel and paste into portable software application
Replies
0
Views
131
asel
asel
bdwilcox
  • Question
Trying to adapt VBScript to search if machine is in an AD group 6
Replies
8
Views
848
SoftwareRT
SoftwareRT
shilpa2002
  • Locked
  • Question
how to copy data from two excel workbooks into third. merging data based on common field
Replies
3
Views
165
SkipVought
S
PiotrMP006
  • Locked
  • Question
WshShell.Run ("cmd /c start """"..... always return code 0
Replies
1
Views
130
Rick998
Rick998

Part and Inventory Search

Sponsor

Back
Top