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
|