fichier modèle xltm

%3CLINGO-SUB%20id%3D%22lingo-sub-1488839%22%20slang%3D%22fr-FR%22%3Exltm%20model%20file%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1488839%22%20slang%3D%22fr-FR%22%3E%3CP%3EHello%3C%2FP%3E%3CP%3EI%20work%20with%20a%20model%20file%20.xltm%20(which%20I'm%20not%20the%20creator%20of)%2C%20on%20my%20windows%20computer%20at%20the%20office%20everything%20is%20going%20very%20well.%3C%2FP%3E%3CP%3EThis%20same%20file%20opened%20on%20my%20mac%20(home)%20poses%20me%20problem%20for%20registration.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFor%20the%20recording%2C%20I%20have%20to%20do%20it%20by%20clicking%20on%20a%20flag%20(lying%20on%20the%20model)%20and%20I%20then%20have%20to%20decide%20the%20location%20because%20it%20renames%20itself%20and%20registers%20in%20.xlsm%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBut%2C%20on%20my%20pimp%2C%20when%20I%20click%20on%20the%20flag%2C%20an%20excel%20window%20asks%20if%20I%20want%20to%20save%2C%20I%20say%20%22yes.%22%20And%20there%20I%20have%20an%20error%20message%20(see%20attached%20photo)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20guess%20it's%20either%20a%20mac%20problem%20or%20a%20setting%20to%20make...%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20anyone%20can%20help%20me%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1488839%22%20slang%3D%22fr-FR%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1489312%22%20slang%3D%22en-US%22%3ERe%3A%20fichier%20mod%C3%A8le%20xltm%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1489312%22%20slang%3D%22en-US%22%3EExactly%20this%20problem%20is%20described%20on%20Ron%20de%20Bruin's%20site%3A%20%3CA%20href%3D%22http%3A%2F%2Fwww.rondebruin.nl%2Fmac%2Fmac016.htm%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttp%3A%2F%2Fwww.rondebruin.nl%2Fmac%2Fmac016.htm%3C%2FA%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1491299%22%20slang%3D%22fr-FR%22%3ERe%3A%20xltm%20model%20file%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1491299%22%20slang%3D%22fr-FR%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F22322%22%20target%3D%22_blank%22%3E%40Jan%20Karel%20Pieterse%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20for%20your%20reply.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20not%20sure%20if%20i%20understood...%3C%2FP%3E%3CP%3EIf%20i%20am%20not%20the%20%22creator%22%20of%20the%20file%2C%20can%20i%20change%20the%20macro%3F%3C%2FP%3E%3CP%3EI%20don't%20have%20the%20access%20on%20VBA...%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1491730%22%20slang%3D%22en-US%22%3ERe%3A%20fichier%20mod%C3%A8le%20xltm%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1491730%22%20slang%3D%22en-US%22%3EIn%20that%20case%20you%20would%20need%20to%20contact%20the%20author%20of%20the%20VBA%20code%20and%20ask%20him%2Fher%20to%20update%20the%20code%20using%20the%20sample%20code%20I%20pointed%20to.%3C%2FLINGO-BODY%3E
New Contributor

Bonjour,

Je travaille avec un fichier modèle .xltm (dont je ne suis pas la créatrice), sur mon ordinateur windows au bureau tout se passe très bien.

Ce même fichier ouvert sur mon mac (à domicile) me pose problème pour l'enregistrement.

 

Pour l'enregistrement, je dois le faire en cliquant sur un drapeau (se trouvant sur le modèle) et je dois ensuite décider l'emplacement car il se renomme lui tout seul et s'enregistre en .xlsm

 

Mais, sur mon mac, quand je clique sur le drapeau, une fenêtre excel demande si je veux enregistrer, je dis "oui". Et là j'ai un message d'erreur (voir photo ci-jointe)

 

Je suppose que c'est soit un problème de mac ou un réglage à faire...

 

Si quelqu'un peut m'aider 

3 Replies
Exactly this problem is described on Ron de Bruin's site: http://www.rondebruin.nl/mac/mac016.htm

@Jan Karel Pieterse 

Thank you for your reply.

 

I am not sure if i understood...

If i am not the "creator" of the file, can i change the macro ?

I don't have the access on VBA...

 

 

 

In that case you would need to contact the author of the VBA code and ask him/her to update the code using the sample code I pointed to.