• VBA Macro Run or Edit Error message in Sage 300 ERP V2017- update 3

    Hi, I get VBE6EXT.OLB could not be loaded when trying to edit or run a VBA Macro created for my client in V2014 we just migrated to V2017. Tried to copy the file VBE6EXT.OLB from: C:\ Program Files (x86) \Common Files\Microsoft Shared\VBA\VBA6…
  • Want to input date for macro

    I recorded a macro and this was the line that was recorded for the date. GLCRE2Fields("DATERUN").Value = DateSerial(2016, 8, 31) I want to be able to input a date and tried this. I tried this below; Date1 = InputBox("What is the month end", "yyyy…
  • trying to run a VBA Macro without Logging to Sage 300 ERP

    I came across a blog post from 2013 that mentions that it is possible to run a sage macro without logging directly into sage using VBA, this could then be automated with task scheduler on windows here is the original blogpost from greytrix: http…
  • Looking for a Sage 300 Macro/VBA Expert.

    Please contact me if you are interested in partnering up. We've been a Sage VAR on the east coast since 2006, and are looking to add more VBA and macro experts to our team. Thanks very much! Kellie Pitt, ERP Practice Manager Brainsell Technologies…