open Excel from Access

[jtodd]

Hi simple one

I am trying to open a named excel file from Access ( both 2016 )

I have this Code

Function openexcelfromaccess()
Dim MyXL As Object

Set MyXL = CreateObject("Excel.Application")
With MyXL
    .Application.Visable = True
        .Workbooks.Open "S:\DATABASES\Goodsin2016\RDC\RDC_Schedule.xlsm"
        End With
End Function

I get a debug with "Application.Visable = True" highligted ?

can anyone help - either correcting my code or suggesting a better way!

 

[welshgasman]

Re: open excel

The word is Visible ?

 

[jtodd]

Re: open excel

Doh

Now get error message saying "Compile error sub or function not defined"

 

[welshgasman]

Re: open excel

In that code?, I cannot see why?

 

[jtodd]

Re: open excel

Sorry but it does ??
will have to find another way

 

[Joe4]

Re: open excel

You may need to make a minor edit.
Take a look at this post here: https://access-programmers.co.uk/forums/showpost.php?p=1334508&postcount=4, and see if that makes any difference.
Also, make sure that you have all the appropriate references/libraries selected in Access VBA.

 

[Joe4]

Re: open excel

Note that the Library/Reference that you need to add in your Access VBA would be the "[FONT=&quot]Microsoft Excel Object Library".
Do that from the VB Editor in Access, under Tools --> References.[/FONT]