Silly Error Question (sub not defined)

[Lukums]

Hello,

Been getting sub or function not defined when using:

Outlook.Application
IsAppRunning

Does anyone have ideas I'm pulling my hair out, chances are it's something in tools/references but I'm confident I have what's required ticked...

Luke

 

[JLGWhiz]

Hello,

Been getting sub or function not defined when using:

Outlook.Application
IsAppRunning

Does anyone have ideas I'm pulling my hair out, chances are it's something in tools/references but I'm confident I have what's required ticked...

Luke

That error usually pops up when VBA is expecting a procedure call but does not recognize whatever appears in the code on the line that is highlighted when you click debug, or it cannot find a macro by the name you have used, like 'IsAppRunning', in the public code modules of the host workbook.

 

[Lukums]

That error usually pops up when VBA is expecting a procedure call but does not recognize whatever appears in the code on the line that is highlighted when you click debug, or it cannot find a macro by the name you have used, like 'IsAppRunning', in the public code modules of the host workbook.

Hello,

I understand that completely.

However this happens for example:

Sub test()

Dim outobj = outlook.application

end sub

Which still generates an error.

It's like it doesn't like these, I've fixed it before but I have no idea what I did or when I did it to reference.

 

[Norie]

What is the code actually meant to do?

Are you trying to get/create an instance of Outlook?

 

[JLGWhiz]

this might be better

Dim outobj As Objecdt
Set outobj = CreateObject(outlook.application)