Romanoff2011
New Member
- Joined
- Mar 16, 2011
- Messages
- 2
I have a problem with a userdefined Ribbon on open the excel file loading data into it with VBA.
Suddenly, during loading data into the worksheet i get a error message.
=> The message box that appears has no words, number or any other information on it. It is a totally blank VBA message box with the 'vbCritical' icon on it (red circle with the white X in it) with 'OK' and 'Help' buttons.
I click on the 'OK' button and the loading continues, everything is loading correct.
[ I load the data from a big txt-file (372MB).]
What it makes me thinking, if the txt-file is much smaller no error message appears.
If i use the 'old'-excel templae without the ribbon, i do not get this error message.
I just found a note in a tm1-forum:
"I have seen cases where the Excel 2007 ribbon is "demolished" when running a (basic) Excel VBA macro."
Source: http://www.tm1forum.com/viewtopic.php?f=3&t=2596
How can this issue be solved ?
How can this error message be avoided?
Thanks for any comments!
Regards,
Roman
Suddenly, during loading data into the worksheet i get a error message.
=> The message box that appears has no words, number or any other information on it. It is a totally blank VBA message box with the 'vbCritical' icon on it (red circle with the white X in it) with 'OK' and 'Help' buttons.
I click on the 'OK' button and the loading continues, everything is loading correct.
[ I load the data from a big txt-file (372MB).]
What it makes me thinking, if the txt-file is much smaller no error message appears.
If i use the 'old'-excel templae without the ribbon, i do not get this error message.
I just found a note in a tm1-forum:
"I have seen cases where the Excel 2007 ribbon is "demolished" when running a (basic) Excel VBA macro."
Source: http://www.tm1forum.com/viewtopic.php?f=3&t=2596
How can this issue be solved ?
How can this error message be avoided?
Thanks for any comments!
Regards,
Roman