I've been a reader of these forums for a while now, though this is my first actual post. I couldn't find a suitable sub forum for my request, so apologies if this is in the incorrect forum.
I've pretty much taught myself Excel VBA over the past few months and though I wouldn't say I'm an expert by any stretch of the imagination I would say that I know what I'm doing.
My request concerns our ERP software, M1 by B&G (Bowen and Groves) and at the moment the only way we have of getting data out if is to export to an excel file, which can be cumbersome. I assume that I can use objects to "speak" direct to M1, but object handling for applications is something I know very little about. I think I can identify the field names, etc from looking into the code of the various screens that are used but I do not know what the syntax would be for communicating with them and pulling out the data.
Do anyone on this forum have any experience with the M1 ERP software?
Thanks in advance!