View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
DS DS is offline
external usenet poster
 
Posts: 117
Default 1004 Error on Workbooks.Open when run from inside IE

And the corrected (without argument names) version also just delivers a 424
Object Required both in Excel and IE...

Appreciate the help - even though we seem to be going backwards here!!!

"Norman Jones" wrote:

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