Gurunathan
5th July 2018, 09:16
Hi BaaNBoard team,

Good day…

I need your team support on for developing Excel VBA tool. Basically, am a VBA Developer in my flex organization. We are using baan for our planning & Inventory.

My team has given a new requirement saying that to upload the Data & Update the data’s to BaaN using Excel VBA. I hope it’s possible. I really need on help to develop the Excel VBA Code for Uploading & Updating the BaaN Session Fields.

Can you please help me to get the VBA Codes or Any Sample Codes or Any Sample Macros. Thanks in advance

mark_h
7th July 2018, 16:51
Yes - it is possible, I would search this forum for examples and what you can find. You can also call baan libraries that run AFS type code. Never used any of this myself, but I know it is possible.

Gurunathan
9th July 2018, 05:50
Thanks Mark,

Can you share me VBA codes Examples ..

mark_h
9th July 2018, 14:18
Just search this forum for VBA and start reading. That is about the best I can offer since I have never really used VBA for anything official. I played with it a little bit, but not a whole lot.

Ajesh
31st August 2018, 08:45
How are you planning to do? to export from VBA to any csv format or xml format?

Reading from csv is one way, converting it into a BOD and then reading from BOD is another...