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)
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)