try this video
Follow Hyperlink

Were there spaces in the folder name?

Tell us what you have tried and what the errors were.

To open a file, you need to reference the fully qualified path of the file.  E.g.:  D:\My Documents\Work\2024\Book1.xlsx  .  You need to store the full path somewhere in your database in order to do this.

In one of Richards videos he'd rather you to not use Hyperlinks. Says they lead to trouble.

I'll get the error messages for each of the ways I've tried. But I'll need to replicate what I'd done -- be back in a min.

Now a forum question -- Can I quote each individual reply so I can reply directly to each post on this forum like you can with a phpBB forum for instance?

Nope

With FollowHyperlink you are sending in the address as a string.

    FollowHyperlink Address As String [Then Some Optional Parameters]

Ok Thanks Alex
Kevin here is the error i get using this code

Sub OpenProjectWorkbook()
'Opens an excel workbook'
Dim objExcel As Excel.Application
Dim objBook As Excel.Workbook
Dim objSheet As Excel.Worksheet
Dim objRange As Excel.Range
Dim intCol As Integer

  Set objExcel = CreateObject("Excel.Application")
  Set objBook = objExcel.Workbooks.Open("C:\Users\Owner\Desktop\CAL_DATE.xlsx")
   Set objSheet = objBook.Worksheets("Sheet1")
   For intCol = 1 To 3
   Set objRange = objSheet.Cells(1, intCol)
   Debug.Print objRange.Value
   Next
  
  
   Set objSheet = Nothing
   Set objExcel = Nothing
   Set objBook = Nothing
  
  
End Sub

----

The error dialogue box says

This file is not in a recognizable format

.If you know the file is from another program which is
incompatible with Microsoft Office Excel, clickCancel, then
open this file in its original application. If you want to open
the file later in Microsoft Office Excel, save it in a format that
is compatible, such as text format.
.If you suspect the file is damaged, click Help for more
information about solving the problem.
.If you still want to see what text is contained in the file, click
OK. Then click Finish in the Text Import Wizard.

when i press OK and run debug it highlights

Set objSheet = objBook.Worksheets("Sheet1")

I've referenced Microsoft Excel 12 object library

I think Alex has solve why my SHELL function wouldn't work in the folder. I renamed the folder with an underscore and now the SHELL function works -- Thanks Alex

Working my way through the Hyperlink video linked by Sami -- will check that and report back tomorrow Thanks all for now all -- got a way to go so don't go too far away -- I still need help ( well my workmates say that about me )