[RESOLVED] Old code throwing out random error

Hi there,

I have an old access 2000 app that has been working for years. I have updated and modified it over that time but not recently - All of the sudden I went to use it and blamo! I get this error message

Runtime error '424' - Object required.

The code looks like this.

Code:

x = 2 strSQL = "Select * from tblStudyNumbers" Set db = CurrentDb Set rs1 = db.OpenRecordset(strSQL) Set mybook = Workbooks.Open(Filename:="g:\prntshop\online\indextemplate.xls")

I have office 2007 but I have had that for a while now. I am totally stumped, it breaks on the line Workbooks.Open, I checked that the file is there and that i can open it in Excel.

I am stumped - anyone run into something like this before?

Thanks!