appactivate is not working

[bruno1970]

hi,
thanks for letting me join this community.
i am very curious about vba, but my knowlwdge is very little.
1. i´d like someone to explain me why instruction APPACTIVATE doesn't work on my excel2013.
2. is this or is this not an excel2013 instruction?
3. my goal is to activate excel no matter the application i´m working. so, i try to activate excel through appactivate, but it doesn't work.

when i run this code

Sub appactivate()
Dim ms As String
ms = Application.Caption

MsgBox (ms)
appactivate ms' i´ve tried also appactivate "Microsoft excel" and it doesn´t work neither
End Sub

excel returns: compile error. wrong number of arguments or invalid property assignement.
the problem is appactivate because if i take it out, msgbox works.

CAN YOU PLEASE HELP ME??
thank you.

bruno (Portugal)

 

[Smitty]

Welcome to the Board!

What are you trying to do?

All Application Caption is going to do is give you the active Application Caption (E.G. "Book1 - Excel").

 

[bruno1970]

hi smitty,
thanks for your time.
answering to your question, i´m trying to activate the application excel, so i read i could use APPACTIVATE.

Imagine i´m working on an excel file and, time-to-time, excel asks me throught INPUTBOX "what type of music are you listening?" (if you want, i send you the code).
however, if i´m not working on an excel file, the message (INPUTBOX "what type of music are you listening?") is not shown because excel is not active at that moment nor activates excel because APPACTIVATE is not recognized by excel2010/2013.

i´ve also tried this code (and others i copied from Microsoft):


appactivate "Microsoft excel"

and it doesn't run (nor VBA changes it to AppActivate), warns for an error and i don't understand why.

please, what´s the problem?? how can i do what i want??

thank you for your help.

Bruno