View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Norman Jones[_2_] Norman Jones[_2_] is offline
external usenet poster
 
Posts: 421
Default 1004 Error on Workbooks.Open when run from inside IE

Hi DS,

Correcting a typo, perhaps, also remove
the argument names:

xlApp.Workbooks.Open TargetPath & TargetBook, , , "xxx", "xxxx"



---
Regards.
Norman

"Norman Jones" wrote in message
...
Hi Ds,

Without seeing the preceding code, I would
suggest that you try replacing

Workbooks.Open ...


with something like:

xlApp. Workbooks.Open ...



---
Regards.
Norman