AnsweredAssumed Answered

Could Alfresco alter Excel macros ???

Question asked by jpinheir on Apr 11, 2008
Latest reply on Apr 16, 2008 by jpinheir

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 documents.

The problem is that in some cases, some macros in Excel documents seem to be altered when saved in Alfresco. These Excel documents contain a lot of macros, and are protected with a password.
I haven't been able to reproduce the problem, but it occurs regularly.

Here is an altered macro example:
Sub Init_Ga()
Attribute Init_Ga
Attribute Init_Ga
' Init_Ga
' Macro enregistrée le 21/02/2007 par G. Abbé
Dim i As Integer
Dim j As Integer
Dim NbreLignesAvancement As Integer
Dim DateDebut As Single
Dim DateFin As Single
Dim Debut, Fin As Date
Dim Avancement As Single
Dim Reponse As Varia
Dim JoursTotal, JoursResta

'Pas de mise à jour de l'écran (permet d'accélérererertraitement de la macro)
Application.ScreenUpdating = False

' Récupération des dates globales d'établissement du Ga
DateDebut = Worksheets("Ga
DateFin = Worksheets("Ga
Everywhere you see the word "Ga" (init_ga, worksheets("Ga ….) , it should be the word "Gantt" and the macro doesn't compile!!!

It can happen too that caracters are added :
Dim i As Integer
Dim jjjjjjjjjjjjjjjjjjNbreLignesAvancementjjjjjjjjjjjjjjjjjDateDebutjjjjSingle
Dim DateFinjjjjSingle
Dim Debut, FinjjjjDate
Dim AvancementjjjjSingle
Dim Re
Dim JoursTotal, JoursRestant, JoursConsojjjjSingle
The "j" caracters shoudn't exist !!!

I am suspecting it could come from the indexation mecanism, what do you think about that ? Could it really come from Alfresco ?
It is a very serious problem because my users are now afraid of storing documents in Alfresco and are beginning to stop using it …

Thank you for your answers or advices, I really don't know where to search to solve this problem.