topic Could Alfresco alter Excel macros ??? in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/could-alfresco-alter-excel-macros/m-p/150999#M105799 <HTML><HEAD></HEAD><BODY><SPAN>Hello,</SPAN><BR /><BR /><SPAN>I use Alfresco in a production environment (Alfresco 2.1 community in a RedHat environment and mysql database) since last january.</SPAN><BR /><SPAN>I have more or less 50 users that contribute to documents, and almost 300 that consult them.</SPAN><BR /><SPAN>In their majority, they use the CIFS access to update and create documents.</SPAN><BR /><BR /><SPAN>The problem is that in some cases, </SPAN><STRONG>some macros in Excel documents seem to be altered</STRONG><SPAN> when saved in Alfresco. These Excel documents contain a lot of macros, and are protected with a password.</SPAN><BR /><SPAN>I haven't been able to reproduce the problem, but it occurs regularly.</SPAN><BR /><BR /><SPAN>Here is an altered macro example:</SPAN><BR /><PRE class="language-none line-numbers"><CODE>Sub Init_Ga()<BR />Attribute Init_Ga<BR />Attribute Init_Ga<BR />'<BR />' Init_Ga<BR />' Macro enregistrée le 21/02/2007 par G. Abbé<BR />'<BR />Dim i As Integer<BR />Dim j As Integer<BR />Dim NbreLignesAvancement As Integer<BR />Dim DateDebut As Single<BR />Dim DateFin As Single<BR />Dim Debut, Fin As Date<BR />Dim Avancement As Single<BR />Dim Reponse As Varia<BR />Dim JoursTotal, JoursResta<BR /><BR />'Pas de mise Ã&nbsp; jour de l'écran (permet d'accélérererertraitement de la macro)<BR />Application.ScreenUpdating = False<BR /><BR />' Récupération des dates globales d'établissement du Ga<BR />'Worksheets(Ga<BR />DateDebut = Worksheets("Ga<BR />DateFin = Worksheets("Ga<BR /> …..<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE><STRONG> Everywhere you see the word "Ga" (init_ga, worksheets("Ga ….) , it should be the word "Gantt"</STRONG><SPAN> and the macro doesn't compile!!! </SPAN><BR /><BR /><SPAN>It can happen too that caracters are added :</SPAN><BR /><PRE class="language-none line-numbers"><CODE>Dim i As Integer<BR />Dim jjjjjjjjjjjjjjjjjjNbreLignesAvancementjjjjjjjjjjjjjjjjjDateDebutjjjjSingle<BR />Dim DateFinjjjjSingle<BR />Dim Debut, FinjjjjDate<BR />Dim AvancementjjjjSingle<BR />Dim Re<BR />Dim JoursTotal, JoursRestant, JoursConsojjjjSingle<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE><STRONG>The "j" caracters shoudn't exist !!!</STRONG><BR /><BR /><BR /><SPAN>I am suspecting it could come from the indexation mecanism, what do you think about that ? Could it really come from Alfresco ?</SPAN><BR /><SPAN>It is a very serious problem because my users are now afraid of storing documents in Alfresco and are beginning to stop using it …</SPAN><BR /><BR /><SPAN>Thank you for your answers or advices, I really don't know where to search to solve this problem.</SPAN></BODY></HTML> Fri, 11 Apr 2008 12:19:38 GMT jpinheir 2008-04-11T12:19:38Z Could Alfresco alter Excel macros ??? https://connect.hyland.com/t5/alfresco-archive/could-alfresco-alter-excel-macros/m-p/150999#M105799 Hello,I use Alfresco in a production environment (Alfresco 2.1 community in a RedHat environment and mysql database) since last january.I have more or less 50 users that contribute to documents, and almost 300 that consult them.In their majority, they use the CIFS access to update and create documen Fri, 11 Apr 2008 12:19:38 GMT https://connect.hyland.com/t5/alfresco-archive/could-alfresco-alter-excel-macros/m-p/150999#M105799 jpinheir 2008-04-11T12:19:38Z Re: Could Alfresco alter Excel macros ??? https://connect.hyland.com/t5/alfresco-archive/could-alfresco-alter-excel-macros/m-p/151000#M105800 <HTML><HEAD></HEAD><BODY><SPAN>Hello,</SPAN><BR /><SPAN>No answer ? I'm only looking for ideas …</SPAN><BR /><SPAN>Could it come from POI ? Is POI able to write into files saved in Alfresco ?</SPAN></BODY></HTML> Wed, 16 Apr 2008 12:58:52 GMT https://connect.hyland.com/t5/alfresco-archive/could-alfresco-alter-excel-macros/m-p/151000#M105800 jpinheir 2008-04-16T12:58:52Z