Jiwa 7 with Excel VBA

[perry]

Last couple times I had to work with Excel data import, I made Jiwa to import the file instead of calling Jiwa objects inside Excel. It is just much easier that way.

If you have to, it is possible call REST from VBA, few things you need
- MSXML2.ServerXMLHTTP
- ScriptControl (for converting JSON to object)
- If you are dealing with 64-bit version of Excel, you need
https://stackoverflow.com/questions/972 ... l-2010-x64

[Scott.Pearce]

I'd avoid trying to talk to .NET assemblies from VBA (COM). As others have pointed out, there are dragons there. All I can suggest is an alternative approach:

Add an "Import from Excel" button to the sales order entry form ribbon menu.
Clicking the button presents an open file dialog, user selects xls(x) file.
.NET plugin code could then use the Excel objects. I'd even go so far as to dump the xls(x) file straight out to a temp CSV file, then use .NET libraries to work with the CSV data rather than using the Excel objects. Makes it more generic.

[SBarnes]

I have learnt never to disagree with Scott when he is right as this is being made more complicated than it needs to be