Navision and MS-Excel

Durand

I am a young user of Navision. When I one makes copy to stick of a table Navision or board Navision towards a Excel Sheet, the data type of value is not recognized by Excel (like decimal). I tried to realize a macro in VB, without excess of success. There is it a method to import data of tables towards Navision.
Thank you.

Je suis un jeune utilisateur de Navision. Lorsque je fait un copier coller d'un tableau ou table Navision vers un tableau Excel, le format des valeurs n'est pas reconnu par Excel ( comme décimal). J'ai tenté de réaliser une macro en VB, sans trop de succès. Il y a t-il une méthode pour importer des données des tables vers Navision.
Merci.

Benoît Durand
IDEAA, Angers, France
formateur@ideaa.com

Luc_VanDyck

Download this example "Multi-page Report with Excel formatting" from the download section.

just_user

Try to go to the Control Panel-> Regional Options->Numbers : Decimal Symbol must be the same as NAVISON ( for example '.')
Digit Grouping Symbol - too. ( for example ',') , and Currency options must be the same as Numbers options( Decimal Symbol and Digit Grouping options). After then try to copy to the EXCEL again. <img border="0" title="" alt="" src="images/smiles/icon_smile.gif" />

mfabian

see also:
http://www.navision.net/forum/topic.asp?TOPIC_ID=1318&FORUM_ID=26&CAT_ID=3&Topic_Title=Tips%26Tricks%3A+Excel+Automation&Forum_Title=Attain%2FFinancials+%2D+Tips+%26+Tricks

---

With best regards from Switzerland

Marcus Fabian