Posts by Andy Fields

  • Bowen and Groves M1 ERP software & communciation with Excel via VBA

    Re: Bowen and Groves M1 ERP software & communciation with Excel via VBA


    I'd enter this into the address field at the bottom of the edit hyperlink window in excel.


    For some reason I can't attach or add a screen dump of the window to show you, but hopefully you know what I mean.


    It works fine, and in this example the hyplink would open the purchase order window with what ever order number I substituted for xxxxxx

  • Bowen and Groves M1 ERP software & communciation with Excel via VBA

    Re: Bowen and Groves M1 ERP software & communciation with Excel via VBA


    OK, thansk for the advice.


    I had hoped that it was something I could easily (ish) do as I know the address/syntax to hyperlink to (for example) a specific purchase order. I had assumed that it would just be an extension of that address to get the info from one of the fields in that page.


    If it's any use the address would be M1:Object:PO:xxxxxx, substituing the PO for whatever screen you wanted to look at.


    Thanks
    Andy

  • Bowen and Groves M1 ERP software & communciation with Excel via VBA

    Hi,


    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!
    Andy