code module

  1. G

    Cells outside the range of cells defined in spreadsheet

    Hi all. Can someone please help with this problem? I have a code module in Access that runs a query that produces a one-record table and that record contains a total. Then the code runs this on an Excel Spreadsheet: DoCmd.TransferSpreadsheet acExport, 8, "TOTAL_TABLE", "SpreadsheetName", False...
  2. S

    Find code module based on sheet name

    I need to use VBA to loop through all sheets in a given workbook, and modify a specific procedure in some of them. The modification script is working fine, and I can identify the sheets easily. But once I have identified the sheet I then need to get the name of the associated code module. As I...

Some videos you may like

This Week's Hot Topics