Building VBA that performs an action using the TextEdit program. This is operating on a Mac with Excel 2004. File path is verified as correct, VBA complies but code generates a run time 5 error on the AppActivate ReturnValue line. Here is the code:
Sub OpenTextEdit()
Dim ReturnValue As Long
ReturnValue = Shell("~Mac 120GB:Applications:TextEdit", 1)
AppActivate ReturnValue
' Other code to run once application is open resides here
End Sub
Even setting the file path to activate Microsoft Word generates the same error.
Thanks in advance.
Sub OpenTextEdit()
Dim ReturnValue As Long
ReturnValue = Shell("~Mac 120GB:Applications:TextEdit", 1)
AppActivate ReturnValue
' Other code to run once application is open resides here
End Sub
Even setting the file path to activate Microsoft Word generates the same error.
Thanks in advance.