LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 4
Default File exists but cannot open from Excel

Hi,

Hope someone can help and that this is the correct place to post. Have
tried searching through google groups and MSDN.

I am using Excel 2003 and using vba to store a list of files (as
strings on a spreadsheet) from a server location. I then allow users
to search the file with Ctrl+F and open the file based on the name.

Over 30,000 files and a year of using it and no problems until today.
One .xls file will not open. Have opened the file through explorer
manually with no problem and no one else has it open. If I create a
hyperlink on a spreadsheet with the full server path etc, the
hyperlink doesn't work in the same way that workbooks.open doesn't and
ShellExecute doesn't also, same error cannot find file.

Have tried proving to myself that each of procedures are correct, i.e.
have tried one procedure each with workbooks.open, ShellExecute &
ActiveWorkbook.FollowHyperlink. I have tested the string by using
FileSystemObject.FileExists which returns true and I can Set a
dimension as the file and return all its properties like date
modified, name etc. and the .path matches the string.

Any ideas? Only seems to happen if the file is on a server location,
i.e. I copied the entire folder to my c: drive and works fine. I have
used GetFolder to prove that the folder can be opened using the
string.

Any help or possible known issues/resolutions that I can try would be
apreciated.

Thanks

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Macro in Excel using an Array to Delete File in Directory if it Exists Matt[_40_] Excel Programming 3 February 2nd 07 03:16 AM
Check if file exists / open it Gert-Jan Excel Programming 2 August 28th 06 04:20 PM
In Excel - Use Windows Explorer instead of File Open to open file KymY Excel Discussion (Misc queries) 1 August 5th 06 09:59 PM
How to programmatically test whether VBA code exists in an Excel file Paul Martin Excel Programming 7 July 3rd 06 06:25 AM
check if a file exists / is open Mark Kubicki Excel Programming 1 December 4th 03 05:56 PM


All times are GMT +1. The time now is 01:29 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"