Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Workbooks.Open fails when using a full network path....
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to see full path name of open workbook? | Excel Discussion (Misc queries) | |||
Names of workbooks - want relative, with no Full Path | New Users to Excel | |||
Workbooks.Open with out full path help needed. | Excel Discussion (Misc queries) | |||
Open Workbook using URL instead of network path | Excel Programming | |||
Excel 2003 Workbooks.Open with CorruptLoad=xlRepairFile fails on Excel 5.0/95 file due to Chart, with Error 1004 Method 'Open' of object 'Workbooks' failed | Excel Programming |