abhay_547
04-11-2010, 04:25 AM
Hi All,
I have created some toolbars for essbase connection. I won't a macro which will check whether there is any workbook which currently open or not. If there is no workbook open then macro should have code line which will show a message to the user that there is no workbook currently open and he can't run a macro. I have got a macro which check whether a particular workbook is open or not but it becomes specific because i will have to mention the name of the workbook. I want a macro code which will check whether any workbook is open or not. Please expedite. Thanks a lot for your help in advance.
I have created some toolbars for essbase connection. I won't a macro which will check whether there is any workbook which currently open or not. If there is no workbook open then macro should have code line which will show a message to the user that there is no workbook currently open and he can't run a macro. I have got a macro which check whether a particular workbook is open or not but it becomes specific because i will have to mention the name of the workbook. I want a macro code which will check whether any workbook is open or not. Please expedite. Thanks a lot for your help in advance.