Recent content by Batty

Guys, Just a thought but why not create a batch file and use shell to run it on dbclose. If you go into Command type shutdown /? and it will give you a list of args you can use i.e -f forces running aps to close. Batty

Hi, This has info on how to close another running app from access. then you can just kill the file. http://www.mvps.org/access/api/api0025.htm Batty

Guys, Thanks for the ideas but niether of them worked. i know its the line DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9, "MyOne", strFile, True, strRange, True Do you guys know any other ways of Copying a spreadsheet appart from DoCmd.TransferSpreadsheet ? or weather i need...

Hi Guys, I created a module to import all of the worksheets from a static list of excel files. However when the program finnishes excel is still running as a process. my code is Sub ImportExcelData() Dim strFile As String Dim strFilter As String Dim objXL As Object Dim objXLWB As...

Phil, Before you get started you should use the P&P method. This involves getting a pen, a bit of paper and writing down all of the information you need to store. Then next to them write what type of data they are. I.E Text, Number, Date etc. Then write down how often this information will...