[RESOLVED] Old code throwing out random error

[r0k3t]

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.

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!

[r0k3t]

Never mind - I found it... Somehow the reference to Excel went bye bye!

Hmmp... Weirdness.