Excel Link

[nicola1]

Hi all,

I have added about 15 links on a form, linking to word and excel documents. The word documents open fine but all of my excel documents pop up with a messae saying the file cannot be open, yet when i just go to the document on my hard drive they all open fine...does anyone have any ideas please. Thanks

 

[ghudson]

Searching the forum is a great way to discover and learn the answers to your Access programming questions.

The OpenFile() function in my Browse [Find a directory or file] will do exactly what you want. It uses the ShellExecute method which will open any file that the users computer can open. The ShellExecute method does not have the problems that the Shell() function has if the file name or direcotry name contains any spaces. The fFindOpenImportFile form and the fScanDirSelectFileFromTable form in my browsing sample will show you two methods to allow the user to "open" a file with the click of a button. You can easily alter the code to my Browsing... button to open the selected file instead of storing the path in a text box.

 

[nicola1]

Yes i always search the forum before i post and have found many solutions that way...unfortunaitely i did not know what the problem was in the first place so could only search 'excel links' and 'links' and came up with nothing suitable.

Thanks for you response, i will have another bash at it

 

[Bat17]

Goto Excel >tools/Options... General Tab, and makse sure that "Ignore other Applications" option is not checked

HTH

Peter the

 

[nicola1]

No its not checked, i cant understand why it won't open though, really annoying. Im only just learning access and have little knowledge of Excel so unsure what it wrong. Thanks for your response anyway.

 

[reclusivemonkey]

Are you using a Drive letter in the hyperlink or a name? For example, my S: drive is referred to as \\scsd\teams on our network.

 

[Bat17]

is it opening from links elswhere OK, from outlook and Word etc.?

Peter