OLE Automation Errorgreenspun.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 ErrorDim 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