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

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"