Search results

I decided to switch the computer off as I'd had enough of it for today and found that there must have been another instance of Excel running. After restarting everthing worked fine. Many thanks to all that have helped.

No its still read-only and opens with a message:- File in use Names.xls is locked for editing Could it be something to do with the line: xlApp.Visible = True Does this in some way lock the file as if there was another user.

I'm afraid this code gives still opens the spread sheet in Read-Only. Sorry for this, as you may have guessed I'm pretty new to this sort of programming. Many thanks.

Many thanks for your reply. I have got it working with the following code, the only slight problem is that it opens the excel sheet in read-only. Is there a way around this please? Dim db As DAO.Database 'Set db = DAO.DBEngine.Workspaces(0).OpenDatabase( _ "C:\database.mdb") Set db = CurrentDb...

Please forgive me if I’m doing something wrong as this is my first posting, I am completely new to using forums for advice. I am using the following code to export the result of a query to an excel sheet and would like to pass a parameter to the query “Query2”. If the query contains the...