Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Programming / May 2006

Tip: Looking for answers? Try searching our database.

Workbooks.Open fails when using a full network path....

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
WATYF1@gmail.com - 19 May 2006 15:03 GMT
Hi there. I've got some code that does various things, among them,
opening an Excel file. Here's a little snippet of relevant code:

          FilePath = "\\servername\share\folder\"
          FileName = "template.xls"

          Set aXL = CreateObject("Excel.Application")
          With aXL
               .Visible = False
               .Workbooks.Open FilePath & FileName
          End With

Here's the problem. When I run this on a machine using Office 2000, it
works just fine. When I run in on a machine using Office 2003, it gives
me this error:

"Open Method of Workbooks class failed"

Now... on Office 2003, if I change the "FilePath" to the *mapped*
network drive for the same folder (i.e. "S:\folder\"), then the code
works just fine. It's only when I try to use the full network path of
the same location that the code fails. But it works either way on
Office 2000. I need to be able to use the full path so this can be run
on different machines that may not have the same share mapped to the
same drive letter.

My question is, is this due to some kind of new network security
setting in Office 2003? If not, is there something else that would be
causing this?

WATYF
Ivan Raiminius - 19 May 2006 15:44 GMT
Hi,

using WinXP, Office2003

I cannot reproduce the behaviour. In other words, I am able to open
workbook using this statement:

workbooks.Open filename:="\\unxcz0002\common\controlling\TC file
specification.xls"

Are you sure you have correct path?

Regards,
Ivan
WATYF1@gmail.com - 19 May 2006 16:26 GMT
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
Ivan Raiminius - 19 May 2006 17:09 GMT
Hi,

I used late binding, Word.

Regards,
Ivan
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.