OLE Automation Error

greenspun.com : LUSENET : MW Software's Visual BASIC Descusion System : One Thread

Running VB 4, I'm receiving the following error message when running the code displayed below. ERROR MESSAGE: OLE AUTOMATION Error

Dim NashXl As Excel.Application Dim oWkbk As Workbook Set NashXl = CreateObject("excel.application") Set oWkbk = Workbooks.Open("H:\projects\0000.xls") NashXl.Workbooks.Add NashXl.Range("C5").Value = "We made it!" NashXl.Visible = True

-- Terry Ward (tward@caremark.com), March 29, 2000


Moderation questions? read the FAQ