November 06, 2010

more on vba problems in excel for mac 2011

there are problems related to vba being found after i installed excel for mac 2011 on my machine. not 100% excel coded in excel for windows 2007/2010 with common features (i.e. not include active-x or ribbon change) is accepted in excel for mac.

there’s a bug in instr function which makes excel for mac out of memory. when you use an if function & one of its criteria is based on result of instr function, it fails. the code is like below:

if instr(1, cells(x,y), zzzz, 1) = 0 and cells(a,b) = “ccc” 

end if

another scene is if the cells are filled with date, the date format is affected & overridden by mac os x language setting. vba cannot detect those fields either or make excel out of memory.

and when you make changes in excel for mac, digital cert included in the spreadsheet is lost & you need to mount it back in windows version again before you can make the code live again.

No comments:

Post a Comment