Search results

  1. E

    Access 2007 VBA - Excel Formatting Automation - Excel Instance Not Closing

    I would still like to understand why it didn't work but I did find a work around. I counted all the rows with values and set my range that way since I knew how many columns there were (and that would never change). So I set my range = (A5:W &lngCounter). Still - if anyone can explain what...
  2. E

    Access 2007 VBA - Excel Formatting Automation - Excel Instance Not Closing

    Hello, I know there have been numerous posts regarding a ghost instance of Excel being left behind (shows up as a process running in task manager) when formatting an Excel file from VBA (access). I am not using late binding and have tried to not leave any piece unattached to an already...
Back
Top Bottom