Search results

  1. B

    Solved Is there a way to automate the manual replacement of multiple linked files?

    Hey guys, I've built a DB process for our team which automates manual monthly reporting. The problem is that it uses 3 linked text files which live in our network drive, and each of them has to be replaced for every separate worksheet. The report in total generates 22 worksheets so after each...
  2. B

    Solved VBA code which exports data from Access to Excel and then loops through the Excel file

    Hey guys, I have a couple of VBA loops that work in the blink of eye when I execute them through Excel, but doing this as part of an Access VBA application takes like 15 minutes. The loops run through each row and check to see if multiple conditions are met, and if they are they change the...
Top Bottom