The Tamer
Well-known Member
- Joined
- Jun 10, 2004
- Messages
- 520
Hi
the line:
Dim MyResponse As VbMsgBoxResult
which works on Excel 2000, is not working on Excel 97 (which we have at work). I'm getting the error:
Compile Error: Automation type not supported in Visual Basic.
Is there a 97 equivalent or a workaround?
Cheers
the line:
Dim MyResponse As VbMsgBoxResult
which works on Excel 2000, is not working on Excel 97 (which we have at work). I'm getting the error:
Compile Error: Automation type not supported in Visual Basic.
Is there a 97 equivalent or a workaround?
Cheers