1004 Error on Workbooks.Open when run from inside IE
Hi Norman,
Thanks for your suggestion, unfortunately, preceding with an "xlapp." just
gives me an "Object Required" error.
The code prior to the workbooks.open statement simply defines the TargetPath
and TargetBook - as I said, these work fine from run within Excel, and ok
when stepping through the code when opened in IE, so it doesn't appear to be
these which is causing the problem. For the sake of completion, though, the
full code concerned (edited) is:
TargetPath = "\\server1\shared\Level1\Level2\Level3\DataTables\ "
If Range("Sheet1!C2") = "HeaderRequired" Then
TargetBook = "Table1.xls"
Else
TargetBook = "Table2.xls"
End If
Workbooks.Open Filename:=TargetPath & TargetBook, Password:="xxx",
WritePassword:="xxxx"
|