Search results

  1. O

    can't close Excel from VBA

    I am writing code to open many Excel files, retrieve data, and populate Access tables. However, there is always one instance of Excel still running in my "processes" in task manager (doesn't show up in "applications") -- i just can't get it to close. Any help would be greatly appreciated...
  2. O

    transferspreadsheet doesn't go in order???

    I am transfering chunks of data from Excel into Access tables using the transferspreadsheet command. I will be looping through many XL files and creating and/or updating approx. 35 Access tables from each XL. The XL files have a specific order to them. When I transfer the specified range to...
  3. O

    how to set field properties in VBA

    Hi, I am creating (successfully :D ) lots of tables with VBA. I need to be able to set the property called "Required" to False or No. Is there a command to do this? thanks
Back
Top Bottom