View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Philippe PERON Philippe PERON is offline
external usenet poster
 
Posts: 2
Default EXCEL automation ACCESS VIOLATION vb

Hello,

the following lines of code work on a WIN XP / EXCEL 2002 machine but
not on a WIN2K / EXCEL 2000 one. I get an ACCESS VIOLATION error and
an "error log is being created" by Dr. WATSON ... all this on a
Workbooks.Open statement ...

ExcelFilePath value is C:\TMP\Equipment_List.xls

-------------------------------------
Dim exApp As Excel.Application

Set exApp = New Excel.Application
exApp.Workbooks.Open ExcelFilePath
-------------------------------------


Thx,
Philippe.