Excel VBA code to open other applications

[squeakums]

I was trying to find code in excel macros that can open other apps for example, open Access DB and run a macro in it.

Also,

Open Google Chrome and go to a link.

I tried several codes I found online but those didn't seem to work for me. Any advice?

Thanks.

 

[Yongle]

works for me...

Sub Chrome()
    Dim WebUrl As String
    WebUrl = "https://www.google.co.uk/"
    Shell ("C:\Program Files (x86)\Google\Chrome\Application\chrome.exe -url " & WebUrl)
End Sub

 

[Yongle]

I was trying to find code in excel macros that can open other apps for example, open Access DB and run a macro in it

Linked video below explains clearly how to use VBA in Excel to Extract Data from an Access Database and place that data in a worksheet

 

[Paul Ked]

Two ways of opening Access and running a macro:

Sub OpenAccess()
    With New Access.Application
        .OpenCurrentDatabase "C:\MyDBase.accdb"
        .Visible = True
        .DoCmd.RunMacro "MyMacro"
'If you want to close it when done...
        .CloseCurrentDatabase
    End With
End Sub

Sub ShellAccess()
    Dim Arg As String
    Arg = "C:\MyDBase.accdb /X MyMacro"
    Shell "C:\Program Files\Microsoft Office\root\Office16\MSAccess.exe " & Arg
End Sub

 

[squeakums]

For the first code above I get that annoying "user defined type not defined" ? When I run at this part:
Sub OpenAccess()
With New Access.Application

 

[Yongle]

For the first code above I get that annoying "user defined type not defined" ?

That is because VBA has not been told how to read Access commands
It's illustrated in the video linked in post#3 -which is worth watching to help you understand the code provided by @Paul Ked

In VBA \ click on Tools \ References\ Scroll down to Microsoft Access object library\ Tick the box \ OK

 

[squeakums]

That is because VBA has not been told how to read Access commands
It's illustrated in the video linked in post#3 -which is worth watching to help you understand the code provided by @Paul Ked

In VBA \ click on Tools \ References\ Scroll down to Microsoft Access object library\ Tick the box \ OK

Thank you past that part, now getting the error, already have the database open? And, I don't?

 

[Paul Ked]

It could be the lock file hasn't been deleted.

 

[Paul Ked]

 

[squeakums]

I checked the folder and there is no lock file there for that Access DB name?