Macro

[excel 2003]

Hi all,
I have just migrate from office XP to office 2003. I have some pbs with macro in excel 2003. The same file work well in excel XP.

in excel 2003 th macro is not evaluated, il display the path:

='E:\\Program Files\\Microsoft Office\\OFFICE11\\MACROLIB\\Analyse\\ATPVBAEN.XLA'!EOMONTH(B3;0)

instead of =EOMONTH(B3;0)

Someone can help me ????

 

[G.David]

My english=Null


il display the path:

='E:\\Program Files\\Microsoft Office\\OFFICE11\\MACROLIB\\Analyse\\ATPVBAEN.XLA'!EOMONTH(B3;0)

'E:\\Program Files\\Microsoft Office\\OFFICE11\\MACROLIB\\Analyse\\=path(repertoire)
ATPVBAEN.XLA'= file (macro complementaire)
!EOMONNTH +/- sheets or Function
(B3;0)=cells?
Sorry
Cordialement
G.Davvid

 

[dg62]

hi,


Installing the Analysis ToolPak add-in
The Analysis ToolPak is implemented as an add-in. Before you can use it, you need
to make sure that the add-in is installed. Click the Tools menu. If you see a menu
item labeled Data Analysis, the Analysis ToolPak is installed. If you don’t see the
Data Analysis menu item, install the add-in by following these steps:
1. Select Tools➪Add-Ins to display the Add-Ins dialog box.
2. Place a check mark next to Analysis ToolPak.
3. Click OK to close the Add-Ins dialog box.



'Excel 2003 Bible' de John Walkenbach

Message édité par: dg62, à: 22/07/2005 08:41

 

[G.David]

Salut Didier
peut traduire ce qu est plus haut (j'aime bien comprendre) et là j'ai pas tout suivi
Cordialement
G.David

 

[dg62]

Salut G.David


j'ai simplement fait un copier coller d'un paragraphe de bouquin anglais 'Excel 2003 Bible' de John Walkenbach sur la façon d'activer l'utilitaire d'analyse afin que la fonction fin.mois (eomonth) fonctionne. Son problème vient sans doute de là.


Because my english is not terrible !

 

[G.David]

You You You you You
(t'as vu y'en a cinq)
merci
Cordialement
G.David