Got an MS Access automation question?

Can't get an Access form or formula to work?

Cant' get some Access VBA right?

Got a database problem to solve but can't quite figure out how to go about it?

Want to do some fancy Access forms, fields or lookups?

I use VBA extensively, to perform some fairly complex system integrations and automation of data Extracts, Transforms, Loads and Informs, using  Access, Excel, Word, Outlook and a range of legacy applications.

Ask your question in the comments and I'll see if I can solve it for you.

Excel questions here

Got an Excel automation Question?

Can't get an Excel formula to work?

Cant' get some Excel VBA right?

Got a spreadsheet problem to solve but can't quite figure out how to go about it?

Want to do some fancy Excel filters, lookups or formatting?

I use VBA extensively (and an occasional recorded macro!), to perform some fairly complex system integrations and automation of data Extracts, Transforms, Loads and Informs, using  Excel, Access, Word, Outlook and a range of legacy applications.

Ask your question in the comments and I'll see if I can solve it for you.

MS Access questions here

Adding a hyperlink from a worksheet in one Excel workbook to a specific sheet/cell of a worksheet in another workbook .... 

how hard can that be?

Easy right?

Sure ... every forum says so ...
Just add the formula
=hyperlink("c:\path name\spreadsheet.xlsx#SheetName!$A$4","Text to display in cell to click")
You can even use UNC paths  
=hyperlink("\\server name\share name\path name\spreadsheet.xlsm#Sheet!B10","Click Me")

Sooo easy ... except when you consistently get  "Cannot open the specified file" each time you click the link

Why?
Make sure you have removed any previously applied hyperlink BEFORE creating your hyperlink formula!
Select the cell with the formula in it, right-click and select "Remove Hyperlink"
NOW (re)create your correctly formed hyperlink formula in that cell (as per all the many forum examples) and BEHOLD! it will probably work now!

Summary
If for some reason there is a failed pre-existing hyperlink attached to the cell, it must be completely removed before applying the cell-formula based hyperlink.