Hi, the function ArrayFromSheet at a certain point uses the function Evaluate to read in an array. The problem is, in certain cases the variable ExcelDataRangeName may be so long that the whole string cmdString gets longer than the maximum allowed (I think 255), which means that the statement res = Evaluate(cmdString) always returns Error 2015. Maybe there should be some kind of safety check on this. Or maybe it is not necessary to include the workbook name in ExcelDataRangeName?
In my case, ExcelDataRangeName is the following: '[Andamento Fattori luglio-ottobre 2008.xls]27-06-2008'!$C$2:$C$601 Thus ?len(cmdstring) returns 260 Cheers Christian DISCLAIMER: L'utilizzo non autorizzato del presente messaggio รจ vietato e potrebbe costituire reato. Le informazioni e le opinioni contenute in questo messaggio sono inviate dal mittente a proprio nome e non costituiscono una posizione ufficiale di Epsilon SGR. Questo messaggio e' confidenziale e se non e' a Lei indirizzato Le saremmo grati se, via e-mail, ne comunicasse l'errata ricezione al mittente. The information and opinions contained in this message do not constitute an official position of Epsilon SGR and are communicated by the sender in is own name. This message is confidential, if you are not the intended recipient, please notify the sender immediately. The information and opinions contained in this message do not constitute an official position of Epsilon SGR and are communicated by the sender in his own name. This message is confidential, if you are not the intended recipient, please notify the sender immediately. _______________________________________________ Rcom-l mailing list Rcom-l@mailman.csd.univie.ac.at http://mailman.csd.univie.ac.at/mailman/listinfo/rcom-l More information (including a Wiki) at http://rcom.univie.ac.at
