Access VBA to open xlsx file

[CLCoop]

Little help please I keep trying this code to open the STATECODE.xlsm file and I do have the Microsoft Excel 16.0 object library selected for tools. If it change the name of the file to any other file it seems to work to include other xlsm.
Option Compare Database

Function OpenExcelFromAccess()
Dim Myxl As Object

Set Myxl = CreateObject("Excel.Application")
With Myxl
.Application.Visible = True
.Workbooks.Open "H:\STATECODE.xlsm"

End With
End Function

 

[Joe4]

Do you need to open the Excel file in VBA?
Whenever possible, I find it preferrable to link my Excel file to an Access Table object. No VBA required to do that, and any updates to the Excel file will be reflected in the Access table.

 

[CLCoop]

smart... I made something hard didn't I... overthinking coding never! Thanks for the rethink.

 

[Joe4]

No worries!
Glad I was able to help.