View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
[email protected] WATYF1@gmail.com is offline
external usenet poster
 
Posts: 6
Default Workbooks.Open fails when using a full network path....

Yeah... I'm sure on the path. And if I change it to a bad path, I get a
totally different error (file cannot be found. check your spelling,
etc.)

Btw, when you ran your test, did you run it from within Excel and just
use the Workbooks.Open method, or did you run it from somewhere else
(VB app, Word, etc) and create a late-bound instance of Excel (like in
my example)?


WATYF